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.

N204BDKavalair LLC Series G · Marion, MTBuilt 1969 · S/N 204 N204BGPrecision Aviation Inc · Kimberly, IDBuilt 1999 · S/N 560-0503 N204CAGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1978 · S/N 501-0283 N204GAirmart Inc · Lexington, KYS/N TH-2042 N204JCentral Beach LLC · El Paso, TXBuilt 1996 · S/N 525-0164 N204JTBarbaro Enterprises LLC · Argyle, TXBuilt 1997 · S/N BB1563 N204MBGreen Top LLC · Reidsville, GABuilt 2015 · S/N FL-1022 N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601 N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115 N204WState Of Wisconsin · Madison, WIBuilt 1998 · S/N FL-204 N204WSPremier Aircraft LLC · East Alton, ILBuilt 1981 · S/N 181 N2050ATia Aeronautics Inc · Harlingen, TXBuilt 1978 · S/N LJ-813 N2050NPerks Andrew · Weatherford, TXBuilt 1978 · S/N E-1429 N2051WLeiwant Alan J · Montville, NJBuilt 1978 · S/N E-1410 N2051XArana Carlos · The Woodlands, TXBuilt 1978 · S/N E-1411 N2057ADesruisseaux Kemens · Clarksville, TNBuilt 1978 · S/N E-1420 N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994 N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516 N205EJLynch Flying Service Inc DBA · Billings, MTBuilt 1998 · S/N BB-1634 N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286 N205MSJustice Air Inc · Farmingdale, NYBuilt 1981 · S/N LJ-948 N205SPState Of Colorado · Englewood, COS/N BB-1826 N205STPate & Pate Air LLC · Andalusia, ALBuilt 1981 · S/N LJ-965 N205TCCarpenter Aviation LLC · Northport, ALBuilt 1994 · S/N 525-0050 N205TMSmitty'S Supply Inc · Roseland, LABuilt 2007 · S/N BB-1991 N2061AMckinney James C · Whitefish, MTBuilt 1978 · S/N E-1425 N2063GHolman Allen S · Knoxville, TNBuilt 1979 · S/N TH-1002 N2064VGta Air Inc · Addison, TXBuilt 1979 · S/N TH-1004 N2065QShalom Isaac R · New York City, NYBuilt 1979 · S/N E-1436 N2066ASky Time LLC · Wilmington, DEBuilt 1979 · S/N E-1431 N2069BCopper Mountain Aviation LLC · Anchorage, AKBuilt 2021 · S/N 208B5657 N2069WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 208B5492 N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466 N206TMPale Horse LLC · Mishawaka, INBuilt 1975 · S/N E-775 N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753 N2071YRossiter Brahm J · Lemoore, CABuilt 1997 · S/N E-3120 N2076LWhaley Keith · Pigeon Forge, TNBuilt 1976 · S/N E-869 N2076RBhms Air LLC · Miami, FLBuilt 2019 · S/N 208B5533 N2079LPlatinum Aviation LLC · Belvidere, TNS/N E-872 N207ACSunflower Aerospace Holdings LLC · Shawnee Mission, KSS/N 500A-1266-89 N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516 N207PDale Aviation · Rapid City, SDBuilt 1995 · S/N LJ-1406 N207RADelta Investment Group LLC · Memphis, TNBuilt 2014 · S/N 208B5098 N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308 N207ZCBuha Holdings LLC · Paris, TXS/N E-3360 N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677 N208Jmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 2002 · S/N 20800363 N20896Mccullar Miles Glenn · Hagerman, NMBuilt 1977 · S/N E-1163 N208ABSkydive Guam Inc · Barrigada, GUBuilt 2008 · S/N 208B2047 N208AJCessna 2080711 Inc Trustee · Wilmington, DEBuilt 1998 · S/N 208B0711

Back to AD 2006-16-18 R1