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.

N46HDPrice Jesse · Fargo, NDBuilt 2005 · S/N 42071 N46JCAdventures Air Express LLC · Malabar, FLBuilt 1997 · S/N 4636125 N46JGKslt Aviation LLC · Birdsboro, PABuilt 2022 · S/N 8814 N46KCSandbox Holdings LLC · Missoula, MTBuilt 2019 · S/N 4636746 N46KJK-A Mirage LLC · Winnetka, ILBuilt 1996 · S/N 4636037 N46KVPigs Aviation LLC · Houston, TXBuilt 2021 · S/N 5130 N46LULetourneau University · Longview, TXBuilt 2017 · S/N 4496415 N46LYRossi Carl J Jr · Florence, ORBuilt 2021 · S/N 4636778 N46MEFishlover'S Management LLC · Chandler, AZBuilt 2005 · S/N 4697207 N46PLAvcorp Leasing Inc Trustee · Wilmington, DEBuilt 2001 · S/N 4697054 N46PMMcmillan Michael J · Forsyth, GABuilt 1989 · S/N 4622081 N46PTT & K LLC · Bloomington, ILBuilt 1990 · S/N 4622108 N46PWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 4636370 N46RPJst Management LLC · Zephyrhills, FLBuilt 1976 · S/N LW-193 N46SBDavis Aviation Inc DBA · Brandon, MSS/N LW-312 N46SEAddie-Air Inc · Bridgeport, TXBuilt 1992 · S/N 4622131 N46TDRockstar Air LLC · Mcgregor, TXBuilt 1998 · S/N 4636177 N46TESerenity Aero LLC · Cape Girardeau, MOBuilt 2005 · S/N 1694 N46VURegistration Pending · Glendale, AZRegistration pendingBuilt 2018 · S/N 2444 N46WHAbecca Corp · Jackson, MIBuilt 1993 · S/N 4622141 N47023Morey John Jack · Port Orange, FLBuilt 1977 · S/N 28-7890049 N470AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843742 N470AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9085 N470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PABuilt 2005 · S/N 1611 N470DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1786 N470DSDowning Ridge Flying Club LLC · Coshocton, OHBuilt 2006 · S/N 40.670 N470SEZ Air LLC · Houston, TXBuilt 2007 · S/N 3257470 N470STLima Charlie 2.0 LLC · Duluth, GABuilt 2025 · S/N 10545 N470SUBoelte Aviation LLC · Edmond, OKBuilt 2022 · S/N 8670 N471AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843743 N471AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9086 N471DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1787 N471FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10471 N471HCHinds Community College · Raymond, MSBuilt 2024 · S/N 28020199 N471TAAtp Taa LLC · Wilmington, DES/N 2881313 N471TTEagle Flyer IV LLC · Zionsville, INBuilt 2010 · S/N 2061 N471WMRegistered aircraftBuilt 2011 · S/N 3801 N47225Aviation Partners Inc · Carson City, NVBuilt 1977 · S/N 28-7890050 N472CDLorton Kenneth Patrick · Brooklyn, NYBuilt 2004 · S/N 1197 N472DAAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2007 · S/N 1788 N472DDMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881576 N472DSIndigo Skies LLC · Rome, GABuilt 2012 · S/N 40.1168 N472DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010072 N472EAWashington State Community College · Spokane, WAS/N LW-250 N472KEB Rex LLC · East Palo Alto, CABuilt 2019 · S/N 4781 N472MBSimmons Jeffrey F · Houston, TXBuilt 2024 · S/N 10166 N472PAHornsby Larry G DBA · Moody, ALBuilt 2005 · S/N 40.472 N472SRJuice Club Air LLC · Palm Springs, CABuilt 2006 · S/N 2272 N472TAAtp Taa LLC · Wilmington, DES/N 2881314 N4730FDavison Carl A · Snohomish, WABuilt 1976 · S/N 28-7790058

Back to AD 2008-06-28 R1