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.

N5911LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496102 N5914VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1977 · S/N 28-7716214 N5917VHeyano Norman J · Dillingham, AKBuilt 1977 · S/N 28-7790512 N5918VKnutson Sever B · Hutchinson, MNBuilt 1977 · S/N 28-7790513 N591CDac-2020 Inc · Skaneateles, NYBuilt 2002 · S/N 0439 N591CAMountain Air Estates LLC · Yakima, WABuilt 2007 · S/N 40.862 N591DSDelta State University · Cleveland, MSBuilt 2023 · S/N 9279 N591NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496633 N591SCSrc22 LLC · Costa Mesa, CABuilt 2017 · S/N 4511 N591TASnappys Rotor & Wing LLC · Klamath Falls, ORBuilt 1981 · S/N 34-8233076 N591WATv Trucks LLC · Eufaula, ALBuilt 2006 · S/N 2110 N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143 N592CAOncore Aviation LLC · Rochester, NYBuilt 2006 · S/N 40.729 N592CJAims Community College · Greeley, COBuilt 2019 · S/N 2881183 N592CTJ&L Aviation LLC · Wilmington, DEBuilt 2011 · S/N 2113 N592DSDelta State University · Cleveland, MSBuilt 2023 · S/N 9284 N592KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843931 N592MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.981 N592NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496634 N592PUMorrissey Patrick W · Chicago, ILBuilt 2010 · S/N 2053 N592TGCirrus Design Corp · Duluth, MNS/N 11738 N5932FWingin' It Aviation LLC · Glendale, CABuilt 1976 · S/N 28-7790144 N5934VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1978 · S/N 28-7816603 N5935FBartow Municipal Airport Development Authortiy · Bartow, FLS/N 28-7790145 N593DSDelta State University · Cleveland, MSBuilt 2023 · S/N 9298 N593EHHyperscale.Design LLC · Covina, CABuilt 2018 · S/N 2398 N593GGCircle S Air LLC · Wilmington, DEBuilt 1980 · S/N BB-593 N593GREji Services LLC · Cairo, GABuilt 2014 · S/N 4149 N593MCChaffin Mark Bernard · Massillon, OHBuilt 2019 · S/N 4864 N593MRCirrus Design Corp · Duluth, MNS/N 11766 N593MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1258 N593MWWalsh Michael E · Cabot, PABuilt 2021 · S/N 5111 N593NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496270 N593PUScott Emerson W IV · Stillwater, MNBuilt 2010 · S/N 2040 N593RGAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 3447022 N593SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881408 N594CDNetair LLC · Newport Beach, CABuilt 2006 · S/N 1607 N594MLone Mountain Aircraft LLC · Vandalia, OHBuilt 2020 · S/N 2595 N594MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1211 N594PUStem Aviation LLC · Carlsbad, CABuilt 2010 · S/N 2046 N5950KCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816585 N5953Air Traders LLC · Fayetteville, ARBuilt 2003 · S/N 0641 N5955VWestern Aircraft Solutions · Temecula, CABuilt 1977 · S/N 28-7790516 N5959ACardinal 177b LLC · Bonita Springs, FLBuilt 2005 · S/N 1526 N595ASCowan Andrew T · Lucas, TXBuilt 2004 · S/N 1105 N595CDRhodes Matthew P · Indianapolis, INBuilt 2006 · S/N 1761 N595HPPickering Neil · Diamondhead, MSBuilt 1995 · S/N 3246017 N595JMSkedaddle Air Corp · Lincoln, MABuilt 2003 · S/N 0706 N595MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1212 N595MWJta Aviation LLC · Lafayette, LABuilt 2016 · S/N 4359

Back to AD 2008-06-28 R1