OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,560

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.

N202SGBassham Diane C · Ames, IAS/N 1015-2006N2033ERichardson Michael D · Charlotte, NCBuilt 1946 · S/N 7AC-5603N2034QHayes Robert L · La Porte, TXS/N 7AC-5771N2035ACilley Sherburn C · South Royalton, VTBuilt 1947 · S/N 7BCM-246N2035CMoore Allen R Trustee · Norman, OKBuilt 1946 · S/N 7AC5106N2036ACunningham David B · Hillsboro, ILBuilt 1947 · S/N 7BCM-248N2041AGregory Norbert L · Farmington, MNBuilt 1947 · S/N 7BCM-489N2042ANorman Royce K · La Feria, TXBuilt 1947 · S/N 7BCM-431N2043HMont Belvieu Materials Inc · Mont Belvieu, TXBuilt 1946 · S/N 7AC-4302N2044EHale Steven B · Bonham, TXBuilt 1946 · S/N 7AC-5614N2048EHamilton Donis B · Paragould, ARBuilt 1946 · S/N 7AC-5618N204ACBrookover James R · Hartville, OHS/N 434-2000N204RJFlying Hoosier Js LLC · Carmel, INBuilt 2004 · S/N 1375-2004N204SDOstern Mark Lynn · Rapid City, SDS/N 958-2004N2052EHarmon David S · Buxton, MES/N 7AC-5622N2053EFerwerda Beech LLC · Fremont, NHBuilt 1946 · S/N 7AC-5623N2057ECrabbe Walter Carter · Melfa, VABuilt 1946 · S/N 7AC-5627N205MAWarbird Adventures Inc · Ocoee, FLBuilt 1979 · S/N 530-79N2062ERoe Wade R · Tuscaloosa, ALBuilt 1946 · S/N 7AC-5632N2063EMerrill James D · Milford, VAS/N 7AC-5633N2064EPinsky Harold M · Ann Arbor, MIBuilt 1946 · S/N 7AC-5634N2069ENc2069e LLC · Deland, FLBuilt 1946 · S/N 7AC-5639N206GWOconnor Christopher G · New Haven, CTBuilt 1956 · S/N 528N2074EEberhart Daniel J · Fort Myers, FLBuilt 1946 · S/N 7AC-5644N2076EZerovich Karl · Cortland, OHBuilt 1946 · S/N 7AC-5646N2079ESchorsch Blake C · Denver, COS/N 7AC-5649N207EFlannery John J · Atkinson, NEBuilt 1946 · S/N 7AC-6509N207JJN207jj LLC · Mesa, AZBuilt 2020 · S/N 1183-2020N2081ERylie Aviation II LLC · Lake Forest, ILBuilt 1946 · S/N 7AC-5651N2082EGuess Gary L · Mechanicstown, OHBuilt 1946 · S/N 7AC-5652N2086APlanes Of Fame Air Museum · Chino, CABuilt 1947 · S/N 47-1258AN2088VMad Scientist Aviation LLC · Wilmington, DEBuilt 2002 · S/N 465-2002N2095ALawrence David D · Roanoke, VABuilt 1956 · S/N 7DC-329N2095ESummerlin Joe C · Richfield, NCS/N 7AC-5665N2096EFreeman Heritage Collection LLC · Kingsbury, TXBuilt 1946 · S/N 7AC-5666N2097EG&J Aviation Services Inc · Maryland Heights, MOBuilt 1946 · S/N 7AC-5667N2098EFritzinger Thomas · Maidens, VABuilt 1946 · S/N 7AC-5669N2099ETranum Joseph S III · Ruleville, MSS/N 7AC-5670N209JFStock James D · Deer Park, WABuilt 1967 · S/N 76N20SBBrillaud Stephen A · Germantown, TNBuilt 1976 · S/N 917-76N2103KKlatt Mathew · Waupaca, WIBuilt 1946 · S/N 7AC-609N2104EPioneer Flight Museum · Kingsbury, TXS/N 7AC5673N2109EChipman Jeff · Rising Sun, INBuilt 1946 · S/N 7AC-5679N210XDRafert Steven Alan · Gresham, NEBuilt 2025 · S/N 1228-2026N210XTAsherbranner Charles E · Yucaipa, CABuilt 2015 · S/N 1157-2015N2112ESingleton Steve L · Hale, MOBuilt 1946 · S/N 7AC-5682N2115EStewarts Aircraft Service Inc · Waynesville, OHBuilt 1946 · S/N 7AC-5686N2116EK Hyacinth Holdings LLC · North Swanzey, NHS/N 7AC2584N211WBBargatze Robert F · Three Forks, MTBuilt 1974 · S/N 491-75N2120EHammond Nathan K · Hustonville, KYS/N 7AC-5691
Back to AD 2000-25-02 R1