Registered aircraft · 3,462

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:2002-23-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:2002-23-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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.

N23951Rowland Dusters LLC · Raymondville, TXS/N 400A-0447 N239ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U239 N239JPTj Air Holdings Inc Trustee · Wilmington, DES/N 425-0016 N239JRBrykin Leasing Corp · Celina, TXBuilt 2003 · S/N 20800368 N239KQIdaho Transportation Department · Boise, IDS/N 100-0239 N23EGN254tg LLC · Cedar City, UTBuilt 2010 · S/N 100-0044 N23KNChurch Oil Co Inc · Plattsburgh, NYBuilt 2012 · S/N EVO-0041 N23NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2009 · S/N LJ-1944 N240DLBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2011 · S/N 402B-1240 N240GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-240 N241PMBryants Aviation Inc · Batesville, ARBuilt 2003 · S/N 4697150 N241SADiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 556 N2424XDirect 2 Aviation LLC · Elkhorn, NEBuilt 2002 · S/N 243 N2427CEmpty Pockets Flying Service Inc · Wilson, ARBuilt 2023 · S/N T660-181DC N242KQTeton Leasing LLC · Pocatello, IDBuilt 2018 · S/N 100-0242 N242LFDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LA-86 N242ZAN667kt LLC · Lewes, DEBuilt 2001 · S/N BB-1761 N243CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N BB-1596 N243LAH & G Farms Inc · Corcoran, CABuilt 2015 · S/N 502B-3020 N243MHAllen Contracting Inc · Oklahoma City, OKBuilt 1999 · S/N FL243 N244HAHowell Air LLC · Dover, DEBuilt 1996 · S/N LJ-1444 N245GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-245 N246BRRoberts Ag Air Service Inc · Lamoure, NDBuilt 2012 · S/N 502B-2786 N246GTWestern Pilot Service Inc · Phoenix, AZBuilt 2000 · S/N LJ-1591 N246LAChambers County · Anahuac, TXBuilt 2018 · S/N 402B-1400 N246MPDesert Rain Properties LLC · Arco, IDBuilt 2018 · S/N EVO-0084 N247ADOsprey X LLC · New York, NYBuilt 2002 · S/N 247 N247DCAzlg Holding LLC · Missoula, MTFirst renewal noticeBuilt 2016 · S/N EVO-0066 N247GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-247 N247LLFinco Luca · Chicago, ILBuilt 2021 · S/N 4698192 N247MDLta Group Holdings LLC · Amarillo, TXBuilt 1990 · S/N LJ1244 N247MSPilatus Aircraft USA Ltd · Broomfield, COBuilt 2004 · S/N 558 N247TCTown & Country Aviation LLC · Sunnyvale, CABuilt 2009 · S/N 100-0025 N248AJMustang Aero Consulting LLC · Peoria, AZBuilt 2011 · S/N EVO-023 N248DAJb Air Services LLC · Brighton, COBuilt 2003 · S/N 4697156 N248PAPofolk Aviation Hawaii Inc · Honolulu, HIBuilt 1988 · S/N 208B0134 N248PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N BB-1618 N249AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-160 N249CPAngels Envy Aviation LLC · Denison, TXBuilt 1979 · S/N LJ-841 N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061 N249MFDoyon Air Transport LLC · Ketchikan, AKBuilt 1968 · S/N 1662TB36 N249NZSkydive Guam Inc · Barrigada, GUBuilt 2010 · S/N 172 N24GRJackson Joel P · Bellevue, WABuilt 2007 · S/N 302SR N24MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 2024 · S/N 100-0348 N24SPUzochi Inc DBA · Albuquerque, NMBuilt 1972 · S/N BB-3 N250SAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 46-97004 N250TMAbd Equipment LLC · Aledo, TXS/N BB822 N252KInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 100-0109 N252LABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 502B0252 N252RCPrestige Worldwide Flights Two LLC · Imperial, CABuilt 1987 · S/N LJ-1152

Back to AD 2002-23-13