Registered aircraft · 3,100

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-01-11') 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-01-11') 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-01-11')
    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-01-11')
  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-01-11')
  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-01-11')
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.

N111MHHodosh Productions Inc · Santa Monica, CABuilt 2023 · S/N 9070 N111NChadwick Aviation Two LLC · West Harrison, NYBuilt 2025 · S/N 10694 N1124LAkb Aviation LLC · Las Vegas, NVBuilt 2014 · S/N 0711 N1127GAspen Alchemy Air LLC · Aspen, COS/N 2440 N1128RPeninsula Research LLC · San Carlos, CABuilt 2021 · S/N 2338 N112FSFl Co-Owners #1 LLC · Roseville, CABuilt 2023 · S/N 9497 N112LFBeachcomber Run LLC · Winston Salem, NCBuilt 2016 · S/N 1393 N112LJJohnson Lenny · Baton Rouge, LABuilt 2024 · S/N 10353 N112MKTen Lakes Holdings LLC · Eureka, MTBuilt 2023 · S/N 9282 N112NRTkg Aviation LLC · Denver, COBuilt 2011 · S/N 0227 N112PJHappy Trailer Sales LLC · Palmer, TXBuilt 2017 · S/N 1540 N112TDBigsky 157 LLC · Missoula, MTBuilt 2025 · S/N 10470 N112WGGriswold Aviation LLC · San Clemente, CABuilt 2024 · S/N 9785 N113HSOrion Aviation LLC · Springfield, MOBuilt 2013 · S/N 0484 N113JVJohn Vance Enterprises LLC · Edmond, OKBuilt 2012 · S/N 0283 N113MRImpact Electric Inc · Temecula, CABuilt 2010 · S/N 0070 N113WGQuickly Flys LLC · Carmel, INBuilt 2017 · S/N 1496 N114DAConradair LLC · West Portsmouth, OHBuilt 2022 · S/N 8969 N114DBBair Sky LLC · Lovell, WYBuilt 2021 · S/N 2330 N114DERiva Ridge LLC · Wilmington, DEBuilt 2016 · S/N 1381 N114LMDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2013 · S/N 0520 N114RGN114rg LLC · Billings, MTBuilt 2019 · S/N 1991 N114RJThunderbird Aviation LLC · Los Altos, CABuilt 2025 · S/N 10773 N114WGJpf Air Superior Services LLC · Los Angeles, CABuilt 2022 · S/N 8512 N11532Cirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11532 N115ESSpeedynrw LLC · Brownsville, TXBuilt 2019 · S/N 1951 N115JBSnoopy & Baron LLC · Driftwood, TXBuilt 2025 · S/N 11004 N116ACRogue Aviation II LLC · Ladera Ranch, CABuilt 2023 · S/N 9346 N116DERiver Bay Aviation Sr22t LLC · Jacksonville, FLBuilt 2019 · S/N 1934 N116KGCirrus Design Corp · Duluth, MNS/N 11718 N117AKBd Anesthesia LLC · Mineral Point, WIBuilt 2011 · S/N 0100 N117CKValiair Lc Trustee · Casper, WYS/N 9480 N117ESArctic Hauling LLC · Frankfort, ILBuilt 2022 · S/N 8531 N117MEAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9221 N117RRs Leasing LLC · Wilmington, DEBuilt 2021 · S/N 2321 N118ALLeap Frog Air LLC · Rochester Hills, MIBuilt 2017 · S/N 1476 N118EBJah Holdings LLC · Paducah, KYBuilt 2019 · S/N 1990 N118EVN10469 LLC · Brighton, COBuilt 2016 · S/N 1272 N118MXQualitair LLC Trustee · MichelstadtBuilt 2014 · S/N 0723 N1199ZZdmsquared Aviation LLC · Phoenixville, PABuilt 2012 · S/N 0404 N119BKAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2019 · S/N 1853 N119GN119g LLC · Dover, DEBuilt 2023 · S/N 9191 N119PTGod Speed Aviation LLC · Bloomington, INBuilt 2023 · S/N 9398 N11ESEspo Air LLC · Okemos, MIBuilt 2023 · S/N 9177 N11JFN11jf LLC · Battle Ground, WABuilt 2025 · S/N 10554 N11JMCirrus Design Corp · Duluth, MNS/N 11780 N11KMMcree Richard Kent · Frisco, TXBuilt 2023 · S/N 9436 N11MRPremier Aviation LLC · St Johns, FLBuilt 2024 · S/N 9859 N11MUMills Joseph Laney · Johns Island, SCBuilt 2018 · S/N 1831 N11NRBenemily Aviation LLC · Flagstaff, AZBuilt 2021 · S/N 2464

Back to AD 2012-01-11