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.

N9571SShetterly Maxine M · Livingston, TXBuilt 1965 · S/N 7ECA-379N9572EJolliff Travis · El Paso, TXBuilt 1946 · S/N 11AC-1209N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66N9574EKnie Dean H · Aberdeen, SDBuilt 1946 · S/N 11AC-1211N9574SKrejchik Daniel J · Portage, WIBuilt 1965 · S/N 14N9575EPoore Randall J · Savage, MNBuilt 1946 · S/N 11AC-1212N9576EGreen Castle Aero Club Ltd · Oxford, IABuilt 1946 · S/N 11AC-1213N9577SConner Harvey E · Coahoma, TXS/N 368N9578SSlone Donald L · Holden, MOS/N 320N9580SSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1965 · S/N 30N9581ESchelm Donald A · Omaha, NEBuilt 1946 · S/N 11AC-1217N9581SKing John D · Midland, VABuilt 1966 · S/N 192N9584SWalker James M Jr · Springfield, KYBuilt 1965 · S/N 334N9586EFabian Brian L · Corcoran, MNBuilt 1946 · S/N 11AC-1228N9587SReberg Timothy J · Bayport, MNBuilt 1965 · S/N 5N9589SJones Daniel S · Panama City Beach, FLBuilt 1965 · S/N 9N9592EDavis Richard · Romney, WVBuilt 1946 · S/N 11AC-1233N9593EN82 Sport Flying LLC · Wurtsboro, NYBuilt 1946 · S/N 11AC-1224N9593SStoffer Aviation LLC · Marion, INS/N 35N9594SRuiz Santiago · Jupiter, FLBuilt 1965 · S/N 41N9595ERegistration Pending · Roosevelt, MNRegistration pendingS/N 11AC-1235N9598ETomlin R H · Burleson, TXBuilt 1946 · S/N 11AC-1238N959PDMilligan Thomas A · Dana, INBuilt 2002 · S/N 1336-2002N95KPPainter Kenneth Lee · Luray, VABuilt 1973 · S/N 119-73N95NHOberlander Justin D · Colton, ORBuilt 1974 · S/N 105-74N95PBExtreme Air LLC · Santa Barbara, CABuilt 2024 · S/N 1213-2024N95PUTrustees Of Purdue University · West Lafayette, INS/N 1037-2007N9600SHargrove Tom R · Coffeyville, KSBuilt 1966 · S/N 2N9602SKrepfl Martin J · Colorado Springs, COBuilt 1965 · S/N 50N9604EWatson Bobby M · Hoxie, ARBuilt 1946 · S/N 11AC-1244N9604SFmco Promotions Inc · North Little Rock, ARS/N 25N9606SMix Timothy R · Hubbard, ORS/N 43N9608EJackson Lee R · Baldwinsville, NYBuilt 1946 · S/N 11AC-1246N960RMCag International Inc DBA · Longmont, COBuilt 2000 · S/N 852-99N9610SLake A Randy · San Diego, CABuilt 1966 · S/N 265N9614SFlatonia Veterinary Clinic Inc · Flatonia, TXBuilt 1966 · S/N 46N9615ECohutta Aviators LLC · Milton, FLBuilt 1946 · S/N 11AC-1256N9617SAnderson David R · Hastings, MNBuilt 1966 · S/N 366N9618SBradley Christopher · Juneau, AKBuilt 1965 · S/N 385N9619SCulp Barney L Jr · Emerald Isle, NCBuilt 1965 · S/N 13N9621ELootens Charles W · Mansfield, OHBuilt 1946 · S/N 11AC1259N9622SRezek James P · Two Rivers, WIBuilt 1946 · S/N 11AC1261N9625EStahl Thomas E · Chula Vista, CAS/N 11AC-1264N9625SYoung Robert A Jr · Cass, WVBuilt 1966 · S/N 57N9627EPasco Gary R · Brockport, NYBuilt 1946 · S/N 11AC-1268N9629EHenkelmann David H · Janesville, WIBuilt 1946 · S/N 11AC-1267N9629SSchick Jason · Faulkton, SDS/N 59N962ACMccrary Ryan Michael · Greensburg, INBuilt 2001 · S/N 877-2000N9631SFreedom Aviation Of America LLC · Newcastle, TXBuilt 1966 · S/N 39N9633EHartman Thomas · Peru, ILBuilt 1946 · S/N 11AC-1273
Back to AD 2000-25-02 R1