OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N4495RKohl James D Trustee · Deerfield, ILBuilt 1974 · S/N 17263237N4495ZDolfi Rick · Sutton, AKBuilt 1969 · S/N 18-8850N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044N4496JOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-22915N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011N4496XJennings Matthew · Valley Center, CAS/N 28-7690022N4496ZBarnes Rodney L · Mayville, WIBuilt 1969 · S/N 18-8851N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045N4497AMorris Duane E · Wasilla, AKBuilt 1956 · S/N 18-4869N4497JStewarts Aircraft Service · Waynesville, OHBuilt 1967 · S/N 28-22916N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020N4497RMazurek Drew A · New Haven, CTBuilt 1974 · S/N 17263239N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023N4498JHartshorn James · Las Vegas, NVBuilt 1967 · S/N 28-22919N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054N4499JWiblemo Craig B · Fallbrook, CABuilt 1967 · S/N 28-22920N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022N4499WUrban James R · Pierre, SDBuilt 1965 · S/N 28-2911N449AGKershner Jordan · Malcolm, NEBuilt 1967 · S/N 17700344N449DMMccord David B · Chico, CABuilt 1998 · S/N 001N449EWWilliams Ethan B Trustee · Wasilla, AKBuilt 2012 · S/N 001N449FAAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3683N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185N449PMMullenbach Michael R · Saint Ansgar, IABuilt 1999 · S/N 1466N449PSMid Atlanta Air Museum · Reading, PABuilt 1974 · S/N 12449N449RVRobinson Stewart · San Jacinto, CABuilt 1998 · S/N 20449N449WFGlenns Super Cub LLC · Fort Lauderdale, FLS/N 18-7773N44ADTice Logan Edward · Noblesville, INBuilt 1979 · S/N 123ADN44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037N44CZHeer James A · Lutz, FLBuilt 1988 · S/N 1N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500N44KLStell Brandon A · Mechanicsville, VAS/N 803N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400N44LRRouse Peter L · Parkville, MOBuilt 1996 · S/N 1N44LTLonderville Ross G · Stanwood, WABuilt 1984 · S/N 348N44MHDrewry James D · Dayton, TXBuilt 1979 · S/N 13308N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800N44PGSimon Jevon D · Buckley, WABuilt 1999 · S/N 2522-001N44PJSchaufenbuel Todd W · Imperial, NEBuilt 1992 · S/N 1209N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147N44QGraf Erwin · Clayton, NCBuilt 1974 · S/N 446N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44TDChristian Joe L · Naylor, GABuilt 1973 · S/N 1000
Back to AD 80-04-03 R2