OpenAirDocs.org
AD 2012-26-15 R1

Registered aircraft · 5,537

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:2012-26-15-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:2012-26-15-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.

N457MPTesoro Aviation Co · Findlay, OHBuilt 2014 · S/N 4320N457UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1146N458FXNylife LLC · Cleveland, OHBuilt 2011 · S/N 4238N458UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1163N459FXDab-Jab Air LLC · Cleveland, OHBuilt 2013 · S/N 4280N459LCJumper Air LLC · Green Bay, WIBuilt 1999 · S/N 060N459MPBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 4327N459UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1192N45DPBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 4235N45EGApex Air LLC · Greenwood, INBuilt 1996 · S/N 27N45EJCoral Aircraft LLC · North Platte, NEBuilt 2000 · S/N 080N45GHWalmart Inc · Bentonville, ARS/N 447N45HFBoard Of Regents Of The Univ Of Nebraska · Lincoln, NES/N 121N45HGAsphalt Materials Inc · Indianapolis, INBuilt 2007 · S/N 343N45HKWalmart Inc · Bentonville, ARBuilt 2007 · S/N 349N45JACreamer Pilot Services LLC · Fayetteville, ARBuilt 2008 · S/N 385N45JEMondoil Equipment Leasing LLC · New York, NYBuilt 2013 · S/N 5446N45JGLearjet 45 LLC · Sellersburg, INBuilt 2005 · S/N 272N45JHSped Air LLC · Nashville, TNBuilt 2010 · S/N 397N45KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 313N45KWSpeedbird LLC · Fort Wayne, INBuilt 2002 · S/N 210N45KXKalitta Charters LLC · Ypsilanti, MIBuilt 2003 · S/N 233N45LRN45lr LLC · Anchorage, AKBuilt 1998 · S/N 013N45LVHammerfly LLC · Glendale, COS/N 322N45LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 332N45MWMed Air LLC · Lawrenceville, GABuilt 2000 · S/N 115N45NMTriple Crown Energy LLC · Tulsa, OKBuilt 2004 · S/N 253N45NPBgs Transport LLC · Wilmington, DEBuilt 2002 · S/N 204N45NSSeaman Corp · Wooster, OHBuilt 2002 · S/N 560-5285N45PMTime Tool Inc · East Sound, WABuilt 2017 · S/N 1688N45RR422 W Cumberland LLC · Knoxville, TNBuilt 2010 · S/N 414N45TUFlying Amici Aviation LLC · Owasso, OKBuilt 2000 · S/N 120N45WFProfessional Office Services Inc · Waterloo, IAS/N 486N45XPEwing Irrigation Products Inc · Phoenix, AZBuilt 2008 · S/N 355N45YFSa 001 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 006N460FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4117N460NGNovember Golf Management LLC · Incline Village, NVBuilt 2014 · S/N 1460N460PMP & M Aero LLC · Belle Chasse, LABuilt 2008 · S/N 1079N460SNovant Health Inc · Winston Salem, NCBuilt 2025 · S/N 560-6377N460UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1248N461FXGfi Acquisitions LLC · Cleveland, OHBuilt 2011 · S/N 4214N461GTDeeside Aviation LLC · Sparks, NVBuilt 2005 · S/N 4022N461PSOmni Air LLC · Chesapeake, VABuilt 2000 · S/N 560-5059N461QSDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 4125N461UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1266N4621KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1902N462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 26985N462FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4129N462MKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5362N462NBWest States Leasing Inc · Medford, ORBuilt 2011 · S/N 57071
Back to AD 2012-26-15 R1