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.

N81732Mccurdy Robert L · Valley Head, ALBuilt 1945 · S/N 7AC-353N81735Davis Christopher V · Green Forest, ARBuilt 1946 · S/N 7AC-356N81738Seidner Neil W · Box Elder, SDBuilt 1945 · S/N 7AC-359N81742Martin Joseph L · Pike Road, ALBuilt 1946 · S/N 7AC-363N81747Kaba Robert D · Pace, FLBuilt 1945 · S/N 7AC-368N81755Schrier Robert E · Deland, FLBuilt 1945 · S/N 7AC-376N81757Culver Robert J · Frankston, TXBuilt 1945 · S/N 7AC-378N81758Cox Dennis L · Greenville, OHBuilt 1945 · S/N 7AC-379N81759Myers Nicholas E · Leipsic, OHBuilt 1945 · S/N 7AC-380N81760Reed Gretchen M Trustee · Madison, OHBuilt 1945 · S/N 7AC-381N81761Macveigh Craig A · New Carlisle, OHS/N 7AC-382N81777Sparks James D · Glennallen, AKBuilt 1945 · S/N 7AC-400N81780Milstein Jakob · Boulder, COBuilt 1945 · S/N 7AC-403N81782Camacho Hector F · Andover, KSBuilt 1945 · S/N 7AC-405N81787Mikkelson William M · West Bend, WIBuilt 1945 · S/N 7AC-410N81789Franks David · Rices Landing, PABuilt 1945 · S/N 7AC-412N8178ASkowbo Rock G · Palatka, FLBuilt 1945 · S/N 7AC-407N81790Statkus Stephen P · Cincinnati, OHBuilt 1945 · S/N 7AC-413N81792Doughty Robert W · Casa Grande, AZBuilt 1946 · S/N 7AC-415N817DCEverwind Aviation LLC · Kalispell, MTBuilt 1948 · S/N 7DC81N817DHMastrangelo John A · Phoenix, AZBuilt 2003 · S/N 1341-2003N81803Champ 81803 LLC · Clinton, MOBuilt 1945 · S/N 7AC-426N81804Hicks Richard T · Statesville, NCBuilt 1945 · S/N 7AC-427N81810Vintage Combat Aircraft LLC · Wilmington, DEBuilt 1945 · S/N 7AC-433N81813Pippenger Jason S · Albion, INBuilt 1945 · S/N 7AC-436N81823Mcgill Melissa M · Joliet, MTBuilt 1946 · S/N 7AC-446N81824Sell Scott F · Moody, TXBuilt 1945 · S/N 7AC-447N81825King Daniel A · Midland, VABuilt 1945 · S/N 7AC-448N81829Small Mark B · Walla Walla, WABuilt 1945 · S/N 7AC-452N81834Kurtz Garold D · Mound City, MOS/N 7AC457N81836North Aero · Bozeman, MTBuilt 1946 · S/N 7AC-459N81840Graves Jed · Proctor, MNS/N 7AC-463N81841Hayes Victor R · Columbus, MIBuilt 1946 · S/N 7AC-464N81855Pegasus Flyers Inc · Saylorsburg, PABuilt 1946 · S/N 7AC-478N81856Hendrickson Todd R · Woodstock, ILS/N 7AC-479N81867Far North Aviation LLC · Fargo, NDBuilt 1946 · S/N 7AC-490N81870Desnoyer George M · Merrill, WIBuilt 1946 · S/N 7AC-493N81875Suits Thomas L · Tulsa, OKS/N 7AC-498N81878Mcclave Wilkes III · Hanover, NHBuilt 1946 · S/N 7AC-501N81881Quayle John P · Pleasanton, CABuilt 1946 · S/N 7AC-504N81886Hartfield Storage LLC · Mayville, NYBuilt 1946 · S/N 7AC-509N81887Mccleary William D · Montoursville, PABuilt 1946 · S/N 7AC-510N81889Custer Nathan James · Friedens, PABuilt 1946 · S/N 7AC-512N818WDWhiskey Bravo II LLC · Newton, KSBuilt 2000 · S/N 856-2000N81900Burns Joe D · Scottsville, NYBuilt 1946 · S/N 7AC-523N81903Pumphrey Ronald W · Houston, MSBuilt 1946 · S/N 7AC-526N81910Leaders Bob · Clear Lake, MNS/N 7AC-533N81913Ardizone Robert G · Mckinney, TXBuilt 1946 · S/N 7AC-536N81920Crooke Michael J · Charlotte, NCS/N 7AC-545N81924Potkin Mark R · Chico, CABuilt 1946 · S/N 7AC-549
Back to AD 2000-25-02 R1