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.

N82578Moser Calvin · Milbank, SDS/N 7AC-1215N82579Weston Lee R · Lilliwaup, WABuilt 1946 · S/N 7AC-1216N82586Poklar Norman A · Mount Orab, OHS/N 7AC-1223N82589George James C · Lenoir, NCBuilt 1946 · S/N 7AC-1226N82590Hubble Harley J · Gallipolis, OHBuilt 1946 · S/N 7AC-1227N82594Four C Sons Inc · Kersey, COBuilt 1946 · S/N 7AC-1231N82595Dragons Tail LLC · Midland, MIBuilt 1946 · S/N 7AC-1232N82599Hayden Sarah Alison · Owensboro, KYS/N 7AC-1236N825DSBreckner Robert J · Burnsville, MNBuilt 2014 · S/N 1471-2014N825JSSchumann John · Vero Beach, FLBuilt 2015 · S/N 1307-2015N825MCC & M Aviation LLC · White Lake, MIBuilt 1976 · S/N 1154-76N825RHNorthcutt Randy · Alpine, WYBuilt 2013 · S/N 559-2013N82602Verzwyvelt Andrew W · Alexandria, LABuilt 1946 · S/N 7AC-1239N82603Spain Benjamin D · Opelika, ALBuilt 1946 · S/N 7AC-1240N82609Screws Harlan D · Vernon, TXBuilt 1946 · S/N 7AC-1249N82610Elliott John O · Lathrop, MOBuilt 1946 · S/N 7AC-1250N82611Brehmer Paul M · Eagle River, AKBuilt 1946 · S/N 7AC-1251N82615Gebbert Larrell D · Victoria, TXBuilt 1946 · S/N 7AC-1255N82620Debonair Consulting Inc · Wilmington, DEBuilt 1946 · S/N 7AC-1260N82621Weeks Nancy H · Abilene, TXBuilt 1946 · S/N 7AC-1261N82624Wagner Timothy D · Wheelersburg, OHBuilt 1946 · S/N 7AC-1264N82625Weisberg Perry A · Minot, NDBuilt 1946 · S/N 7AC-1265N82626Rinker Michael D · Martin, TNBuilt 1946 · S/N 7AC-1266N82630Patridge Rodney · Big Spring, TXS/N 7AC-1272N82637Snow Carol A · Rattan, OKBuilt 1946 · S/N 7AC-1280N82639Cloud Joe E · Kenai, AKBuilt 1946 · S/N 7AC-1281N82643Hendrickson Gary A · Chico, CAS/N 7AC-1285N82649Napier Graydon R · Linton, INBuilt 1946 · S/N 7AC1291N82650Mjj Aircraft Inc · Wilmington, DES/N 7AC-1292N82653Riggin Flight Service Inc · Madison, SDBuilt 1946 · S/N 7AC-1295N82655Boatright Kyle W · Marietta, GABuilt 1946 · S/N 7AC-1294N82657Irwin Terry H · Gordonille, MOBuilt 1946 · S/N 7AC-1299N82658Kimbrough Dan M · Mc Minnville, TNBuilt 1946 · S/N 7AC-1303N82660Stalls Matthew B · Denver, COBuilt 1946 · S/N 7AC-1301N82662Fisher Douglas W · Holton, KSBuilt 1946 · S/N 7AC-1302N82666Woode Denico · Fort Riley, KSBuilt 1946 · S/N 7AC-1306N82672Duerkop Burnell · Rockland, WIBuilt 1946 · S/N 7AC-1314N82677Walker Jeffrey P · Warwick, NYBuilt 1946 · S/N 7AC-1318N82680Hoffman Edward C · Tarpon Springs, FLBuilt 1946 · S/N 7AC-1322N82681Herold Dana R · Mcminnville, ORBuilt 1946 · S/N 7AC-1323N82682Long Jory J · Lake Ozark, MOBuilt 1970 · S/N 772-70N82686Boucher Kenneth G · Scotland, CTBuilt 1955 · S/N 7AC-1332N82693Gould Allison L · Antrim, NHBuilt 1946 · S/N 7AC-1338N82694Henderson Norman L · Bowling Green, MOS/N 7AC-1336N82699Koering Henry Marvin · Fort Ripley, MNBuilt 1946 · S/N 7AC-1337N82701Woldow Fredric A · Morton, ILBuilt 1946 · S/N 7AC-1345N82703Duffy William J · Cincinnati, OHS/N 7AC-1347N82704Ferry Eugene M · Lander, WYBuilt 1946 · S/N 7AC-1352N82705Couvillion Rickey J · Lafayette, LAS/N 7AC-1351N82707Specht Beth A · Sherwood, WIBuilt 1946 · S/N 7AC-1355
Back to AD 2000-25-02 R1