OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,561

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.

N2683ETallahatchie Tailwheel Training LLC · Charleston, MSBuilt 1946 · S/N 7AC-6263N2683ZAmmlim LLC · Vacaville, CABuilt 1978 · S/N 1227-78N2684GBlair Daniel S · Perrysburg, OHS/N 546N2685EGarner Glenwood Jr · Newport, NCBuilt 1946 · S/N 7AC-6266N2687EAm Flite Inc · Valley, NEBuilt 1946 · S/N 7AC-6267N2687ZSchaefer Richard T · Marble Falls, TXBuilt 1978 · S/N 365-78N2688EGawthrop Keirn R · Westfield, INBuilt 1946 · S/N 7AC-6268N268BHJett Cory L · Floyds Knobs, INS/N 888-76N268JGSpero Bruce A · Carson City, NVS/N 4N2692ENorris Ken DBA · Sumner, TXBuilt 1946 · S/N 7AC-6272N2693ZCoen Brady · Wiley, COS/N 268-78N2695ZJark David L · Stratford, SDS/N 1015-78N2696GGrabeman Allan · Fishers, INBuilt 1967 · S/N 325N2696ZAdriatic Holdings LLC · Cheyenne, WYBuilt 1978 · S/N 1230-78N269ACBurks Aviation Inc · Hattiesburg, MSBuilt 2002 · S/N 1386-2002N269MAOrange Wing Aviation Inc · Wilmington, DES/N 1361-2004N26BYSnohoacro LLC · Mukilteo, WABuilt 2004 · S/N 963-2004N26MPPompeo John · Gorham, MEBuilt 2024 · S/N 1486-2024N26PFPucciariello Alexander A · Haskell, NJS/N 35-72N26PKLauda Thomas J · Des Moines, IABuilt 1974 · S/N 1041-74N2700ECarter Michael J · Belvidere, ILBuilt 1946 · S/N 7AC-6280N2702EMoore Gregory J · Bakersfield, CABuilt 1946 · S/N 7AC-6282N2703CArvidson Donna E · Brighton, MIS/N 7BCM-345N2704EChamp 2704e Members LLC · Bountiful, UTBuilt 1946 · S/N 7AC-6284N2707EVirga Partners Inc · Livingston, MTBuilt 1946 · S/N 7AC6287N2709ANorth Carolina Aviation Museum And Hall Of Fame · Asheboro, NCBuilt 1947 · S/N 7BCM-161N2709EHahola James J · Easton, PAS/N 7AC-6289N2710AMakely Abraham M · Culpeper, VABuilt 1947 · S/N 7BCM-281N2711ZSchmelzer Thomas D · Lino Lakes, MNBuilt 1978 · S/N 368-78N2712ESeuferer Kevin J · Osceola, IABuilt 1946 · S/N 7AC-6292N2712GGrady'S Auction & Realty Inc · Newport, ARBuilt 1967 · S/N 14N2713AAlpha Enterprises Inc · Lercester, NCBuilt 1947 · S/N 7BCM-338N2713EDe Haas Steven E · Lotus, CABuilt 1946 · S/N 7AC-6293N2714EAndrews Elaine B · Puyallup, WABuilt 1946 · S/N 7AC-6294N2716ETerri Air Service LLC · Wilmington, DES/N 7AC-6296N2716ZWilson Miles · Mcminnville, TNBuilt 1978 · S/N 354-78N271APatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2002 · S/N 905-2002N271MAEarthbound Aviation Group LLC · Wilmington, DEBuilt 2003 · S/N 475-2003N2721EMasters Hazel A · Albany, GABuilt 1946 · S/N 7AC-6301N2722EMurphy Christopher K · Prescott, AZBuilt 1946 · S/N 7AC-6302N2725EAndrews Ryan K · Fort Walton Beach, FLS/N 7AC-6306N2725ZGeorge Ladelle L · Ashley, NDS/N 1231-78N2727GTetrad Corp DBA · Lusk, WYBuilt 1967 · S/N 10N272ACFlying Radish LLC · Vineyard Haven, MABuilt 1998 · S/N 1253-98N272SGLehner Raymond A Jr · North Fort Myers, FLBuilt 2004 · S/N 969-2004N2731EKolar Kenward F · Brazoria, TXBuilt 1946 · S/N 7AC-6312N2733EBlakeman Charles W Jr · Ironton, OHBuilt 1946 · S/N 7AC-6314N2734ECrouch Jon N II · Lake Waukomis, MOS/N 7AC-6315N2735ZSoucy Gary J · Brewer, MEBuilt 1978 · S/N 1232-78N2736ENicholls Paul R · Lowell, MIBuilt 1946 · S/N 7AC-6317
Back to AD 2000-25-02 R1