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.

N823ACPerkins Mark · Salamanca, NYBuilt 2002 · S/N 1201 N823ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496548 N823CDProfeta Glen A Trustee · Hanford, CABuilt 2002 · S/N 0185 N823DHRo-Jo Scientific Consulting LLC · Indianapolis, INBuilt 2003 · S/N 42021 N823ERV1vr LLC · Wilmington, DEBuilt 2004 · S/N 1212 N823FWNyahs Keeper LLC · Portola Valley, CABuilt 2007 · S/N 2455 N823NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881162 N823PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881250 N823PVIyer Swaminathan B · Great Falls, VABuilt 2005 · S/N 1383 N823RBMagaviation LLC · Westwood, MABuilt 2024 · S/N 10289 N823VKPied Pipers Inc · Bradenton, FLBuilt 2008 · S/N 3130 N823YTSolo Skies Aviation LLC · Missoula, MTBuilt 2005 · S/N 40.555 N8241ABaloga David M · Payson, AZBuilt 1982 · S/N 32R-8229060 N8241CL & S Aircraft Holdings LLC · Yukon, OKBuilt 1975 · S/N 28-7690109 N8241ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316079 N8244UFaherty Michael F · Greensboro, NCBuilt 1980 · S/N 28-8016371 N8245CVector Aviation LLC · Mentor, OHBuilt 1980 · S/N 28-8090372 N8246EDubois Aviation Inc · Chino, CABuilt 1982 · S/N 28-8216189 N82470Tfto LLC · Franklin, TNBuilt 1984 · S/N 32R-8429016 N8247CPonder Harvey E · Knoxville, ILBuilt 1982 · S/N 28-8290158 N8247TSaratoga Skies LLC · Wilmington, DEBuilt 1982 · S/N 32R-8213056 N82487Woodruff Thomas C · Pacific Grove, CABuilt 1980 · S/N 28-8116007 N8248DKillam Michael R · Honesdale, PABuilt 1980 · S/N 32R-8013121 N8248QElkhart Flying Club Inc · Nappanee, INBuilt 1982 · S/N 32R-8329004 N8248TJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8116003 N8249BEscobar Alfredo · Canyon Country, CAS/N 28-8116008 N824ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496549 N824AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2026 · S/N 4496625 N824BBBig Bend Community College · Moses Lake, WABuilt 2023 · S/N 2881695 N824CDCat Aviation LLC · New Orleans, LABuilt 2002 · S/N 1255 N824DBPurple Piper Airways LLC · Indian Rocks Beach, FLBuilt 2002 · S/N 3246209 N824DGSadie Aviation LLC · Mars, PABuilt 2026 · S/N 11443 N824DJBcd Aviation LLC · Waleska, GABuilt 2024 · S/N 9973 N824DXElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 28-7990061 N824ETSwift Charles Wesley Jr · West Plains, MOBuilt 2022 · S/N 8570 N824HJC & W Aviation LLC · Birmingham, ALBuilt 2003 · S/N 0602 N824KBHope Aviation LLC · Lakota, NDBuilt 2015 · S/N 4168 N824MKGoldenair LLC · Wellesley, MABuilt 2023 · S/N 9190 N824MRTspy Services Inc · Wilmington, DEBuilt 2004 · S/N 1152 N824NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881291 N824PCapital Premium Finance · Tallahassee, FLS/N 1206 N824PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881336 N824PFWashington Square Cirrus LLC · Sagaponack, NYBuilt 2003 · S/N 0504 N824TPOur Gang Air LLC · Malvern, PABuilt 2022 · S/N 8795 N824USLightyear Aviation LLC · Chicago, ILBuilt 2007 · S/N 40.824 N824VRDodson International Parts Inc · Rantoul, KSBuilt 1996 · S/N 2843058 N824WBest Start Inc · Kingman, AZBuilt 1982 · S/N 32R8229032 N824WLValiair Limited Co Trustee · Casper, WYBuilt 2020 · S/N 4933 N824XLeaf Aviation LLC · Henderson, NVBuilt 2006 · S/N 41623 N824ZBCirrus 824 LLC · Copiaque, NYFirst renewal noticeBuilt 2006 · S/N 1674

Back to AD 2008-06-28 R1