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.

N54448Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1981 · S/N 17274974N5444HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265442N5444JHm Aviation LLC · Cape Fair, MOBuilt 1980 · S/N 17273798N54452Epling Kenny B · Mechanicsville, VABuilt 1981 · S/N 17274977N5446DJ And D Petroleum Co · Tallahassee, FLS/N 17272571N5446HBlizzard William F Jr · Barboursville, WVBuilt 1975 · S/N 17265444N54477Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17274983N5447KFly For Fun LLC · Frederick, MDBuilt 1980 · S/N 17274114N5447LPinnacle Aviation Services Inc · Encinitas, CABuilt 1980 · S/N 15284317N5447TWalkington Noel John · Pittsburgh, PABuilt 1982 · S/N R18201868N5448LSantorini Services LLC · Washington, DCS/N 15284318N5449HMoorhead Aviation Services LLC · Moorhead, MNBuilt 1975 · S/N 17265445N544PZAdler Paul D · Chilmark, MABuilt 1973 · S/N 17701981N54502Ho Simpson S · Poway, CABuilt 1981 · S/N 17274991N5450HLima-001 LLC · Muscatine, IABuilt 1975 · S/N 17265446N5450QCruise Flight Academy Inc · Dalton, GABuilt 1981 · S/N 15285112N5451KSkywarior Flight Training Inc · Pensacola, FLBuilt 1980 · S/N 17274117N5452KAviation Club LLC · Sussex, NJBuilt 1980 · S/N 17274118N54531Jordan Alex N · Clarkton, NCBuilt 1981 · S/N 17274995N5453KDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 17274119N5453MQueen City Flying Club LLC · Cincinnati, OHBuilt 1980 · S/N 15284590N5453TSale Reported · WeidenSale reportedBuilt 1982 · S/N R18201870N5454KGolden Mahalo LLC · Sheridan, WYBuilt 1980 · S/N 17274120N5455HMiller Michael R · Portage, MIBuilt 1975 · S/N 17265449N5455JFriend John M · Ozawkie, KSBuilt 1980 · S/N 17273801N54569Buehler Thomas M · Renton, WABuilt 1981 · S/N 17275002N5456YWings As Eagles LLC · Wilmington, DES/N 21064211N54576Rick Aviation Inc · Newport News, VAS/N 17275003N5457DSanders Flight Training Center Inc · Jasper, ALS/N 17272574N5457ETravis Gregory R · Bloomington, INFirst renewal noticeBuilt 1978 · S/N 17271873N5457JRegistration Pending · Chino, CARegistration pendingBuilt 1980 · S/N 17273803N54589Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1981 · S/N 17275007N5458PLoewenstein Edward B · Austin, TXBuilt 1981 · S/N 15284949N5459HWard John W · Troutdale, ORBuilt 1975 · S/N 17265452N5459KPropability One LLC · Daytona Beach, FLBuilt 1980 · S/N 17274125N545DSAero Maintenance Inc · Vancouver, WABuilt 1980 · S/N 17273867N545PZLake Placid Flying Service Inc · Lake Placid, NYBuilt 1976 · S/N 177RG1023N545STBusiness Jet Managers Inc · Canton, MIS/N P21000553N5460BSkyway Inc · Wilmington, DES/N 15283875N5461HWhitson Johnny E · Cleveland, TXBuilt 1979 · S/N 15284102N5461KFaragallah Allan A · Garden Grove, CABuilt 1980 · S/N 17274127N5461SCarter Kenneth M Jr · Castle Rock, COBuilt 1980 · S/N R18201577N54628Ohio State University · Columbus, OHBuilt 1981 · S/N 17275013N5462QLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17261792N5462THebert David · Lafayette, LABuilt 1982 · S/N R18201874N54633Warner Walter M · Willow, AKBuilt 1981 · S/N 17275016N54634Savannah Airplane Venture LLC · Myrtle Beach, SCBuilt 1981 · S/N 17275017N54635Memphis Navy Flying Club · Millington, TNBuilt 1981 · S/N 17275018N5463JMachado Joe L · Tucson, AZBuilt 1980 · S/N 17273804N5463KRick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274129
Back to AD 80-25-07 R1