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.

N84779Harris Todd W · Hamler, OHS/N 7AC-3500N84781Casey James Joseph · Glenview, ILBuilt 1946 · S/N 7AC-3492N84783Staley Kelly J · Olympia, WABuilt 1946 · S/N 7AC-3496N84787Bowers James H · Broadus, MTBuilt 1946 · S/N 7AC-3504N84788Sanders Matthew S · Towner, COS/N 7AC-3505N84792Airplane Services Inc · Jay, FLBuilt 1946 · S/N 7AC-3506N84795Maxson Russell A · Dubois, WYBuilt 1946 · S/N 7AC-3513N84798Floyd James K · Gainesville, TXS/N 7AC-3508N847DLHoppe Joel A · Mankato, MNS/N 114N84800Massman Darrel F · Ogdensburg, WIBuilt 1946 · S/N 7AC-3521N8480442077 LLC · Geneseo, NYBuilt 1946 · S/N 7AC-3518N84806Westrum Durl T · Norwalk, IABuilt 1946 · S/N 7AC3517N84821Noyes Stephen · Newbury, MABuilt 1946 · S/N 7AC-3538N84830Kingdom Air Corps · Sutton, AKBuilt 1946 · S/N 7AC-3546N84831Seaman Daniel G · Eastover, NCBuilt 1946 · S/N 7AC-3547N84837Gutowski Bogdan · New London, CTBuilt 1946 · S/N 7AC-3553N84842Snohomish Flying Svc Inc · Snohomish, WABuilt 1946 · S/N 7AC-3560N84844Muma Linda E · Auburn, WABuilt 1946 · S/N 7AC-3563N84851Montedonico Robert A · Trenton, NCBuilt 1946 · S/N 7AC-3570N84856Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1946 · S/N 7AC-3575N84858Levorsen Aaron D · Elgin, NDBuilt 1946 · S/N 7AC-3577N84864Tjelle Dennis M · Dwight, ILBuilt 1946 · S/N 7AC-3583N84866Ventura David C · Wellington, FLBuilt 1946 · S/N 7AC3585N84868Ch Aerospace LLC · Manvel, TXBuilt 1958 · S/N 7AC-3587N84873Lighthouse Thomas G · San Jose, CABuilt 1946 · S/N 7AC-3592N84874Dodderer Kenneth W · Clovis, CAS/N 7AC-3593N84876Schuck Daniel W · Redwood City, CAS/N 7AC-3595N84880Livingston Patrick A · Pratt, KSBuilt 1946 · S/N 7AC-3599N84884Hoffer William T · Orr, MNS/N 7AC-3603N84889Kjelsrud Gary L · Great Falls, MTS/N 7AC-3608N84895Knaub Samuel S · York, PAS/N 7AC-3614N848ACOgan Michael J · Pierre, SDBuilt 2024 · S/N 643-2024N848XAnderson Charles E · Fort Worth, TXBuilt 1959 · S/N 7GC58N849Hoover Michael B · Ridgeland, WIS/N 7BCM-63N84900Oakes John D · Jacksonville, ILBuilt 1946 · S/N 7AC-3619N84903Sipes Greg A · North Pole, AKS/N 7AC3622N84908Mcdonough Martin B · Mount Carroll, ILBuilt 1946 · S/N 7AC-3627N84909Bartholomew William T · Louisburg, NCBuilt 1946 · S/N 7AC-3628N84911Reichard David G · Dayton, OHBuilt 1946 · S/N 7AC-3630N84913Clor Nicholas K · Clinton Township, MIBuilt 1946 · S/N 7AC-3635N84915Beckhoff Allen C · Greybull, WYS/N 7AC-3637N84917Dodd Dennis P · Pittsfield, ILBuilt 1946 · S/N 7AC-3639N84919Walker Bobbie R · Denver, COBuilt 1946 · S/N 7AC-3641N84921Wieman Dianne L · Marion, TXFirst renewal noticeS/N 7AC-3643N84922Ashbaugh Raymond · Alvarado, TXBuilt 1946 · S/N 7AC-3644N84923Hogan Michael J · Bonita Springs, FLFirst renewal noticeBuilt 1946 · S/N 7AC-3645N84931Phillips Jack A · Fairfax, SCBuilt 1946 · S/N 7AC-3653N84935Gullickson William · Alexandria, VABuilt 1946 · S/N 7AC-3657N84938Shearer Don E · Madrid, IABuilt 1947 · S/N 7AC-3660N84939Skinner Casey · North Little Rock, ARBuilt 1946 · S/N 7AC-3661
Back to AD 2000-25-02 R1