Skip to content

AD 2006-16-18 R1

Registered aircraft · 11,798

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N71KWAcuff Joseph · Mooresville, NCBuilt 1977 · S/N E-1144 N71LPKapcon Aviation LLC · Houston, TXBuilt 1979 · S/N 5010120 N71MSkyview LLC · Wilmington, DEBuilt 1976 · S/N 88 N71MCMlr Aviation LLC · Newark, DEBuilt 2014 · S/N FL-911 N71PGPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 013 N71PPRoberts Motor Company LLC · Amarillo, TXBuilt 1989 · S/N 560-0007 N71SCWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B0997 N71SYSilver Wing At Sandpoint LLC · Torrance, CABuilt 2014 · S/N 525-0831 N71VTWestern Wings Corp · Roseburg, ORBuilt 1980 · S/N BB-709 N71WBEagle Air Transport Inc · Ottawa, ILBuilt 1974 · S/N LW-127 N71WHGemini 9 LLC · Austin, TXBuilt 1985 · S/N S5500059 N72Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-7 N72007Garvey James T · Dallas, TXS/N E-2170 N7200CCaccavale John J · Oakdale, NYBuilt 1983 · S/N E-2122 N7200NBorgerson Mark J · Montevideo, MNBuilt 1968 · S/N E-12 N7202YBoeing Co · Berkeley, MOBuilt 1984 · S/N FA-12 N7206EEt Aviation LLC · Alcoa, TNS/N LA-234 N7207KWhitehead John · Cresson, TXBuilt 1984 · S/N E-2186 N7207YBig Game Air LLC · Wilmington, DEBuilt 1984 · S/N E-2187 N7208MTahoe Aviation LLC · Reno, NVBuilt 1984 · S/N E-2188 N7208VMeyer Ag Aviation Inc · Whittemore, IABuilt 1984 · S/N TH-1432 N7209BFly By Knight Inc · Hammond, LABuilt 1984 · S/N TH-1428 N720AMKing Eagle II LLC · Grand Blanc, MIBuilt 1999 · S/N BB-1663 N720BCBottorff Air LLC · Atchison, KSS/N FL-274 N720CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1977 · S/N 21298 N720DRCompassionate Concierge Physicians LLC · Longmont, COBuilt 2013 · S/N FL-882 N720FSVero Executive Flyers Inc · Fort Pierce, FLS/N 421C1250 N720FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0452 N720RCRosado Aviaton Inc · Scranton, PABuilt 2007 · S/N 525-0638 N720WCSw Aviation LLC · Wilmington, DEBuilt 1991 · S/N TH 1624 N72100Klein John C · Indianapolis, INBuilt 1984 · S/N E-2196 N72108Osprey 72108 LLC · Macon, GABuilt 1984 · S/N E-2197 N7210CUpupair LLC · Raleigh, NCBuilt 1984 · S/N TH-1431 N7210LPescetti Investigation Services LLC · Carmichael, CABuilt 1984 · S/N E-2215 N72121I Fly Planes LLC · Tulsa, OKBuilt 1984 · S/N E-2202 N7212URegistered aircraftBuilt 1984 · S/N E-2201 N7213MTulip City Air LLC · Pella, IABuilt 1984 · S/N E-2206 N7214DWaheguru Holdings LLC · Corvallis, ORS/N E-2210 N7215AGayler Granville II E · Rio Verde, AZBuilt 1984 · S/N E-2213 N7217HMaine Instrument Flight · Augusta, MEBuilt 1984 · S/N TH-1442 N7218RCourtney James Trustee · Menlo Park, CABuilt 1974 · S/N E-616 N7219HGrandview LLC · Columbus, MSBuilt 1984 · S/N TH-1447 N721BCJh Aircraft Services LLC · Dover, DEBuilt 1990 · S/N 560-0044 N721CFCalspan Corp · Buffalo, NYBuilt 1984 · S/N 429 N721CNUnited Trading Unlimited LLC · Coconut Grove, FLS/N 206 N721CVDvf Ventures LLC · Alapaha, GABuilt 2004 · S/N TH-2078 N721DKRegistration Pending · Fountain Hills, AZRegistration pendingBuilt 1997 · S/N E-3123 N721EAAcellerated Interventional Orthopedics Pllc · Lawton, OKBuilt 1980 · S/N BB-679 N721FDFederal Express Corp · Memphis, TNS/N 477 N721HBBrazilco Aviation LLC · Missouri City, TXS/N 421C0629

Back to AD 2006-16-18 R1