Registered aircraft · 16,284

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.

N861PUTrustees Of Purdue University · West Lafayette, INS/N 2881334 N861SHBear Aviation LLC · Bridgman, MIBuilt 2005 · S/N 1658 N861TZOneill Aviation LLC · Hartland, WIBuilt 2004 · S/N 0877 N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493 N8623EBeach Pilot LLC · Winchester, VABuilt 1976 · S/N 28-7690182 N862CDJolly Mon LLC · Knoxville, TNBuilt 2003 · S/N 0572 N862DPWork To Fly LLC · Nashville, TNBuilt 2017 · S/N 2343 N862GMBlackbird Aviation LLC · Charlottesville, VABuilt 2009 · S/N 3408 N862HTSublett Holdings LLC · Wilmington, DEBuilt 1981 · S/N BB-800 N862JCHrs Equity Consulting LLC · Miami Beach, FLBuilt 2019 · S/N 2881281 N862KSKansas State University · Salina, KSBuilt 2024 · S/N 4496586 N862PHApoapside Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 3602 N862PUTrustees Of Purdue University · West Lafayette, INS/N 2881335 N862TCAirmax Aviation LLC · Lake Worth, FLBuilt 1977 · S/N 28-7716290 N862TMCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11578 N863ATCxk1 LLC · Wilmington, DEBuilt 2025 · S/N 4496621 N863CDRoman Joseph L · Montrose, PABuilt 2005 · S/N 1701 N863CFBpa Leasing LLC · Lehi, UTBuilt 2002 · S/N 0191 N863MMGg Jet Air LLC · Montgomery, INBuilt 2024 · S/N 9767 N863PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843946 N863PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881477 N863SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881799 N863WAK Bear Holdings LLC · Bend, ORBuilt 2025 · S/N 4636863 N8645ECichocki Matthew R · Oviedo, FLBuilt 1976 · S/N 28-7690183 N8647ESkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843374 N864ATCxk1 LLC · Wilmington, DEBuilt 2025 · S/N 4496622 N864CDAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 1221 N864PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881498 N864PWSterling Sky Aviation LLC · Beach City, TXBuilt 2006 · S/N 2024 N864SRN864sr LLC · Kalispell, MTBuilt 2007 · S/N 2828 N8650EGotta Fly LLC · Manitou Springs, COBuilt 1976 · S/N 28-7690184 N865ACAri Ben Aviator Inc · Fort Pierce, FLS/N 2881386 N865CDBlais Marc R · Lewiston, MEBuilt 2005 · S/N 1586 N865CFZ & N Aero And Marine LLC · Wilmington, DEBuilt 2022 · S/N 8540 N865FCCirrus Design Corp · Knoxville, TNBuilt 2013 · S/N 2233 N865GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881467 N865KASunset Pointe Development LLC · Port Saint Joe, FLBuilt 2017 · S/N 4543 N865KMSouthern Cross LLC · Alcoa, TNBuilt 2020 · S/N 4920 N865MMRelm Holdings Of Ohio LLC · Ottawa Hills, OHBuilt 2021 · S/N 5017 N865PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881490 N865SSG6 Sky High Aviation Inc · Knoxville, TNBuilt 2018 · S/N 4593 N8664CArcher 64c LLC · Essex, MABuilt 1976 · S/N 28-7690156 N866ATCxk1 LLC · Wilmington, DEBuilt 2025 · S/N 4496624 N866AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496647 N866CApus Aviation Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0397 N866CDHigear Aviation LLC · O Fallon, MOBuilt 2002 · S/N 1235 N866DSSiteserver Inc · Bend, ORBuilt 2007 · S/N 40.766 N866GEValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 11021 N866PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881491 N866USUtah State University · Logan, UTBuilt 2007 · S/N 40.866

Back to AD 2008-06-28 R1