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.

N9139XDurica John N · Dunedin, FLBuilt 1991 · S/N 24-3241N9139YJune26 Investments LLC · Pinehurst, NCBuilt 1991 · S/N 24-3218N9139ZTseline Aleksei · Cary, ILBuilt 1992 · S/N 24-3285N913JKKing Michelle L · Atlanta, GABuilt 1974 · S/N 1018-74N913JNCornell Kevin L · Albuquerque, NMBuilt 1981 · S/N 24-1184N913SEHill Capital Leasing LLC · Phoenix, AZBuilt 1978 · S/N P21000038N913TAChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285317N913ZMStieren George L · Kerrville, TXBuilt 1986 · S/N 24-1607N9140LPretorius Ellen T · Smithville, OHBuilt 1971 · S/N 807-71N9140VN914ov LLC · Greensboro, NCBuilt 1969 · S/N 690028N9140XScoffield Russell C · Hayden, IDBuilt 1991 · S/N 24-3245N91414Richardson James R · Brandon, MSBuilt 1981 · S/N 38-82A0027N9141LAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 808-71N9141VFlitton Mark S · Enterprise, ALS/N 690010N9142CIndiana Aviation Inc · Nicktown, PABuilt 1978 · S/N R18200417N9142HSamand Aviation Holdings LLC · Palm Coast, FLBuilt 1996 · S/N 24-3381N9144VHardin Ralph · New Plymouth, IDBuilt 1969 · S/N 690029N9145CReitz Andrew P · Pembroke Pines, FLS/N R18200419N9145VRoe Cameron · Salt Lake City, UTBuilt 1969 · S/N 690011N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9146QEmery J Chang Md LLC · Lakeview, ORBuilt 1996 · S/N 24-3384N9146VWood David Allen · Conyers, GABuilt 1969 · S/N 690025N9147VN206ht LLC · Pulaski, IABuilt 1969 · S/N 690037N9148GCheutin Didier V · Orlando, FLBuilt 1995 · S/N 24-3362N9149CBryan Robert G · New Lenox, ILBuilt 1978 · S/N R18200422N9149QCovington James A · Huntsville, ALBuilt 1996 · S/N 24-3377N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N9150VUrness John · Oakland, CABuilt 1969 · S/N 690038N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9151VNeret Michael G · Sugarland, TXBuilt 1969 · S/N 690031N9151YRegistration Pending · South Jordan, UTRegistration pendingBuilt 1995 · S/N 24-3366N9152LBaker Glen M · El Reno, OKBuilt 1971 · S/N 810-71N9152NH S Williams Co Inc · Marion, VABuilt 1997 · S/N 24-3408N9153CPax Enterprises Inc · Allen, TXBuilt 1978 · S/N R18200425N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N9153VRegistered aircraftBuilt 1969 · S/N 690027N91544Piper Aircraft Inc · Vero Beach, FLBuilt 1981 · S/N 38-82A0050N91550My 3 Sons Inc · Middletown, DEBuilt 1992 · S/N 24-3251N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N9155CN9155c LLC · Palm Harbor, FLBuilt 1978 · S/N R18200427N9155VHickox Joseph C · Rollins, MTBuilt 1969 · S/N 690032N9155XReiman Edward T · Levittown, NYBuilt 1994 · S/N 24-3336N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156VLegnaioli Richard · Cambridge, MDS/N 690013
Back to AD 80-25-07 R1