OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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-25-07-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:80-25-07-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.

N41809Britten Ben K · North Pole, AKBuilt 1973 · S/N 602-73N41811Farm Air Inc · Astoria, ILBuilt 1973 · S/N 404-73N41813Secrest Kenneth W · Griffin, GABuilt 1973 · S/N 603-73N41816Privitt Bret J · Fort Worth, TXBuilt 1973 · S/N 405-74N41819Crop Jet Aviation LLC · Gooding, IDBuilt 1974 · S/N 1-74N4181YBruce A Morey · Wills Point, TXBuilt 1977 · S/N 1188-77N41820Wagner Patricia · West Milton, OHBuilt 1973 · S/N 985-74N41821Gilroy Joseph T · Escalon, CAS/N 1021-74N41822Kitchen Thomas M · Indiana, PABuilt 1973 · S/N 280-74N4182HAir Superiority Inc · Syracuse, NYBuilt 1978 · S/N 24-0656N4182TMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270319N4182YShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 604-77N4183CLockhart Curtis M · Bay Village, OHBuilt 1978 · S/N R18200338N4184YMoncrief Rick L · Melba, IDS/N 600-77N4187YStohr Beuford G · Woden, IABuilt 1977 · S/N 289-77N4189YBaldacci Eric · Katy, TXBuilt 1977 · S/N 1191-77N418CCRedfield James A · Simi Valley, CABuilt 1976 · S/N 17702464N418LGm Farm Service LLC · Santa Teresa, NMBuilt 1978 · S/N R18200821N418PRHunnicutt Gerald E · Hendersonville, NCBuilt 1978 · S/N R18200475N418TASale Reported · Lancaster, TXSale reportedS/N 680105N4192HBrown Joel M · Kokomo, INBuilt 1978 · S/N 24-0660N4192YDragon Grass LLC · Nashua, NHS/N 966-77N4194YPyne James E · Tucson, AZS/N 602-77N4197YAgnew Michael D · Pardeeville, WIS/N 1193-77N4198YGallo Michael R · High Falls, NYBuilt 1977 · S/N 292-77N4199HN4199h Club Llp · Oshkosh, WIBuilt 1978 · S/N 24-0661N4199YPanhandle Consulting LLC · Dallas, GAS/N 1194-77N419ACSimmons Scott · Anchorage, AKBuilt 2000 · S/N 408-99N419ALTomahawk Aero Services LLC · Bellingham, WABuilt 1978 · S/N 38-78A0401N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003N419DSLien Christian B · Rapid City, SDBuilt 2006 · S/N 1030-2006N419JRRaf LLC · Lenexa, KSBuilt 1995 · S/N 759-95N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787N419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039N41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890N41DRMiller David E · Wheat Ridge, COS/N 38-81A0060N41EMBretscher Mark · Hinsdale, ILBuilt 1976 · S/N 177RG0923N41FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272997N41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17269389N41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 21063653N4200YTexas Red Bird LLC · Palo Pinto, TXBuilt 1977 · S/N 964-77N4201LSuverkrup Mark · Columbus, INBuilt 1978 · S/N 24-0572N4201QReeve Ryan · Hurricane, UTBuilt 1971 · S/N 17260101N4201UEclipse Air LLC · Versailles, MOBuilt 1978 · S/N 24-0574N42024White Wings Air Inc · Jacksonville, FLBuilt 1974 · S/N 17264153N4202QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260102
Back to AD 80-25-07 R1