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.

N9635SPake Bradley P · Felton, MNBuilt 1966 · S/N 374N9636ETaylor Sophia · Urbana, OHBuilt 1946 · S/N 11AC-1277N963TTAmerican Capital Aviation LLC · Kalispell, MTBuilt 2020 · S/N 1189-2020N9640SFrancis James E · King City, CABuilt 1966 · S/N 6N9641ELoudon Philip G · Fairbanks, AKBuilt 1946 · S/N 11AC-1280N9642STaylor Jonathan K II · Granbury, TXBuilt 1966 · S/N 3N9643STurner Nathan D · Nenana, AKFirst renewal noticeBuilt 1966 · S/N 20N9644SClausen Robert G · Argyle, MNS/N 391N9645EWalsemann Brent M · Carthage, NYBuilt 1946 · S/N 11AC-1286N9646EEmbree Walter G · Harrisonburg, VABuilt 1946 · S/N 11AC-1285N9647EEvans Mark O · Dover, ARBuilt 1946 · S/N 11AC-1288N9647SGarrett Flying Service · Danbury, TXS/N 394N9649SHowell Alice R · Bainbridge, GAS/N 396N964SEGray Luke Francis · San Bruno, CABuilt 2004 · S/N 964-2004N9650EWalton John F · Hesperia, CABuilt 1954 · S/N 11AC-1290N9651EMacveigh Craig A · New Carlisle, OHS/N 1294N9653SNy Barnstormers LLC · Maine, NYBuilt 1966 · S/N 314N9654EAlbij3 LLC · Milton, FLS/N 11AC1299N9655HHetz Richard A · Fairview, PABuilt 1956 · S/N 7BCM-407N9657SWhite Wayne A · Scenic, SDBuilt 1966 · S/N 26N9658EPrivitt Bret J · Fort Worth, TXBuilt 1946 · S/N 11AC-1303N9659ERegistered aircraftN-number assigned, not yet registeredS/N 11AC-1302N9659SRandall Timothy J · Skidmore, MOBuilt 1966 · S/N 69N965JRichardson Cotton Inc · Wilmington, DEBuilt 2025 · S/N 1490-2025N965MAFirst Aero Group LLC · Wilmington, DEBuilt 2004 · S/N 967-2004N9660EHoffman Allen D Sr · Cheboygan, MIBuilt 1946 · S/N 11AC-1297N9660SHughes Alan J · Edison, OHBuilt 1966 · S/N 245N9661ECard Donald J · Dallas, TXBuilt 1946 · S/N 11AC-1304N9662EEnnenga Robert B · Grand Haven, MIBuilt 1946 · S/N 11AC-1305N9665EFurnas Jerry W · San Diego, CABuilt 1946 · S/N 11AC-1308N9665SDendy Dwight E · Caledonia, ILBuilt 1966 · S/N 251N9667SJones Larry C · Clovis, NMBuilt 1966 · S/N 27N9668SPalmer Kit A · Redlands, CABuilt 1966 · S/N 85N966BCHutchins David E · Squaw Lake, MNBuilt 2016 · S/N 574-2015N9670SDowns Steve M · Camden, TNBuilt 1966 · S/N 397N9675EJersey George H · Cold Brook, NYBuilt 1946 · S/N 11AC-1318N9677EBoyd Jeff · Justin, TXBuilt 1946 · S/N 11AC-1320N9679SBistline John A · Cedar City, UTS/N 273N967CMDonaldson Charles A · Clay City, KYBuilt 1972 · S/N 833-72N9681EDaniel Stephen Clay · Decatur, GABuilt 1946 · S/N 11AC-1324N9682SRoethlisberger John · Beaver Falls, PABuilt 1966 · S/N 469N9684EArcher William P · Wapato, WABuilt 1946 · S/N 11AC-1329N9684SGt Aviation LLC · Kalispell, MTBuilt 1966 · S/N 90N9685SSymond Clarence B · Eastover, NCBuilt 1966 · S/N 551N9686SAirpro Aviation LLC · Cross Lake Twp, MEBuilt 1966 · S/N 41N9687SHayes Brian · Vero Beach, FLBuilt 1966 · S/N 96N9688SFay Daniel J · Houston, TXS/N 80N968BCAmerican Champion Aircraft Corp · Rochester, WIBuilt 2026 · S/N 1493-2026N9690SAck & Co LLC · East Helena, MTBuilt 1966 · S/N 418N9692ESeever James J · Holmen, WIBuilt 1946 · S/N 11AC-1323
Back to AD 2000-25-02 R1