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.

N658NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881163 N658TAJse Aviation Operations LLC · Watertown, NYBuilt 2025 · S/N 11037 N6593MCirreus Flyers LLC · Baltimore, MDS/N 3870 N659APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843771 N659AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10978 N659CCMammolink LLC · New Port Richey, FLBuilt 2018 · S/N 4732 N659FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020184 N659JKnier & Associates Inc · Cary, NCBuilt 2013 · S/N 3935 N659NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881286 N659RMattyair LLC · Holbrook, NYBuilt 2025 · S/N 10829 N65CGAirplanesusa LLC · Schaumburg, ILBuilt 1981 · S/N 34-8233004 N65CWFranks Cory · Idalou, TXBuilt 1989 · S/N 3213024 N65DYBean Aviation Holdings LLC · Austin, TXBuilt 2022 · S/N 8647 N65GPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11626 N65HLMurphy Air LLC · Pine Bluff, ARBuilt 2009 · S/N 3530 N65KBBurke Daniel P · Oyster Bay, NYBuilt 2004 · S/N 0808 N65KFCrestwood Aviation LLC · Schererville, INBuilt 1968 · S/N 28R-30906 N65LKLift Enterprise LLC · Helena, MTBuilt 2005 · S/N 1737 N65MSSummey Aviation LLC · Asheville, NCS/N LW-202 N65NDJhkh LLC · Ponte Vedra Beach, FLBuilt 2004 · S/N 1390 N65PVRhrsc LLC · Tucson, AZS/N 4697086 N65RTProfessional Travel Inc · La Porte, INBuilt 1975 · S/N BB-97 N65THPeninsula Flight Management LLC · Lewes, DEBuilt 2006 · S/N 1708 N65TYMbessette LLC · West Ossipee, NHBuilt 2005 · S/N 1452 N65VUVincennes University · Vincennes, INBuilt 2025 · S/N 10919 N6606FWestfall William L · Sunbury, OHBuilt 1976 · S/N 28-7790156 N660AAFms Bank · Fort Morgan, COBuilt 2019 · S/N 2881255 N660BAAlbright Anthony F · Covington, LABuilt 2008 · S/N 411056 N660FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020185 N660PS8th Dimension Enterprises LLC · Aurora, ORBuilt 2006 · S/N 40.660 N660WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9844 N661AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10984 N661CD15wg LLC · Mobile, ALBuilt 2005 · S/N 1707 N661CZCirrus Design Corp · Duluth, MNS/N 11661 N661DSG & R Holdings LLC · Arcadia, CABuilt 2005 · S/N 40.600 N661FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020186 N661KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1987 · S/N 2890028 N661MLDap Aviation LLC · Baton Rouge, LABuilt 1996 · S/N 4636060 N661MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1261 N661NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881287 N661PBravo Tango LLC · Minden, LABuilt 1980 · S/N 32R-8029080 N661SRCirrus 22 LLC · Woodbury, CTBuilt 2007 · S/N 2867 N661WJff Air LLC · Dalton, GABuilt 1984 · S/N 32R-8429008 N661WBGratsinger Scott · Hillsboro, ORBuilt 2005 · S/N 41067 N662APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843774 N662AJBoeing Employees Flying Assoc · Renton, WABuilt 2006 · S/N 1632 N662DSPilot Plase LLC · Sarasota, FLBuilt 2006 · S/N 40.632 N662GMRetail Profit Systems Inc · Central Point, ORBuilt 2012 · S/N 4636569 N662JJFlying Peanuts LLC · San Francisco, CABuilt 2022 · S/N 8556 N662JSHughes Leasing Co · Miami, FLBuilt 1976 · S/N LW-176

Back to AD 2008-06-28 R1