Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-R1') 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:2008-06-28-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:2008-06-28-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.

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:2008-06-28-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:2008-06-28-R1')
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.

N410AVWestwind School Of Aeronautics Phoenix DBA · Goodyear, AZBuilt 2022 · S/N 8808 N410CPNomad Flight One Inc · Clearwater, FLBuilt 2003 · S/N 3255010 N410ETAndervick · Dalton, GABuilt 1976 · S/N 28-7690391 N410FCTft Inc · Colfax, ILBuilt 2023 · S/N 9146 N410HPS&W Air LLC · Santa Clara, CAS/N 4697413 N410MFCcii Mt Lc · Darby, MTBuilt 1979 · S/N 441-0093 N410MPGulf Horizon Ventures LLC · Tampa, FLBuilt 2021 · S/N 5005 N410PPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3600 N410SRBiondich Amy · Rubicon, WIBuilt 2006 · S/N 2138 N410STValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 4636410 N410SUSeries D Of Boelte Aviation LLC · Edmond, OKBuilt 2021 · S/N 2771 N410TCNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881088 N410TWRice Dwight L · Borger, TXBuilt 2008 · S/N 411044 N410USSeverson Leland J · Bottineau, NDBuilt 2006 · S/N 40.710 N410VVDaniels Mark A · Raleigh, NCS/N 3394 N4110PSkyway LLC · Bronx, NYBuilt 1998 · S/N 2843143 N4117FMade U Look Promotions LLC · Glastonbury, CTBuilt 1976 · S/N 28-7790004 N4117HTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2008 · S/N 40.938 N41184Airwings Inc Trustee · Wilmington, DEBuilt 1998 · S/N 3449059 N4119KLe Doux Aviation LLC · Hollis, NHBuilt 1997 · S/N 3257020 N411APN411ap LLC · Independence, KSBuilt 2002 · S/N 0215 N411BJclm Aviation LLC · Atlanta, GABuilt 2006 · S/N 1865 N411BCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2843339 N411BNFranklin Kenneth A · Aliso Viejo, CABuilt 2009 · S/N 411119 N411BSMa Aviation Group LLC · Farmingdale, NYBuilt 2004 · S/N 2843598 N411DTSliwa Kevin Joseph · Fishers, INBuilt 2010 · S/N 3678 N411EEVaini Marc · West Plains, MOBuilt 2005 · S/N 41100 N411EPRsbrm Aviation LLC · Lakewood, NJBuilt 2025 · S/N 10607 N411EWC B Saunders Properties LLC · Alpharetta, GAS/N 0250 N411GTTeam 646 LLC · Jupiter, FLBuilt 2005 · S/N 1714 N411HBTex Richman Properties LLC · Little Falls, MNBuilt 2007 · S/N 4697303 N411HZCedar Dix LLC · Lancaster, KYBuilt 2005 · S/N 1568 N411LMK2 Aviation LLC · Greenwood Village, COBuilt 2018 · S/N 2402 N411MARouse William J · Palm Springs, CAS/N 3496 N411MDJdr Inc · Cullman, ALBuilt 2000 · S/N 4636262 N411MHObair 26 LLC · Memphis, TNBuilt 1979 · S/N BB-566 N411NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010005 N411PKC C Owen Tile Co Inc · Jonesboro, GABuilt 2008 · S/N 3368 N411RSm1019 LLC · Polson, MTBuilt 2006 · S/N 4697241 N411SAMasdon Aviation LLC · Guntersville, ALBuilt 2006 · S/N 1967 N411SKRiverside Aviation LLC · Fernandina Beach, FLBuilt 2017 · S/N 4582 N411SRC1n Cirrus G3 LLC · Rockford, ILBuilt 2007 · S/N 2518 N411VTFletcher Holdings Of Nc LLC · Winston Salem, NCBuilt 2002 · S/N 0393 N4120FBcs Air Inc · Oakhurst, CABuilt 1976 · S/N 28-7790005 N4120KJansar Aviation LLC · Farmington Hills, MIBuilt 1999 · S/N 2843225 N4120SBukstein Michael J · Hannibal, MOBuilt 1998 · S/N 3257045 N4121KMalibu Air LLC · Wilmington, DEBuilt 1998 · S/N 4636140 N4121RTaylor John W · Slatington, PABuilt 1998 · S/N 2843134 N4121TChandler Air Service Inc · Chandler, AZBuilt 1996 · S/N 2842017 N4122DCloud Chaser Aviation LLC · Chesnee, SCBuilt 1998 · S/N 2843130

Back to AD 2008-06-28 R1