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.

N2251TGardner Bryan T · Rancho Cucamonga, CABuilt 1977 · S/N R18200007N2252YMeisch Robert L · Crystal, MNBuilt 1967 · S/N 17700052N2253YAviation 2000 Inc · Fort Mill, SCBuilt 1967 · S/N 17700053N2255EJohnson Steven Allan · Palmer, AKBuilt 1982 · S/N 17275692N2256SGuttzeit Aviation LLC · Baton Rouge, LAS/N R18201316N2257RCanales Jorge · Anthony, NMBuilt 1978 · S/N R18200582N2258JPluhar Darrin P · Ekalaka, MTBuilt 1979 · S/N T18803441TN2258YConnor Thomas M · Great Falls, MTBuilt 1967 · S/N 17700058N22598Dimler Travis M · Alpine, TXBuilt 1974 · S/N 17264071N225ACSafeflight Alliance Inc · Osprey, FLBuilt 1996 · S/N 774-96N225ANCalifornia In Nice Inc · San Jose, CABuilt 1986 · S/N 17276615N225FRDi Donato Michael · Celina, TXBuilt 1980 · S/N 17273947N225JACoffin Paul · Sioux City, IABuilt 1979 · S/N R18201320N225JSAircraft Holdings LLC · Edmond, OKS/N 17274385N225MHMissall Zoe S · Ontario, NYBuilt 1974 · S/N 17263156N225QZHoward Alan L · Leeds, UTBuilt 1969 · S/N 138N225SGWilliams Stephen W · Granbury, TXBuilt 2006 · S/N 1018-2006N225THMariner John M · Houston, TXBuilt 2010 · S/N 535-2010N2260TOrtner Airport LLC · Wakeman, OHBuilt 1977 · S/N R18200012N2260YReich Bruce D · Red Oak, IABuilt 1967 · S/N 17700060N2261YKemper Dennis R · Carmichael, CABuilt 1967 · S/N 17700061N2262YRegistered aircraftBuilt 1967 · S/N 17700062N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014N2263YMejia Mauricio · South Gate, CABuilt 1967 · S/N 17700063N2265YHemann Dale F · Osage, IABuilt 1967 · S/N 17700065N2267YCole Gary L · Richmond, TXBuilt 1967 · S/N 17700067N22689Ridge View Aviation LLC · Napanoch, NYBuilt 1974 · S/N 17264073N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317N2269PBlackwell Steve · Lewisburg, TNBuilt 1966 · S/N 670152N226ADDercole Anthony · Bowden, GABuilt 1967 · S/N 680076N226BFRichmond Charles H · Denison, TXS/N 7-72N226CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266762N226DMFewel Lance E · Lake Oswego, ORBuilt 1976 · S/N 177RG0929N226JAXin Han Aviation LLC · Atwater, CABuilt 1976 · S/N 17266688N226RLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 24-3427N226WTFegert Jeffery · Las Vegas, NVS/N R18201735N2271ESharmouj Raymond · St Croix, VIBuilt 1978 · S/N 17271215N2272YWilson Matthew C · Robinson, ILBuilt 1967 · S/N 17700072N2274PAvaero LLC · Worthington, OHBuilt 1973 · S/N 17261637N22752Flying Tigers Flight School Ltd · Houston, TXBuilt 1974 · S/N 17264075N22754Gomez Abigail S · Carlsbad, CABuilt 1974 · S/N 17264076N2276SBogaudo Robert J · Vulcan, MIBuilt 1979 · S/N R18201318N2277SSimmons Matthew Steven · Port Orange, FLBuilt 1979 · S/N R18201319N227ACBoeger Cade Patrick · Oroville, CABuilt 1977 · S/N 335-77N227ANCalifornia In Nice Inc · San Jose, CAS/N 17274683N227FBAtlantic Flying Club Inc · Fernandina Beach, FLBuilt 1979 · S/N 17272654N227SFSager Charles K · Hedgesville, WVBuilt 2000 · S/N 437-2000N2280TRegistered aircraftBuilt 1977 · S/N R18200016N2281TAvpac Insurance Services Inc · Santa Ana, CABuilt 1977 · S/N R18200017N2283SForbess Tod A · Lubbock, TXS/N R18201323
Back to AD 80-25-07 R1