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.

N9127SBenson Brandon · Woodcliff Lake, NJBuilt 1992 · S/N 24-3275N9128LSmith Stuart T · Murrieta, CAS/N 199-71N9128NN9128n LLC · Wilmington, DEBuilt 1990 · S/N 24-3193N9128VAyers Walter L · Spokane, WABuilt 1969 · S/N 690020N9129LOsi Flyers Inc · Oak Ridge, TNBuilt 1970 · S/N 265-71N9129XMirabelli Marcello F · Ocean View, NJBuilt 1994 · S/N 24-3347N912GMAvl Aviation LLC · Madison, GABuilt 1974 · S/N 177RG0535N912MAEmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2004 · S/N 9482004N912VWThomas David A · Halifax, MABuilt 1968 · S/N 17700859N912YAChewelah Flyers · Chewelah, WAS/N 17264195N91307Barton Kenneth G · Ormond Beach, FLS/N 24-3201N9130BGriffin John A · Austin, TXBuilt 1990 · S/N 24-3198N9130LJohnsen David E · Oklahoma City, OKBuilt 1970 · S/N 805-71N9130VGoettsch Freddie J Trustee · Hancock, IABuilt 1969 · S/N 690026N91315Kearley Greg A · Lafayette, LABuilt 1981 · S/N 38-81A0159N91319Bas Part Sales LLC · Greeley, COS/N 38-81A0147N9131CScott Michael F · Dothan, ALBuilt 1978 · S/N R18200415N9131HStroemsuik Kristian · Strasburg, VAS/N 17265962N9131LAeronautical Technical Service Inc · Collierville, TNS/N 806-71N9131NShutt Dean J · Jacksonville, ORBuilt 1996 · S/N 24-3397N91325Korenko Kirk A · Granite Bay, CABuilt 1981 · S/N 38-81A0163N91326James F Harwick & Associates Inc · Lafayette, LABuilt 1991 · S/N 24-3212N91332T-32 Associates · Effort, PAS/N 38-81A0168N9133YDe Air Ops LLC · Wilmington, DES/N 24-1699-14N91341Wheeler Shaun W · Covington, TNBuilt 1982 · S/N 38-82A0007N9134HRegistration Pending · Kalispell, MTRegistration pendingS/N 17265964N9134LSipes Greg A · North Pole, AKS/N 310-71N9134VUtilities Consulting Services LLC · Clearwater, FLBuilt 1969 · S/N 690027N9135VPierro Darrell · Cohasset, CABuilt 1969 · S/N 690033N9135WLyons Patrick J · Missouri City, TXFirst renewal noticeBuilt 1991 · S/N 24-3228N9135ZMccabe David P · Tower, MNS/N 24-3229N91365Hangarsplus LLC · Lantana, TXBuilt 1990 · S/N 24-1704-14N9136AYensid Aviation LLC · Wilmington, DEBuilt 1994 · S/N 24-3353N9136BMeltzer Ronald · New York, NYBuilt 1991 · S/N 24-3231N9136NGeorge Richard P Jr · Klein, TXBuilt 1992 · S/N 24-3284N9136VDaniels Jeff W · Athens, GAFirst renewal noticeBuilt 1969 · S/N 690022N91372Higgins Robert S · Granbury, TXBuilt 1981 · S/N 38-81A0169N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966N9137UBarry Casey B · Wichita Falls, TXBuilt 1996 · S/N 24-3380N9137YDuckworth James D · Canterbury, NHS/N 24-3234N91382Ohara Tim · East Liverpool, OHBuilt 1991 · S/N 24-3238N91383Rieder Josh · Boone, NCBuilt 1981 · S/N 38-82A0021N91386Shred Box LLC · Hayesville, NCBuilt 1981 · S/N 38-82A0022N9138GTlc Flying Inc · Colfax, WABuilt 1973 · S/N 18801390N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N9138NSchertz Jay H · Lowpoint, ILBuilt 1991 · S/N 24-3235N9138VJackson Harold G · Provo, UTBuilt 1969 · S/N 690023N9138ZPrengaman Jeremy S · Lynden, WABuilt 1991 · S/N 24-3219N91396Willard Malcolm · Williston, VTBuilt 1995 · S/N 24-3355N9139CA F S Inc · Grants Pass, ORS/N R18200416
Back to AD 80-25-07 R1