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.

N8581VObx Airplanes LLC · Manteo, NCBuilt 1975 · S/N 805-75N85821Wells Nicholas M · Holdrege, NEBuilt 1946 · S/N 11AC-221N85828Burgess Paul · Puyallup, WAS/N 11AC-246N85829Barwegen Terrence M · San Jose, CABuilt 1946 · S/N 11AC-239N8582VOcean Aerial Ads Inc · Ocean City, MDBuilt 1975 · S/N 144-75N8583Totorige Carson J · Glennallen, AKBuilt 1973 · S/N 916-73N85834National Machinery & Conveyor Inc · Marion, INBuilt 1946 · S/N 11AC-245N85835Huckins Cheryl D · Derby, KSBuilt 1946 · S/N 11AC-242N85839Tucker John E · Bow, WABuilt 1946 · S/N 11AC-248N8583VMorten John E DBA · Larimore, NDBuilt 1975 · S/N 145-75N85841Norlin Lary G · Indianola, IABuilt 1946 · S/N 11AC-210N85844Pitts Joseph · Avondale, PABuilt 1946 · S/N 11AC-251N85848Hoovair LLC · Little Rock, ARBuilt 1946 · S/N 11AC-281N85849Hayter Charles A · Gladstone, MOBuilt 1946 · S/N 11AC-285N85855Mason Steven K · Rolla, MOBuilt 1946 · S/N 11AC-288N85856Delaney Patrick James · Marion, TXBuilt 1946 · S/N 11AC-259N85862Benne Jonathan M · Wentzville, MOS/N 11AC-256N85865Schilling Johnathan M · Eugene, ORBuilt 1946 · S/N 11AC-266N85870Allen Scott L · Ogallala, NEBuilt 1946 · S/N 11AC-282N85871Marking Kevin J · Omaha, NEBuilt 1946 · S/N 11AC-261N85875Helms Christopher M · Durango, COBuilt 1946 · S/N 11AC-289N8587VCaprock Soaring Association · Littlefield, TXBuilt 1974 · S/N 146-75N85880Albertson James M · Westville, FLBuilt 1946 · S/N 11AC-301N85884Slay Brothers Adventures LLC · Kalispell, MTBuilt 1946 · S/N 11AC-300N85887Goertz Ronald L · Livingston, TXS/N 11AC-295N85888Hargrove Dwayne E · Shepherdsville, KYBuilt 1946 · S/N 11AC-293N85889Victor James A · Kingsville, OHBuilt 1946 · S/N 11AC-309N85891Boyd Jeffrey · Justin, TXBuilt 1946 · S/N 11AC-268N85895Layne Frank L · Duluth, MNBuilt 1946 · S/N 11AC-283N858RBBurgess Darcie L · Muncie, INBuilt 1946 · S/N 7AC-1796N85905Freshcorn Robert D · Waller, TXBuilt 1946 · S/N 11AC-327N85906Nickel Matthew · Bakersfield, CABuilt 1946 · S/N 11AC-315N85907Robbins Joseph L · Hollister, MOBuilt 1946 · S/N 11AC-311N8590VNichols Dean Emerson · Clearwater, FLBuilt 1974 · S/N 148-75N85915Indigo Expeditions LLC · Patterson, NCBuilt 1946 · S/N 11AC-317N85916Freyburger Paul W · Java Village, NYBuilt 1946 · S/N 11AC-326N85917Aviation Investment LLC · Stoughton, WIS/N 11AC-328N85919Buchholtz Larry C · Wilton, NDBuilt 1946 · S/N 11AC-331N85920Weck Geoffrey E · Woodstock, ILBuilt 1946 · S/N 11AC-332N85921Barnes Robert B · Chico, CABuilt 1946 · S/N 11AC-340N85922Jeffryes Richard · Creswell, ORS/N 11AC-341N85929Hale Brian E · Carrollton, MOS/N 11AC-349N8592VWest Michigan Aviation Academy · Grand Rapids, MIS/N 149-75N85931Burg John C · Mc Gregor, IABuilt 1946 · S/N 11AC-346N85932Quesenberry Richard K · Foley, MOBuilt 1946 · S/N 11AC-354N85937Hammerle Tye F · Kenosha, WIS/N 11AC-359N8593VShoemaker John L · Arnold, MDBuilt 1974 · S/N 1075-75N8594Campbell Jaret R · Watertown, SDBuilt 1973 · S/N 459-73N85942New Joel H · Waco, TXBuilt 1946 · S/N 11AC-330N85948Oconnor Michael D · Jackson, MIBuilt 1953 · S/N 11AC-360
Back to AD 2000-25-02 R1