Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N7699GZhao He · Yaphank, NYBuilt 1970 · S/N 17259399 N769AKThomas Cole A · Fairbanks, AKBuilt 1975 · S/N 18-7609017 N769GALong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N GA7-0056 N769JBGibson Randy L · Clinton, TNBuilt 1968 · S/N 17257380 N769RAMcclure Dennis N · Mcalpin, FLS/N 28-23164 N76ADWerner Richard · Syosset, NYBuilt 1975 · S/N 28-7690019 N76ATCarney Raymond L · Newton, ALBuilt 1977 · S/N 1081 N76AUHayes Michael Mckool · Destin, FLBuilt 2002 · S/N 80788 N76DHKarapelou James M · Allentown, PABuilt 1995 · S/N 2843019 N76DMHendrix Aviation Inc · Plantation, FLBuilt 1977 · S/N 28-7890110 N76DSDeemer Jerry C · Granbury, TXBuilt 1993 · S/N CC1001 N76DUL&P Of Mke LLC · Milwaukee, WIBuilt 1978 · S/N ME-52 N76EVKuhn Bernard O · Ripon, CABuilt 1976 · S/N 18-7609103 N76GCEdgerton Richard T · Arlington, WABuilt 1976 · S/N AA5A-0107 N76GDCoulter Dennis W · Lincoln, CABuilt 1977 · S/N 7476 N76GZLankford Philip S · San Marcos, CABuilt 1997 · S/N 22009 N76HJAmalong Timothy M · Tucson, AZBuilt 1976 · S/N 17266809 N76HKDodson International Parks Inc · Rantoul, KSBuilt 1958 · S/N 23-1423 N76HSDelgrosso Dennis W · Saranac, NYBuilt 1977 · S/N 17702642 N76HYCarley Dale H · Griffin, GAS/N 2076 N76JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1974 · S/N 17263122 N76JEReedy Dana J · Columbus, INBuilt 1976 · S/N 1915 N76JGSublett Farms · Ardmore, ALBuilt 2000 · S/N 2061 N76JKKrajewski Jason · Portland, ORBuilt 1976 · S/N 177-02435 N76JMWalton Daniel · Schaumburg, ILBuilt 1987 · S/N JM 2 N76JVLeonardo David · Hollister, CAS/N 21071 N76KDSchneider Aaron J · Chugiak, AKBuilt 1986 · S/N 76 N76KRSorensen Bjarne K · Vero Beach, FLBuilt 1983 · S/N 353 N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925 N76LMPavlovich Martin · Menomonee Falls, WIS/N 22604 N76LYYonge Laurie W Jr · Oklawaha, FLBuilt 1964 · S/N 302 N76MMRichardson John H · Monticello, NMBuilt 1957 · S/N 18-6031 N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909 N76NCDonald K Ashley · Bradenton, FLBuilt 1976 · S/N M-1787 N76NKNaples Jet Management LLC · Naples, FLS/N ME-334 N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158 N76NPCollins Shannan S · Justin, TXS/N SA-300-726 N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151 N76PQBoyd Benjamin L · Kila, MTBuilt 1976 · S/N 18-7609130 N76RSCocke James A · Clarendon, TXBuilt 1976 · S/N 683-H N76RVVandevort Lynn A · Manitowoc, WIBuilt 1999 · S/N 23420 N76RWThomas Allen C · Willow, AKBuilt 1953 · S/N 18-1886 N76SBAdams Simmie A · Bealeton, VABuilt 1975 · S/N M-1776 N76SLLarsh Steven S · Libby, MTBuilt 2004 · S/N 1001 N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711 N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025 N76TCCox Thomas R · Kirkland, WABuilt 2001 · S/N 80500 N76TJBais Tim · Escondido, CABuilt 1994 · S/N 21675 N76TXBrenner Kurt · Saint Ann, MOBuilt 1976 · S/N 28-7625102 N76VAHartzell Propeller Emp Flg Club · Piqua, OHBuilt 1976 · S/N M-1786

Back to AD 80-04-03 R2