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.

N9195LStatewide Transportation LLC · Oklahoma City, OKBuilt 1971 · S/N 293-72N9195VHunter Robert J DBA · Montgomery, ALBuilt 1969 · S/N 690041N9196HLaplante Rene J · Bellingham, WABuilt 1975 · S/N 17266008N9196LRunyon Larry · Susanville, CABuilt 1971 · S/N 294-72N9196VScherbarth Kenneth C · Eatonville, WABuilt 1969 · S/N 690051N9197LSchutze Curt K · Knoxville, TNBuilt 1971 · S/N 295-72N91984A-Line LLC · Kent, WABuilt 1973 · S/N 17261532N9199AArgos Retail LLC · Mcallen, TXBuilt 1982 · S/N 38-82A0111N919DCDelaware Corp · Topping, VABuilt 1976 · S/N 177RG1055N91CPBas Part Sales LLC · Greeley, COS/N 24-0694N91DSMckinney Mark M · Silsbee, TXBuilt 1963 · S/N 106N91FTLegassey Matthew G · Millinocket, MEBuilt 1966 · S/N 107N91HLWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1982 · S/N 15285648N91LVWoodfield Terry J · Pearland, TXBuilt 1980 · S/N 172RG0281N91PAHigh Wing Air LLC · Arnold, MOBuilt 1972 · S/N 17260792N91PMRunrich LLC · Newport News, VABuilt 1974 · S/N 17264113N91QSFly Diablo Inc · North Wales, PABuilt 1976 · S/N 17268167N91RARare Aircraft Ltd · Faribault, MNBuilt 2003 · S/N 472-2003N91YRau Lois M · Liberty, KSBuilt 1962 · S/N 2188N92006Troughton Jill A · Spring Hill, FLBuilt 1973 · S/N 17261535N9200CShepard Philip A · Trophy Club, TXBuilt 1978 · S/N R18200443N92014Shotwell Land Management Co LLC · Jackson, MSS/N 17261538N9201AN9201a LLC · Oro Valley, AZFirst renewal noticeBuilt 1978 · S/N 24-0610N9201HSparkwizard LLC · Greenville, RIBuilt 1975 · S/N 17266012N9201MT-Smht LLC · Shoals, INBuilt 1978 · S/N 24-0611N9201TEisenhardt Scott · Milwaukee, WIBuilt 1978 · S/N 24-0615N9201VHay Edward P Jr · Chico, CABuilt 1969 · S/N 690043N92026Haltom Frances F · Alva, OKS/N 17261539N9202MCarlson John C · South Haven, MIBuilt 1966 · S/N 3432N9202VGiddens Robert F · Duncan, OKS/N 690043N92035Ford Daniel T · Warsaw, INBuilt 1973 · S/N 17261540N9203VInnovative Poultry Products LLC · Olar, SCBuilt 1969 · S/N 690053N9204GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801423N9204MBrown Gary M · Wales, MIS/N 1171N9204VDahle Avenue Aviation LLC · Faribault, MNS/N 690044N9205MSchiro Joseph A · Birdseye, INBuilt 1966 · S/N 1172N9205RRegistration Pending · Manito, ILRegistration pendingBuilt 1975 · S/N 18802150TN9205VBlaylock James · Las Vegas, NVS/N 690054N9206MCrews William J · Jacksonville, FLBuilt 1966 · S/N 3433N9206VRegistered aircraftBuilt 1969 · S/N 690045N9208MWright Matthew K · Hollister, CABuilt 1966 · S/N 1173N9209AAerospace Trust Management LLC Trustee · Wilmington, DES/N 38-82A0113N9209MFloyd Thomas H · Reno, NVS/N 1174N920AJAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263234N920BEGalaxy Aviation LLC · Nantucket, MABuilt 1979 · S/N 15283538N920GBales Don · Oakhurst, CABuilt 1981 · S/N 172RG0901N920NZAltura Aviation 3-Nz LLC · Waxhaw, NCS/N P21000309N920SBDream Cloud Aviation LLC · Saint Marys, PABuilt 1978 · S/N R18200444N92103Pgd Flyers Inc · Cape Coral, FLBuilt 1973 · S/N 17261545N9210HFlex Air Holdings Inc · Wilmington, DEBuilt 1975 · S/N 17266017
Back to AD 80-25-07 R1