Registered aircraft · 13,306

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:2012-10-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:2012-10-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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.

N26156Hyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0112 N2615GHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0101 N2615QVenture Air Solutions Inc · Opa Locka, FLBuilt 1980 · S/N 402C-0321 N2616SMontana Alpha Omega Ranch LLC · Miles City, MTBuilt 1976 · S/N 21061342 N2618CCampbell Terence · Zanesville, OHBuilt 2022 · S/N 8942 N2618LFl & J Air Corp · West Orange, NJBuilt 1979 · S/N 414A0284 N2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 414A0290 N2619LAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1979 · S/N 414A0291 N2619Z4j Air LLC · Cartersville, GABuilt 1979 · S/N 414A0293 N261ALCkm Aircraft Holdings I LLC · Mandan, NDBuilt 1978 · S/N 414A0207 N261ATDmm Aviation 1 LLC · Kingsburg, CABuilt 2023 · S/N 9037 N261EABrownstone Aviation II LLC · Houston, TXBuilt 2001 · S/N E-3423 N261FEdwards Robert J · Saint Helena, CABuilt 2025 · S/N 10718 N261MCPisciotta Matteo R · Fort Collins, COBuilt 2018 · S/N 1753 N261MJCma Sr22 Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8597 N261WTCvd Recreation LLC · Saint Charles, MOBuilt 2023 · S/N 9440 N2622PSouthern Luxury Logistics LLC · Greensboro, GABuilt 2006 · S/N 1821 N2626TBi-Li Aviation LLC · Terryville, CTBuilt 2007 · S/N 2806 N262BGLarmore James N · Tucson, AZBuilt 2001 · S/N 0061 N262DBElement Aviation Inc Trustee · Wilmington, DEBuilt 2008 · S/N 2915 N262DGTouch And Go Aviation Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10141 N262EAJeaps Aviation LLC · Edgewater, FLBuilt 2001 · S/N E-3417 N262JDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3151 N262RNPro Southern Aviation LLC · Franklin, NCBuilt 2001 · S/N 0034 N262TFCirrus Design Corp · Knoxville, TNBuilt 2020 · S/N 4991 N262TMSav LLC · Shelton, WABuilt 2023 · S/N 9051 N262TYT3x LLC · Elkhorn, WIBuilt 2025 · S/N 10559 N262WHJett Aviation LLC · Orangeburg, SCBuilt 2017 · S/N 1639 N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666 N263DDRegistered aircraftBuilt 2012 · S/N 0410 N263EAJdcwac LLC · Blair, NEBuilt 2002 · S/N E-3437 N263MMDkh Equipment LLC · Andover, MNBuilt 2024 · S/N 10111 N263RBCarmarg3 LLC · Hilton Head Island, SCBuilt 2013 · S/N 0597 N263SAColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1999 · S/N E-3283 N263SRMacair Aviation LLC · Xenia, OHBuilt 2007 · S/N 2512 N263TCRocky Comfort Investments LLC · Quincy, FLBuilt 2023 · S/N 9321 N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679 N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682 N2642SReich Stephen Barry · Kentfield, CABuilt 1976 · S/N 21061345 N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812 N2649ZHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0333 N264ABWilson Wrecker Service LLC · Kalispell, MTBuilt 2025 · S/N 10582 N264BCHospitality Air LLC · Gallipolis, OHBuilt 2023 · S/N 9272 N264CPHill David K · Mapleton, UTBuilt 2008 · S/N 3190 N264JGSparkling Diamond LLC · Middleton, WIBuilt 1999 · S/N E3264 N264KHSoutheast Aviation LLC · Janesville, WIBuilt 2023 · S/N 9358 N264MBFlying Brick LLC · Monroe, NCBuilt 2024 · S/N 10161 N264SRFreedom Skies Group LLC · Condon, MTBuilt 2007 · S/N 2606 N264SWBuilding Materials Supply Inc · Yakima, WABuilt 1998 · S/N E-3190 N264TAPalmetto Creative Aviation LLC · Easley, SCBuilt 2015 · S/N 1114

Back to AD 2012-10-13