Registered aircraft · 3,126

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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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:2016-05-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
  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:2016-05-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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.

N223ALWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 223 N223CABemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-200 N223EARegal Air Partners I LLC · New Iberia, LABuilt 2005 · S/N 323 N223LHLelah Holdings Limited Partnership · Reno, NVBuilt 1976 · S/N B-223 N2243JR & S Aviation LLC · Corning, ARBuilt 1996 · S/N T41-221 N224CCRanger Aviation LLC · Houston, TXS/N LJ-1218 N224CNRegistered aircraftBuilt 2020 · S/N 802A-0843 N224SAIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1969 · S/N 247 N2251QSabo John W · Spicewood, TXBuilt 1997 · S/N EA-604 N2254LPhoenix Equipment Lc · Nickerson, KSFirst renewal noticeBuilt 1985 · S/N 400-0611 N225CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 31T-8104024 N225JCJetcruzer International LLC · Ontario, CABuilt 1997 · S/N 002 N225MAAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N 4697106 N226DRTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N LM-14 N226MDSolomon Aviation LLC · Northumberland, PAS/N 88 N227AVUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-227 N227DCEllen Vineyards Inc · Sanger, CABuilt 1979 · S/N LJ876 N227MFMeragals LLC · Evergreen, COBuilt 2003 · S/N 502 N227WWFayard Enterprises LLC · Wake Forest, NCBuilt 1966 · S/N 27 N2281ADuck Hill Air Service LLC · Grenada, MSBuilt 1997 · S/N T15-034 N228AJTriton Airplane Leasing LLC · Wilmington, DEBuilt 1999 · S/N FL-245 N228DTGibbs Aviation Inc · Fremont, OHBuilt 2021 · S/N 602-1315 N228MEWhite & Stradley Pllc · Raleigh, NCS/N 49 N2292HNorth Florida Ag Services Inc · Lake City, FLBuilt 1999 · S/N T34-257 N2297CRaviator II LLC · Dallas, TXBuilt 1997 · S/N LJ-1497 N22FKFast Ag Air LLC · Watertown, SDBuilt 2022 · S/N 802-0965 N22MTHagler Air LLC · Augusta, GABuilt 1994 · S/N LJ-1368 N22NDynamic Avlease Inc · Bridgewater, VABuilt 1973 · S/N LW48 N22PEAdamb200 Holdings LLC · Broken Bow, OKBuilt 1994 · S/N BB-1488 N23034Crop Dusters LLC · Maurice, IABuilt 1999 · S/N T34-259 N2306ABlanke Jason F · Mandeville, LABuilt 1981 · S/N 400-0345 N231BWN231bw LLC · Hayden, IDBuilt 2004 · S/N 600 N231YVAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-231 N234CCDarrow Mark A Trustee · Mukilteo, WABuilt 1983 · S/N 85 N234KW405 Transportation Partners LLC · Edmond, OKBuilt 1982 · S/N BB-1065 N234RGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 520 N2354YUtah Department Of Transportation · Salt Lake City, UTBuilt 1998 · S/N LJ-1532 N235SFScott Air LLC · Munster, INBuilt 2002 · S/N 251 N23618Aerinova Aerial LLC · Mattoon, ILBuilt 1981 · S/N 400-0402 N23649Abernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 400-0408 N236ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U236 N237KConquest Express LLC · Libertyville, ILBuilt 1994 · S/N BB-1481 N237SLAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U237 N237STIlluminus Aviation LLC · Chicago, ILBuilt 2005 · S/N 4697237 N23813Davis Blake A · Bellevue, TXBuilt 1982 · S/N 400A-0433 N238ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U238 N2394NAssociated Aerial Applicators Inc · La Salle, COBuilt 1982 · S/N 400A-0446 N2394RPalmer Flying Service Inc · Manito, ILBuilt 1999 · S/N 602-0545 N23951Rowland Dusters LLC · Raymondville, TXS/N 400A-0447 N239ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U239

Back to AD 2016-05-13