OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,368

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.

N90968Petrie Robert J · Eagleville, TNBuilt 1972 · S/N 896-73N90969Trinity Aire LLC · Drakesville, IAS/N 897-73N9096HCallaway Mary Ann · Homedale, IDBuilt 1975 · S/N 17265941N9096VDorris Paul T · Ona, WVS/N 690010N90971Solsvig Jason A · Wasilla, AKS/N 331-73N90973Skydive Santa Barbara LLC · Lompoc, CABuilt 1973 · S/N 902-73N90974Pruszenski Jordan M · Anchorage, AKBuilt 1973 · S/N 433-73N90975Schiestle Jason · Greenville, PAS/N 65-73N90976Muinos Jose M · York, PABuilt 1973 · S/N 343-73N9097LHoover Mark B · Wasilla, AKBuilt 1970 · S/N 789-71N9097VKnutson Alan R · Chaska, MNBuilt 1969 · S/N 690021N90984Holt Ken C · Tillar, ARS/N 438-73N90987Registration Pending · Turner, MTRegistration pendingBuilt 1973 · S/N 907-73N90989Carson Daniel Fred Trustee · Great Falls, MTBuilt 1973 · S/N 439-73N9098LDavenport Ross K · Raleigh, NCS/N 794-71N90991Roth Douglas D · Lincoln, NEBuilt 1973 · S/N 346-73N90992Fried Bernard S · Spring Branch, TXBuilt 1973 · S/N 908-73N90993Crosswell Joe · Springtown, TXBuilt 1973 · S/N 441-73N90996Destefano Patrick S · Bryan, TXBuilt 1973 · S/N 443-73N90997Pond Timothy A · Middletown, OHBuilt 1973 · S/N 909-73N90998Culvar Philip M · Granite City, ILBuilt 1973 · S/N 347-73N9099CCasa Miguelita LLC · Santa Fe, NMS/N R18200398N909MPSky Guy LLC · Frankenmuth, MIBuilt 1972 · S/N 291-72N909RMPierro Darrell · Cohasset, CAS/N 24-0636N909SKaluahine Fredstan · Lihue, HIS/N 15280969N909VCSan Bernardino Community College District · San Bernardino, CAS/N 17261045N90AVCag Aircraft Holdings LLC · Crystal River, FLBuilt 1974 · S/N 462-74N90CABlue Max Aviation LLC · El Cajon, CABuilt 1976 · S/N 93376N90DZPjm Aviation LLC · Labelle, FLBuilt 1979 · S/N R18200711N90FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 17273139N90GEWc Three LLC · Wilmington, DEBuilt 2018 · S/N 1174-2018N90GKPruitt Russell · Athens, GABuilt 2021 · S/N 1192-2021N90GTHawk Aviation LLC · Buffalo, NYBuilt 2017 · S/N 1172-2017N90HAGarzony Anthony · Toledo, OHBuilt 1979 · S/N 17272658N90JMNoriega Air Holdings LLC · Tampa, FLBuilt 1965 · S/N 747N90LALakeside Aerodome Ltd · Clermont, FLBuilt 1995 · S/N 1207-95N90MJBlack Alan · Mariposa, CAS/N 21063458N90RWWallace Richard · Santa Teresa, NMBuilt 1979 · S/N 21063283N90TLColorado Aviators LLC · Gypsum, COBuilt 1979 · S/N P21000206N9100HHastings Stephen J · Palmer, AKBuilt 1975 · S/N 17265944N9101CJanak Jeffrey · Corpus Christi, TXBuilt 1978 · S/N R18200399N9102LCook James C · Auburn, ALBuilt 1971 · S/N 259-71N9103VMullis Stephen P Jr · Hazlehurst, GABuilt 1969 · S/N 690022N9104LKalman Engineering Inc · Pekin, ILS/N 261-71N9104VBrooker Richard I · Southlake, TXS/N 690014N9105Stoyanov Nikolay S · Jersey City, NJBuilt 1977 · S/N 17268842N9106CUpper Valley Flying Club Inc · White Riv Jct, VTBuilt 1978 · S/N R18200400N9106HLapenna Mark A · Madison, INBuilt 1975 · S/N 17265947N9106LShipman Jesse L · Honey Grove, TXBuilt 1970 · S/N 795-71N9107CCagle Holdings LLC · Jenks, OKBuilt 1978 · S/N R18200401
Back to AD 80-25-07 R1