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.

N607SFLs Service Corp · Wilmington, DES/N 0012 N607WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9777 N6080HShealy Horace L Jr · Chesapeake, VAS/N 28-7890207 N6081ERegistered aircraftBuilt 2009 · S/N 4697400 N6081HFlathers George William II · Palmyra, VABuilt 1977 · S/N 28-7890208 N6084CBig Bend Community College · Moses Lake, WABuilt 2008 · S/N 4496267 N6085FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020153 N6085ZV12 Promotions LLC · Orlando, FLBuilt 2009 · S/N 4692127 N6086BStrohauer Farms Inc · La Salle, COBuilt 2009 · S/N 4692128 N6089FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020154 N608ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843758 N608AEFreedom Aviation LLC · Weatherford, TXBuilt 2003 · S/N 0611 N608BRArmwings LLC · Plainville, CTBuilt 2005 · S/N 1512 N608CDHorizon Ventures Inc · Fayetteville, ARBuilt 2006 · S/N 2076 N608DSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2002 · S/N 40.217 N608FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020208 N608FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916328 N608GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881194 N608PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841217 N608SRMachugh Cliffton D · Albany, ORBuilt 2007 · S/N 2520 N6090FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020155 N6091FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020156 N6093ED'Antonio Steven A · Lenox, MABuilt 2010 · S/N 4692136 N6095SAri Ben Aviator Inc · Fort Pierce, FLBuilt 2007 · S/N 2843662 N6096ZYoung Collin H · Spring, TXBuilt 2010 · S/N 2843678 N6097FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020157 N6098FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020158 N60997Cl Holdings LLC · Washington, DCS/N 4692100 N6099PCudd Bradley Shane · Guymon, OKBuilt 2010 · S/N 4636468 N6099ZN6099z Inc Trustee · Wilmington, DES/N 0625 N609AEGundersen Erik · Chino Hills, CABuilt 2003 · S/N 0609 N609CThorson Gregory · Mequon, WIBuilt 2003 · S/N 0440 N609CAEkko Flight LLC · Middlebury, CTBuilt 2007 · S/N 40.869 N609CDCavu Aviation LLC · Huntsville, ALBuilt 2004 · S/N 0948 N609CTKalsi Pritpal R · Clarksburg, MDBuilt 2006 · S/N 1721 N609DWith Pride Aviation LLC · Farmingdale, NYBuilt 2025 · S/N 10609 N609DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1844 N609DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881982 N609FAStratus Air LLC · New Castle, DEBuilt 2025 · S/N 28020209 N609FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716270 N609KGGeiger Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 2005 · S/N 1731 N609MAAcenes LLC · White Plains, NYBuilt 1999 · S/N 3449109 N609MRScudder Aviation LLC · Enid, OKBuilt 2018 · S/N 4654 N609NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881285 N609RQGreenbrier Classic Cars LLC · Whitefish, MTBuilt 2007 · S/N 41752 N609SASeaero Group LLC · Auburn, ALBuilt 2023 · S/N 9114 N609SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881599 N60BABemidji Aviation Services Inc · Bemidji, MNS/N LW-79 N60CFArq Aviation LLC · Wilmington, NCBuilt 2024 · S/N 10153 N60NAHampden Aviation Services Inc · Northampton, MABuilt 1980 · S/N 28-8116049

Back to AD 2008-06-28 R1