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.

N484FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 4203N484JCWhitefish Investment Partners LLC · Frisco, TXBuilt 2006 · S/N 560-5646N484UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1609N484WM484wm LLC · Bend, ORBuilt 2008 · S/N 14501058N485ATAdvanced Technology Services Inc · Peoria, ILBuilt 2012 · S/N 560-6103N485FXHohman Robert · Cleveland, OHBuilt 2014 · S/N 4305N485UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1617N4866UUnited Airlines Inc · Chicago, ILS/N 2404N486FXBci Flexjet LLC · Cleveland, OHBuilt 2016 · S/N 4359N486TTThompson Tractor Co Inc · Birmingham, ALBuilt 2006 · S/N 560-5635N486UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1620N486WMTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2007 · S/N 4086N487CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2004 · S/N 33768N487FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4176N487HDDodson International Parts Inc · Rantoul, KSS/N 585N487JLZephyr Leasing LLC · Dover, DEBuilt 2010 · S/N 5301N487RKDistributors Development Inc · Schofield, WIBuilt 2024 · S/N 2336N487UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1669N4888UBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3258N488FXRegistered aircraftBuilt 2017 · S/N 4363N488UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1680N489FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 4360N489RKDistributors Development Inc · Schofield, WIBuilt 2022 · S/N 2199N489UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1702N48FBWkc Corp · St Louis, MOBuilt 1995 · S/N 11N48JVJv Aviation LLC · Johnston, RIBuilt 2018 · S/N 1831N48KMAir Quincy LLC · Pittsfield, ILBuilt 2013 · S/N 464N48KZN48kz LLC · Long Beach, CABuilt 2001 · S/N 191N48MFAm Specialty Insurance Co · Dallas, TXBuilt 2000 · S/N 115N48PLLdp Aviation LLC · Sarasota, FLBuilt 2009 · S/N 4181N48TSN48ts LLC · Saint Petersburg, FLBuilt 2017 · S/N 1699N48XBRwb1459 LLC · Victoria, TXBuilt 2014 · S/N 1459N4901UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2680N490UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1728N491AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29429N491JLLoacker Carolynn · Portland, ORBuilt 2014 · S/N 560-6181N491UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1741N492UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1755N493AFRigi Inc · Portsmouth, NHBuilt 2014 · S/N 1493N493NCWest States Leasing Inc · Medford, ORBuilt 2010 · S/N 57015N493UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1821N494ECEastman Chemical Co · Kingsport, TNBuilt 2011 · S/N 4226N494KCSwift Creek LLC · Menlo Park, CABuilt 2014 · S/N 1494N494TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 145678N494UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1840N495MMAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67026N495RSSugar Pine Aviation LLC · Merlin, ORBuilt 2006 · S/N 4049N495UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1842N496GAGulfstream Aerospace Corporation · Savannah, GABuilt 2013 · S/N 4296N496UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1845
Back to AD 2012-26-15 R1