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.

N82427Griffith Arthur Clark · Chattanooga, TNBuilt 1946 · S/N 7AC-1060N82433Delong Erika D · Forest Lake, MNBuilt 1946 · S/N 7AC-1066N82434Rounds Bonnie L · Zebulon, GAS/N 7AC-1067N82439Weigel John C · Natick, MABuilt 1946 · S/N 7AC-1072N82440Oliver Elizabeth L · Arlington, GAS/N 7AC-1073N82444Biggs Bill · Temple, TXBuilt 1946 · S/N 7AC-1077N82447Erbey Jacob G · Hudson, WIBuilt 1946 · S/N 7AC-1080N82458Barr Bruce A · Lander, WYS/N 7AC-1091N82462Malone Grady I · Loudon, TNBuilt 1946 · S/N 7AC-1095N82463Gibson Romelle · Aberdeen, MSS/N 7AC1096N82466Hrutkay Charles S · Scenery Hill, PABuilt 1946 · S/N 7AC-1099N82468Hemphill Holdings LLC · Hemphill, TXBuilt 1946 · S/N 7AC-1101N82472Douglas Billy Ray · Brookston, TXBuilt 1946 · S/N 7AC-1108N82478Salisbury Thomas · Coeymans Hollow, NYBuilt 1946 · S/N 7AC-1114N82480Flugzeug LLC · Hanover, INBuilt 1946 · S/N 7AC-1117N82484Grow David A · Gloucester Point, VABuilt 1946 · S/N 7AC-1121N82485Strom Kerry · Portal, NDBuilt 1946 · S/N 7AC-1122N82489Behling James E · Cumberland, WIBuilt 1946 · S/N 7AC-1126N82490Martin Nathaniel W · Wasilla, AKFirst renewal noticeS/N 7AC-1127N82496Mako Investments Lc · Lafayette, LABuilt 1946 · S/N 7AC-1133N82498Maedgen William L · Salado, TXBuilt 1946 · S/N 7AC-1135N824SGAudenaert William N · Madison, ALBuilt 2009 · S/N 1082-2009N82501Feaster Christopher D · Richmond, INBuilt 1946 · S/N 7AC-1138N82503Church David A · Schnecksville, PABuilt 1946 · S/N 7AC-1140N82506Church Sammie H · Statesville, NCBuilt 1946 · S/N 7AC-1143N82510Swift Izak H · Fargo, NDBuilt 1946 · S/N 7AC-1147N82512Reed Charles H · Shelbyville, KYBuilt 1946 · S/N 7AC-1149N82515Pangelinan Regina Mafnas · Dublin, CABuilt 1946 · S/N 7AC-1152N82519Ross Elizabeth K · Schenectady, NYBuilt 1946 · S/N 7AC-1156N825225 Pm Inc · Nampa, IDBuilt 1946 · S/N 7AC-1159N82523Hardy John R · Wasilla, AKBuilt 1946 · S/N 7AC-1160N82529Champ Aero LLC · Louisville, KYBuilt 1946 · S/N 7AC1166N82538Adkins Dwain L · Sycamore, ILBuilt 1946 · S/N 7AC-1175N82540Valburg Lonnie H · Holton, KSBuilt 1959 · S/N 7AC-1177N82541Tranby Wayne A · Fargo, NDBuilt 1946 · S/N 7AC-1178N82543Janes Brenda Trustee · Shepherdsville, KYBuilt 1946 · S/N 7AC-1180N82546Veillon Joseph B · Alexandria, LABuilt 1946 · S/N 7AC-1183N82548Registration Pending · Milwaukee, WIRegistration pendingBuilt 1946 · S/N 7AC-1185N82551Brumfiel Joshua A · Hebron, KYS/N 7AC-1188N82558Leedom David L · Caney, OKBuilt 1946 · S/N 7AC-1195N82559Sifsof Victor G · Dillingham, AKS/N 7AC-1196N82560Reynolds William J · Griffin, GABuilt 1946 · S/N 7AC-1197N82564Davis Richard · Reno, NVBuilt 1946 · S/N 7AC-1201N82567Dagnon Paul A · Saint Paul, MNBuilt 1946 · S/N 7AC-1204N82569Rinker Kraig G · Winlock, WABuilt 1946 · S/N 7AC-1206N82571Glastar LLC · Greenwood, MNBuilt 1946 · S/N 7AC-1208N82572Debt Flying LLC · Holland, MIBuilt 1946 · S/N 7AC-1209N82573Powell Michael D · Sealy, TXBuilt 1946 · S/N 7AC-1210N82574Wendland Kenneth N · Big Timber, MTBuilt 1946 · S/N 7AC-1211N82576Gainor Mark C · Milnor, NDBuilt 1946 · S/N 7AC-1213
Back to AD 2000-25-02 R1