AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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.

N83564Higginbotham James M · Yelm, WAS/N 7AC2235N83569Ron Alexander Youth Aviation Program · Williamson, GABuilt 1946 · S/N 7AC-2246N8356VGroh David A · Mason, MIBuilt 1966 · S/N 478N8357VHaas Daniel S · Camarillo, CABuilt 1966 · S/N 136N83581N83581 LLC · Manassas, VABuilt 1946 · S/N 7AC-2257N83583Link James L · Raleigh, NCBuilt 1946 · S/N 7AC-2259N83587Porter Flying Service LLC · Missoula, MTS/N 7AC-2263N83588Air Emergency Service · Mount Pleasant, PABuilt 1946 · S/N 7AC-2264N83589Pouncey Bert Claud IV · Proctor, ARS/N 7AC-2265N83591Felling Benjamin C · Barrett, MNS/N 7AC-2267N8359VCressman Scott M · Mount Pleasant, TXBuilt 1966 · S/N 412N83600Studer Pat · Shelby, MIBuilt 1946 · S/N 7AC-2276N83603Skylink Aviation Inc · Florissant, MOBuilt 1946 · S/N 7AC-2279N83605Garrison Gary D · West Salem, ILBuilt 1946 · S/N 7AC-2281N83606Hayter Andrew J · Newtown, PABuilt 1946 · S/N 7AC-2282N83610Bridges John N Trustee · Tioga, TXBuilt 1946 · S/N 7AC-2286N83617Draggin Tail Flyers LLC · Ephrata, PABuilt 1946 · S/N 7AC-2294N83618Mcglumphy Jack B · Gilbert, SCBuilt 1946 · S/N 7AC-2295N83619Foxtrot Aero LLC · Libertyville, ILBuilt 1946 · S/N 7AC-2296N83627Flagg Robert F · Castro Valley, CABuilt 1946 · S/N 7AC-2305N83630Karp Gregg S · Oakdale, NYFirst renewal noticeBuilt 1946 · S/N 7AC-2308N83632Moody James W · Alexandria, LABuilt 1946 · S/N 7AC-2310N83635Huss Leon J · Lonoke, ARBuilt 1946 · S/N 7AC-2313N83638Froh Nathan · Catawba, NCBuilt 1946 · S/N 7AC-2316N83639Payne Jan T · Glenwood, MNBuilt 1946 · S/N 7AC-2317N83643Burg John Carl · Mc Gregor, IAS/N 7AC-2321N83644Jensen Richard J · Cedar Springs, MIBuilt 1946 · S/N 7AC-2322N83646Grossi Alexander Jr Trustee · Grants Pass, ORBuilt 1946 · S/N 7AC-2324N83647Jacobs Mark W · Eureka, MTBuilt 1946 · S/N 7AC-2325N83650Keiser William B III · Ridgely, TNS/N 7AC-2328N83651Shema Dennis · Warner Robins, GABuilt 1946 · S/N 7AC-2329N83652Neil Thomas · Warrenton, VABuilt 1946 · S/N 7AC2330N83653Ayers Mark T · Whitney, TXBuilt 1946 · S/N 7AC-2331N83655Thompson Daniel W · Catawba, NCBuilt 1946 · S/N 2333N83656Stahoviak Norman L · Michigan City, INBuilt 1946 · S/N 7AC-2334N8365VJarvis Stormy A · Anchorage, AKBuilt 1966 · S/N 66N83667Johnson Harvey P · Roseau, MNBuilt 1946 · S/N 7AC-2345N83668Aichele Michael J · Owasso, OKBuilt 1946 · S/N 7AC-2346N83673Everson Harold E · Granville, NDFirst renewal noticeBuilt 1946 · S/N 7AC-2351N83676Frost David R · Utopia, TXS/N 7AC-2354N83677Romanowski Lucas W · Cadott, WIBuilt 1946 · S/N 7AC-2355N83683Hangar LLC · Vero Beach, FLBuilt 1946 · S/N 7AC-2361N83686Floyd Lucas · Bouton, IABuilt 1946 · S/N 7AC-2364N83687Scafe Travis W · Tuttle, OKS/N 7AC-2365N83688Silver Linings Aviation LLC · Concord, GABuilt 1946 · S/N 7AC-2366N8368VRare Air LLC · Forsyth, MTBuilt 1966 · S/N 49N83690Athol Orange Aero Club Inc · Athol, MABuilt 1946 · S/N 7AC-2368N83696Coulter Frank R · Cygnet, OHBuilt 1946 · S/N 7AC-2374N8369VCentral Virginia Aviation Inc · N Dinwiddie, VAS/N 468N836ZRegistered aircraftS/N 138
Back to AD 2000-25-02 R1