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.

N86086Beer Daniel R · Hudson, WIBuilt 1946 · S/N 11AC-510N86089Reid Michael J · Fort Towson, OKBuilt 1946 · S/N 11AC-511N8608VBenter Neil W · Ambrose, NDBuilt 1974 · S/N 154-75N86090Hurlbert Michael L · Wasilla, AKBuilt 1946 · S/N 11AC-513N86096Delaney James E Trustee · Rossmoor, CABuilt 1946 · S/N 11AC-520N8609VRegistration Pending · Frontenac, MNRegistration pendingBuilt 1974 · S/N 1083-75N86112Brick Harold P · Pomerene, AZBuilt 1946 · S/N 11AC-540N86114Bills Ricky E · Canandaigua, NYBuilt 1946 · S/N 11AC-542N8611VAlbright Harold R · Dubois, WYS/N 155-75N86120Resler Tyler L · Enid, OKBuilt 1946 · S/N 11AC-551N86122Ramirez Kyle T · Chicago, ILBuilt 1946 · S/N 11AC-549N86125Denniston John A · Albion, NYBuilt 1946 · S/N 11AC-538N86126Fisher Douglas W · Holton, KSBuilt 1946 · S/N 11AC-556N86131Crisler Jacob H · Alexandria, VAS/N 11AC-559N86133Rousseau Chase · Amarillo, TXBuilt 1946 · S/N 11AC-561N86135Brown Morris J · Mc Alpin, FLBuilt 1946 · S/N 11AC-562N86136Laverty Russell H · Jones, OKBuilt 1946 · S/N 11AC-563N8613VBoley Trevor T · Palmer, AKS/N 804-75N86140Van Horn Eric T · Linton, INBuilt 1946 · S/N 11AC-564N86146Wiese Andrew T · Gibsonburg, OHBuilt 1946 · S/N 11AC-576N86149Morison Janet Z · Ridgeway, WIBuilt 1946 · S/N 11AC-579N86152Bills Ricky E · Canandaigua, NYBuilt 1946 · S/N 11AC-583N86153Legion Airs Inc · Cliffside Park, NJRevoked, canceledBuilt 1946 · S/N 11AC582N86154Wood James A · Madera, CABuilt 1946 · S/N 11AC-584N86156Mulvania Rodney A · Linn, MOS/N 11AC-586N86158Hixssen Michael L · Anchorage, AKBuilt 1946 · S/N 11AC-587N8615VCitabria N8615v LLC · Westminster, COBuilt 1975 · S/N 504-75N86161Goatley John Edward · Springfield, KYBuilt 1946 · S/N 11AC-590N86165Kiefer Kenneth K · Fort Collins, CORevoked, canceledBuilt 1946 · S/N 11AC594N86166Lesmeister Joseph P · Santa Maria, CABuilt 1946 · S/N 11AC-595N8616VPittman Michael · Goodridge, MNS/N 808-75N86171Townsend Mark · San Jose, CAS/N 11AC-600N86174Thomas Roy J · Tucson, AZBuilt 1946 · S/N 11AC-603N86175Kobberdahl Marcel A · Deerwood, MNS/N 11AC-604N86176Bragg Paul L Jr · West Richland, WABuilt 1946 · S/N 11AC-605N86180Vintage Props LLC · Iowa City, IABuilt 1946 · S/N 11AC-609N86181Neel Bradley H · Lakeland, FLBuilt 1946 · S/N 11AC-611N86185Cimprich Joseph P · Camden, OHBuilt 1946 · S/N 11AC-615N86186Peters Raymond L · Bayfield, WIBuilt 1946 · S/N 11AC-617N86189Blackwell Mark E · Crowley, TXBuilt 1946 · S/N 11AC-620N86193Parks Reuben · Webster, SDBuilt 1946 · S/N 11AC-623N86195Stangl Royce M · Coon Rapids, IABuilt 1946 · S/N 11AC-625N86196Pippert Jim · Dysart, IABuilt 1946 · S/N 11AC-626N8619VPlane Folks LLC · Tucson, AZBuilt 1975 · S/N 809-75N861ACGuglietta Glenn W · Payson, AZBuilt 2000 · S/N 861-2000N861PMFlying Luvbug LLC · Grafton, WIS/N 1469-2014N86203Jones Donald T Jr · Barrigada, GUBuilt 1946 · S/N 11AC-8N86207Godlewski John A · Ormond Beach, FLBuilt 1946 · S/N 11AC-12-1N86213Peterson Earl P · Fort Atkinson, WIBuilt 1946 · S/N 11AC-17N86217Lukes Landing Inc · Hernando, MSBuilt 1946 · S/N 11AC-21
Back to AD 2000-25-02 R1