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.

N82252Adams Jimmy P · Statesboro, GAFirst renewal noticeBuilt 1946 · S/N 7AC-880N82258Heffley Todd E · Rhome, TXBuilt 1946 · S/N 7AC-886N82260Elkins Joseph D · Andersonville, TNBuilt 1946 · S/N 7AC-888N82263Howker John A · Louisville, KYBuilt 1946 · S/N 7AC-891N82265Pike Marsha L · Reno, NVBuilt 1946 · S/N 7AC-893N82269White James V Trustee · Wakonda, SDBuilt 1946 · S/N 7AC-897N82270Vega Abraham · Del Rio, TXBuilt 1946 · S/N 7AC-898N82272Wyatt G Whitlow · Wshngtn Ct Hs, OHBuilt 1946 · S/N 7AC-900N82278Koffel Jeffrey G · Republic, WABuilt 1946 · S/N 7AC-907N82282Reahard Jean F IV · Griffin, GABuilt 1946 · S/N 7AC-911N82286Registration Pending · Bullhead City, AZRegistration pendingBuilt 1946 · S/N 7AC-915N82292Miller Mark R · Hagerman, IDBuilt 1946 · S/N 7AC-921N82297Peter C Treichler · East Aurora, NYS/N 7AC-926N822MWPilie Louis J · Grand Island, NYBuilt 1975 · S/N 174-75N822TTRobinson Donald S · Underwood, NDS/N 351-72N822VAffection Above Aviation Inc · Yukon, OKBuilt 1978 · S/N 1281-79N82309Patterson Bill A · Paris, OHS/N 7AC-938N82312Pfau Michael G · Princeton, MNBuilt 1946 · S/N 7AC-941N82315Ordnung Michael J · Savannah, MOBuilt 1946 · S/N 7AC-944N82316Harter Mark S · Belleville, ILBuilt 1946 · S/N 7AC-946N82320Pritchett Flying Service LLC · Rolla, MOS/N 7AC-949N82321Ferriter John M · Waterville, NYS/N 7AC-950N82322Fisher Hoke L · Peachtree Corners, GABuilt 1946 · S/N 7AC-951N82335Smiley Neil G · Clover, VABuilt 1946 · S/N 7AC-964N8233AWeiblen Glenn P · Castroville, TXBuilt 1946 · S/N 7AC-3022N82342Sale Reported · Skaneateles, NYSale reportedBuilt 1946 · S/N 7AC-974N823545 Seconds Green Light LLC · Newark, DEBuilt 1946 · S/N 7AC-986N82355Jaderborg Eric E · Lonoke, ARBuilt 1946 · S/N 7AC-987N82357Bristow Matthew · Kent, WABuilt 1946 · S/N 7AC-989N82359Lumley John J Trustee · Delray Beach, FLS/N 7AC-990N82360Swager Joel · Ione, CAS/N 7AC-993N82361Sluder Gilbert T · Bellevue, IDBuilt 1946 · S/N 7AC-994N82374Vigdal Carl B · Fort Worth, TXS/N 7AC-1007N82379Reynolds James S · Okeechobee, FLBuilt 1946 · S/N 7AC-1012N82380Penner Carl F · Midway, UTS/N 7AC-1013N82386Chowning Alan B · Sullivan, INBuilt 1946 · S/N 7AC-1019N82390Feaster Christopher D · Richmond, INBuilt 1946 · S/N 7AC-1023N82393Willis Nelson W · Lebanon, TNS/N 7AC-1026N82395Alvarez Frank · Hartford, WIBuilt 1946 · S/N 7AC-1028N82403Blairtown Taildraggers Inc · Columbia, NJBuilt 1946 · S/N 7AC-1036N82406Fleischhauer Martin W · Tucson, AZBuilt 1946 · S/N 7AC-1040N82409Hanz Joseph L · Ford City, PAS/N 7AC-1043N82411James Robert L · Newton, MSBuilt 1946 · S/N 7AC-1045N82413Schutze Karen L · Ojai, CAFirst renewal noticeBuilt 1946 · S/N 7AC-1047N82414Arnold Keith · Fayetteville, ARBuilt 1946 · S/N 7AC-1048N82416Naca 130 LLC · Cameron Park, CAS/N 7AC-1050N82417Melodia Sean M · Cranberry Township, PABuilt 1946 · S/N 7AC-1039N82418Hollingsworth Gene R · Whitestown, INBuilt 1946 · S/N 7AC-1051N82421Ralls Gillis E · Evergreen, ALBuilt 1946 · S/N 7AC-1054N82426Bishman Myron L · Princeton, MNBuilt 1946 · S/N 7AC-1059
Back to AD 2000-25-02 R1