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.

N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716N264MAShaffer John C · Talkeetna, AKBuilt 2004 · S/N 482-2004N2650WBrown Danny L · Wichita, KSS/N 983N2650ZFrederick James H · Springfield, OHBuilt 1977 · S/N 1223-77N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307N2651ZHelburg Michael L · Libby, MTS/N 1004-77N2652VTrapp Terry Lee Trustee · The Dalles, ORBuilt 1974 · S/N 177RG0644N2652WRegistered aircraftBuilt 1966 · S/N 3308N2653WDyer Perri P · Argyle, TXS/N 984N2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationBuilt 1974 · S/N 177RG0645N2654ZAlbij3 LLC · Milton, FLBuilt 1977 · S/N 358-78N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196N2656ZChesebro Brian S · Oro Valley, AZBuilt 1977 · S/N 360-78N2657WRegistered aircraftBuilt 1966 · S/N 3310N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198N2658WPerez Dennys · Orlando, FLBuilt 1966 · S/N 987N2659WMooney Flyer LLC · Belton, SCBuilt 1966 · S/N 1007N2659ZWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284521N265ACMorgan Nigel · Asheville, NCBuilt 1998 · S/N 407-98N265CAZacherl Randall L · Indiana, PABuilt 2004 · S/N 965-2004N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081N265MATrevathan Max Tyler · Braggadocio, MOBuilt 2003 · S/N 937-2003N2660WDeptula John R · Pinehurst, NCBuilt 1966 · S/N 989N2662VPeck Kim O · Bolton, MABuilt 1974 · S/N 177RG0647N2662WEaton Mark E · Houston, TXBuilt 1966 · S/N 3312N2663ZVaccaro Glen J · Trinidad, COBuilt 1977 · S/N 362-78N2664VKeaveny Kelly J · Annandale, MNBuilt 1974 · S/N 177RG0648N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201N2665ZRegistered aircraftBuilt 1978 · S/N 351-78N2666ZBig Falls Flying Club Inc · Intl Falls, MNS/N 1224-78N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994N2671GAas LLC · Ovid, MIBuilt 1967 · S/N 316N2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316N2672ZPuma Applied Science · Winchester, CABuilt 1977 · S/N 1007-78N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997N2676ZFlynn Steven W · Bushnell, FLBuilt 1977 · S/N 1008-78N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318N2677ZWillkris Aviation Services LLC · Smithfield, VAS/N 1018-78N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999N267GSArnold Airplane LLC · North Branch, MNBuilt 1994 · S/N 737-94N267JMomentum Foundation Inc · Tullahoma, TNBuilt 2011 · S/N 1110-2011
Back to AD 80-25-07 R1