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.

N26MPPompeo John · Gorham, MEBuilt 2024 · S/N 1486-2024N26PFPucciariello Alexander A · Haskell, NJS/N 35-72N26PKLauda Thomas J · Des Moines, IABuilt 1974 · S/N 1041-74N26RSStacey Enterprises Inc · Ogden, UTBuilt 1978 · S/N P21000153N26TFTop Flight Aviation Inc · Corona, CABuilt 1972 · S/N 17261318N26TPGlobal Aerials Inc · Pembroke Pines, FLFirst renewal noticeBuilt 1967 · S/N 17700144N26ZWeber Mark S · Wildwood, MOBuilt 1969 · S/N 17258153N2700WHughes Karen A · Dandridge, TNBuilt 1966 · S/N 1015N2701WWadsworth Van W · Sidney, OHBuilt 1966 · S/N 1016N2702WMedic Choppers LLC · Springdale, ARS/N 3329N2703VInman David M · Vancouver, WABuilt 1975 · S/N 177RG0663N2706VBeuschel Timothy W · Mount Pleasant, WIBuilt 1975 · S/N 177RG0666N2706WElliott Frank F · Mojave, CABuilt 1966 · S/N 1019N2707WLund Tyler David · San Diego, CABuilt 1966 · S/N 3331N270ATsg Associates LLC · Stanley, NCBuilt 1978 · S/N R18200067N270AMCode 1 Flight Training LLC · Wills Point, TXBuilt 1973 · S/N 17262722N270SVJones Joseph D · Broken Arrow, OKBuilt 1978 · S/N 15282329N2711WAerotec LLC · Denver, NCBuilt 1966 · S/N 1022N2711ZSchmelzer Thomas D · Lino Lakes, MNBuilt 1978 · S/N 368-78N2712GGrady'S Auction & Realty Inc · Newport, ARBuilt 1967 · S/N 14N2712WFadio David C · Elmira, NYBuilt 1966 · S/N 3333N2713WDutro Tammy S · Dublin, OHBuilt 1966 · S/N 3334N2716WBig Sky Aviation LLC · Meridian, IDBuilt 1966 · S/N 1025N2716ZWilson Miles · Mcminnville, TNBuilt 1978 · S/N 354-78N2719WNance Russell · Pelion, SCBuilt 1966 · S/N 1026N271APatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2002 · S/N 905-2002N271AMMonthy Christian · Van Nuys, CABuilt 1973 · S/N 17262510N271GTBroulik Robert L · Lisbon, IABuilt 1976 · S/N 17267114N271MAWing Runner Aviation LLC · Lakewood Ranch, FLBuilt 2003 · S/N 475-2003N271RGCapitol City Flyers Inc · Madison, WIBuilt 1978 · S/N R18200528N2720EAmerican Patrols Inc · Midland, TXBuilt 1978 · S/N 17271305N2720WSharbono Dennis E · Billings, MTBuilt 1966 · S/N 1027N2723EMarshals Technology LLC · Martinez, GABuilt 1978 · S/N 17271306N2723WSenneff James L · Clarence, NYBuilt 1966 · S/N 3337N2724WHebert David D · Mcalester, OKBuilt 1966 · S/N 3338N2725WMorris Curtis D · Magnolia, TXS/N 1029N2725ZGeorge Ladelle L · Ashley, NDS/N 1231-78N2726FMid America Sprayers Inc · Ulysses, KSBuilt 1979 · S/N 15282841N2726VTurpin Michael · Rcho Sta Marg, CABuilt 1975 · S/N 177RG0673N2727GTetrad Corp DBA · Lusk, WYBuilt 1967 · S/N 10N2727VFitzgerald Kevin C · College Station, TXS/N 177RG0674N2728WNash Richard D · Edgewood, WABuilt 1966 · S/N 3339N272ACFlying Radish LLC · Vineyard Haven, MABuilt 1998 · S/N 1253-98N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914N272SGLehner Raymond A Jr · North Fort Myers, FLBuilt 2004 · S/N 969-2004N272TLSanders Flight Training Center · Jasper, ALS/N 17270719
Back to AD 80-25-07 R1