OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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.

N738KAFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17270027N738KCCarter Flygare Inc · Sacramento, CABuilt 1977 · S/N 17270029N738KFShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 17270032N738KG738 Kilo Golf LLC · Southern Shores, NCBuilt 1977 · S/N 17270033N738KJFly Compton Aeronautical Education Foundation · Compton, CAS/N 17270035N738KKSpradley Amanda · Greenwood, SCFirst renewal noticeBuilt 1977 · S/N 17270036N738KPJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1977 · S/N 17270040N738KQYeomans James S · Harvey Cedars, NJBuilt 1977 · S/N 17270041N738KTGetaway Aviation LLC · Spring Lake, MIS/N 17270044N738KUBoehmlehner Steven A · Rosholt, SDBuilt 1977 · S/N 17270045N738KWAvetrani Jose A · Miami, FLBuilt 1977 · S/N 17270047N738LCCruise Flight Academy Inc · Dalton, GABuilt 1977 · S/N 17270053N738LGSchultz Leesa · Mesquite, NVS/N 17270057N738LHLh Enterprise LLC · Eads, TNS/N 17270058N738LMBlack Bear Aviation LLC · Scottsdale, AZBuilt 1977 · S/N 17270062N738LNSidor David R · Palm Desert, CABuilt 1977 · S/N 17270063N738LPPython Financial LLC · Kalispell, MTBuilt 1979 · S/N R18200938N738LSKingfisher Assurance LLC · Fort Worth, TXBuilt 1979 · S/N R18200939N738LUUrquhart Air LLC · Parker, COS/N R18200940N738LVUrban Aviation Services Inc · Paxton, MABuilt 1977 · S/N 17270070N738MCMoore Michael E · Shawnee, KSS/N 17270076N738MEN738me LLC · Miami, FLS/N 17270078N738MHCurtis Creek Aviation LLC · Kalispell, MTS/N 17270081N738MJOptic Air LLC · Sioux Center, IABuilt 1977 · S/N 17270082N738MKObrien Aviation Inc · Port Orange, FLBuilt 1977 · S/N 17270083N738MLSouthern Wings Aircraft Sales Ltd · Bethany, OKBuilt 1977 · S/N 17270084N738MRNew World Air LLC · Orland Park, ILS/N 17270088N738MTJulep Arbor Flying LLC · Salisbury, NCBuilt 1977 · S/N 17270090N738MWN738mw LLC · Jupiter, FLBuilt 1977 · S/N 17270093N738MZCarrasco Alonzo · Burleson, TXBuilt 1977 · S/N 17270096N738NBLele Aviation LLC · Denver, COBuilt 1977 · S/N 17270098N738NCAndrosky Mark J · Superior, WIBuilt 1977 · S/N 17270099N738NDFood From The Forest LLC · Wilmington, DEBuilt 1977 · S/N 17270100N738NGMusson Jeffrey L · Racine, WIBuilt 1977 · S/N 17270103N738NHUS Navy Commander Navy Installation Command · Millington, TNBuilt 1978 · S/N 17270104N738NKAscutney Air LLC · Claremont, NHBuilt 1977 · S/N 17270106N738NMRegistration Pending · Burlington, WIRegistration pendingS/N 17270108N738NNAero Aviation LLC · Long Beach, CABuilt 1977 · S/N 17270109N738NQSimmons Calvin L · Washington, UTBuilt 1979 · S/N R18200945N738NSGibson Field · Paso Robles, CABuilt 1979 · S/N R18200947N738NTChamberlain Sheldon L · Patterson, LABuilt 1977 · S/N 17270114N738NUAeroflyin Corp · Miramar, FLS/N 17270115N738NXAbove All Aviation Inc · Goleta, CABuilt 1977 · S/N 17270118N738NYMonmouth Area Flying Club Inc · Lakewood, NJBuilt 1977 · S/N 17270119N738PDMontgomery Robert E · Fairfax, VABuilt 1977 · S/N 17270123N738PGBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18200949N738PHStroemsvik Kristian · Strasburg, VABuilt 1977 · S/N 17270127N738PJGeebee Ventures LLC · Belgrade, MTBuilt 1977 · S/N 17270128N738PKTss Flying Club Inc · Bethesda, MDBuilt 1979 · S/N R18200950N738PMDaviation Inc · Willoughby, OHBuilt 1977 · S/N 17270131
Back to AD 80-25-07 R1