OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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
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.

N2077CBudarf James Philip · Graham, TXBuilt 1978 · S/N M-2074N20784Dbab LLC · Belleville, ILBuilt 1978 · S/N 28-7990025N20789Johnson Laurel D · Newcastle, WABuilt 1974 · S/N 17263837N20792Boyette Donnie R · Kenly, NCBuilt 1974 · S/N 17263838N2079NSkywarrior Flight Training Inc · Pensacola, FLBuilt 1979 · S/N 44-7995214N2079RBrian K Vittorini · Bridgeton, NJBuilt 1969 · S/N 28-5455N2079WCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 44-7995270N207AHudspeth Thomas S · Burleson, TXBuilt 1993 · S/N 20430N207AMHilger Michael D · Inver Grove, MNBuilt 2000 · S/N 23157N207DMThomson Mary Ellen · East Berlin, PABuilt 1985 · S/N 207N207HPCampbell James W · Geneva, ALBuilt 1982 · S/N 17275543N207LSNightbreak Aviation LLC · Houston, TXBuilt 1968 · S/N 680072N207RDSpry Brent A · Madison, INBuilt 1977 · S/N AA5A0449N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026N20865Agasair LLC · East Hampton, NYBuilt 1974 · S/N 17263859N2086PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1956 · S/N 23-674N2086RRobison Robert S · Collinsville, ILBuilt 1969 · S/N 28-5458N20871High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17263862N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150N2087NRls Rental Co DBA · Joplin, MOBuilt 1979 · S/N 28-7916253N2088AGary Jet Center · Gary, INBuilt 1978 · S/N 28-7916092N2088BGeneral Aviation Support Corp · Rosamond, CABuilt 1978 · S/N 28-7916108N2088VMad Scientist Aviation LLC · Wilmington, DEBuilt 2002 · S/N 465-2002N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151N2089KBrown Frank J · Cold Spring, NYBuilt 1978 · S/N 44-7995176N2089NSchroeder Reinhard · Poulsbo, WABuilt 1979 · S/N 28-7916255N2089RSchwettmann Dennis E · Nampa, IDBuilt 1993 · S/N 17N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379N208CAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496161N208EFAero208 LLC · Boise, IDBuilt 1966 · S/N 28-3632N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073
Back to AD 80-04-03 R2