OpenAirDocs.org
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.

N291RAParsons Aviation Inc · Wilmington, DEBuilt 2003 · S/N 445-2003N291SAWoods Aviation LLC · Kearney, NEBuilt 2005 · S/N 982-2005N291TPSparebanc LLC · Appleton, MNS/N 889-2001N2922EWilson Nathan Jon · Royal City, WABuilt 1946 · S/N 7AC-6505N2923EUdovich Derek D · Gheen, MNS/N 7AC-6506N2923ZAnkole Watusi Cattle Company LLC · Leesburg, FLBuilt 1978 · S/N 1244-78N2929EPetro Jerry R · Williamsburg, VABuilt 1946 · S/N 7AC-6512N292ACPatten Dale G · Lapeer, MIS/N 1206-95N292BCJjb Enterprises LLC · Saint Anthony, IDBuilt 2007 · S/N 497-2007N2935EPaulson David E · Warroad, MNS/N 7AC-6518N293ACWeaver Roger D · Sarasota, FLBuilt 1995 · S/N 1355-95N293MAKrogman James D · Danube, MNBuilt 2004 · S/N 1377-2004N293SABowe Joseph E DBA · Ocklawaha, FLS/N 1007-2007N2940GDakota Air Spray LLC · Huron, SDBuilt 1967 · S/N 69N2941EDilks Alexander J · New Castle, DEBuilt 1946 · S/N 7AC-6524N2942EMccullough Richard G · Merrill, WIBuilt 1946 · S/N 7AC-6525N2943GVan Ness James A · Buckley, WABuilt 1968 · S/N 517N2944EGeyer Mary A · Metamora, MIBuilt 1946 · S/N 7AC-6533N2944ZCorcoran Brian L · Hampstead, MDS/N 378-78N2945EHam Alan Darrell · Goldsboro, NCBuilt 1946 · S/N 7AC-6531N2948EWings & Wine Inc · Euclid, OHBuilt 1946 · S/N 7AC-6534N2950ECarboni Christian J · Hennepin, ILBuilt 1946 · S/N 7AC-6536N2951GFletcher Flying Service 419 LLC · Labelle, FLBuilt 1967 · S/N 62N2953GNolde Norman L · Fayetteville, GABuilt 1967 · S/N 586N2955ERich Jacob T · Eatonville, WAS/N 6542N2956ZAm Flite Inc · Valley, NEBuilt 1978 · S/N 1245-78N2957EHarmon Anthony Wayne · Easley, SCBuilt 1946 · S/N 7AC-6544N2959EWillson Gary N · Duvall, WAS/N 7AC-6545N295ACFanjoy James Michael · Nehalem, ORBuilt 1995 · S/N 756-95N2960EStewarts Aircraft Service · Waynesville, OHBuilt 1946 · S/N 7AC-6546N2962ZMull Jason E · Chester, NYBuilt 1978 · S/N 379-78N2967GMcallister A J Trustee · Buford, GABuilt 1967 · S/N 488N296ACNewton Thomas L Jr · Fredericksburg, VAS/N 770-96N2971EGreen Samuel · Clifton Park, NYBuilt 1946 · S/N 7AC-6557N2971WMurray Michael R · Centerville, TXS/N 11BC-129N2972EWarner Robert · Mckinney, TXBuilt 1946 · S/N 7AC-6558N2973EWhiting Stephen D · Poway, CABuilt 1946 · S/N 7AC-6559N2973ZLandrum Erik G · Austin, TXBuilt 1978 · S/N 359-78N29742Payne David T · Monticello, ILBuilt 1980 · S/N 618-80N2974XAnderson Keith · Covington, TNS/N 1346-80N2975QWorker Timothy M · Fairbanks, AKBuilt 1980 · S/N 346-80N2975WFoldesi Dennis · Merritt Island, FLBuilt 1980 · S/N 620-80N29762Davis Evan A · Fairbanks, AKS/N 352-80N29763Wilson Woodie J · Collins, MSS/N 1208-80N2976CGarrett John G · Conway, WABuilt 1980 · S/N 1204-80N2976XPechota Steven F · Palmer, AKBuilt 1980 · S/N 1206-80N2976ZEvans James · Millbrae, CAS/N 380-78N29772Sublett John L · Georgetown, TXBuilt 1980 · S/N 1210-80N2977ESeine Michael P · Wasilla, AKFirst renewal noticeBuilt 1946 · S/N 7AC-6563N2977GFive Aviators LLC · Austin, TXBuilt 1967 · S/N 293
Back to AD 2000-25-02 R1