OpenAirDocs.org
AD 2016-05-13

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
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.

N239JRBrykin Leasing Corp · Celina, TXBuilt 2003 · S/N 20800368N240GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-240N240LATwin Cities Aviation Inc · Yuba City, CABuilt 2010 · S/N 802A-0375N241PMBryants Aviation Inc · Batesville, ARBuilt 2003 · S/N 4697150N241VVWorldwide Aviation LLC · Springfield, MOBuilt 1999 · S/N FL-241N2424XDirect 2 Aviation LLC · Elkhorn, NEBuilt 2002 · S/N 243N2427CEmpty Pockets Flying Service Inc · Wilson, ARBuilt 2023 · S/N T660-181DCN242LFDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LA-86N242ZAN667kt LLC · Lewes, DEBuilt 2001 · S/N BB-1761N243CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N BB-1596N243MHAllen Contracting Inc · Oklahoma City, OKBuilt 1999 · S/N FL243N244HAHowell Air LLC · Dover, DEBuilt 1996 · S/N LJ-1444N244LAWoodline Aviation LLC · Memphis, MOBuilt 2014 · S/N 602-1244N245GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-245N247ADOsprey X LLC · New York, NYBuilt 2002 · S/N 247N247GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-247N247LLFinco Luca · Chicago, ILBuilt 2021 · S/N 4698192N247MSPilatus Aircraft USA Ltd · Broomfield, COBuilt 2004 · S/N 558N247SEThiel Air Care Inc · Chowchilla, CABuilt 2012 · S/N 802A-0444N248DAJb Air Services LLC · Brighton, COBuilt 2003 · S/N 4697156N248PAPofolk Aviation Hawaii Inc · Honolulu, HIBuilt 1988 · S/N 208B0134N248PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N BB-1618N249AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-160N249CPAngels Envy Aviation LLC · Denison, TXBuilt 1979 · S/N LJ-841N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061N249LABank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 502A-3049N24SPUzochi Inc DBA · Albuquerque, NMBuilt 1972 · S/N BB-3N250SAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 46-97004N250TMAbd Equipment LLC · Aledo, TXS/N BB822N252LABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 502B0252N253GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-253N255DWHales Gutter Guys LLC · Sedona, AZBuilt 2000 · S/N 4697020N255GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-255N257GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-257N257MSNeal Aircraft Inc · Slaton, TXBuilt 2023 · S/N 602-1350N258AWCobra Aviation Services LLC · Oklahoma City, OKBuilt 1996 · S/N UE258N258LACrop First Aviation Inc · Stanfield, AZBuilt 2015 · S/N 602-1257N258PAClemente Motor Inc · Troy, NYS/N 1690TB58N259LAC & L Holzwarth Inc · Virden, ILBuilt 2015 · S/N 602-1265N259SCCei Inc · Wilmington, DES/N LW17N25WCMau Leasing LLC · Newark, DEBuilt 1998 · S/N BB-1640N2602MWoodley Aerial Leasing · Walnut, ILBuilt 2002 · S/N 602-0645N260LAGibbs Aviation Inc · Fremont, OHBuilt 2016 · S/N 602-1268N261AGTurbo North Shorts LLC · Anchorage, AKBuilt 1985 · S/N SH-3117N261GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-261N262AGMcneely Charter Service Inc · West Memphis, ARBuilt 1985 · S/N SH3120N263CWAir Pard LLC · Baton Rouge, LABuilt 2003 · S/N 263N263JCAllen Chorman & Son Inc · Milton, DEBuilt 2004 · S/N T34HG-105N263LACmk Aerial Inc · Sutton, NEBuilt 2015 · S/N 602-1263N263RSNorthern Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 112
Back to AD 2016-05-13