Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N84947Keeslar David L · Sturgis, MIBuilt 1946 · S/N 7AC-3669 N84949Echenique Frank Joe · Bakersfield, CAFirst renewal noticeBuilt 1946 · S/N 7AC-3671 N84961Maynard Gary Michael · Princeton, NCBuilt 1946 · S/N 7AC-3684 N84965Vermont Sport Aircraft LLC · Perkinsville, VTBuilt 1946 · S/N 7AC3688 N84966King Gerald A · Bolivar, PABuilt 1946 · S/N 7AC-3689 N84970Becker Chris H · Panama City, FLBuilt 1946 · S/N 7AC-3693 N84972Hanson Mike · Vinton, IABuilt 1946 · S/N 7AC-3697 N84973Grimes Kevin C · Kenai, AKBuilt 1946 · S/N 7AC-3698 N84974Sines Keith Loraine · Keyser, WVBuilt 1946 · S/N 7AC-3696 N84976Bishop Harold W · Bonners Ferry, IDBuilt 1946 · S/N 7AC-3700 N84983Gilberts Flying Club Inc · Hampshire, ILBuilt 1946 · S/N 7AC-3707 N84986Scheidler Jerome P · Greensburg, INBuilt 1946 · S/N 7AC-3710 N84991Avery John W · Fergus Falls, MNBuilt 1946 · S/N 7AC-3715 N84997Roberts Paul T · Powhatan, VABuilt 1946 · S/N 7AC-3721 N84998Armstrong Robert K · Rawlings, MDBuilt 1946 · S/N 7AC-3722 N84999Boynton Rodney B · Ocala, FLBuilt 1946 · S/N 7AC-3723 N84ACAmerican Champion Aircraft Corp · Rochester, WIS/N 521-2016 N84JDBeving Charles D · Garden City, SDBuilt 1993 · S/N 700-93 N84LMurrey James E · Pulaski, TNBuilt 1946 · S/N 7DC-3228 N85004Nunn Thomas E · Bradley, CABuilt 1946 · S/N 7AC-3728 N85009Kepler Justin W · Nikolaevsk, AKBuilt 1946 · S/N 7AC-3734 N85010Hoppes Larry J · Springville, INBuilt 1946 · S/N 7AC-3735 N85018Dugger Richard · Early, TXBuilt 1946 · S/N 7AC-3743 N85019Smith Peter R · Lewistown, MTBuilt 1946 · S/N 7AC-3744 N85021Registration Pending · Portland, ORRegistration pending, pending cancellationBuilt 1946 · S/N 7AC-3746 N85024Sauter William L Trustee · Santa Fe, NMBuilt 1946 · S/N 7AC-3749 N85027Obritsch Monte R · Malcolm, NEBuilt 1946 · S/N 7AC-3752 N85029Indiana Flyers Inc · Roachdale, INBuilt 1946 · S/N 7AC-3754 N8502EJones Derick · Moultonborough, NHS/N 7GC-71 N8503Finney Michael E Trustee · Albany, INBuilt 1973 · S/N 910-73 N85033Hardaway Michael R · Springville, CABuilt 1946 · S/N 7AC-3758 N85040Copper Aviation Tailwheel LLC · Molt, MTBuilt 1946 · S/N 7AC-3765 N85041Oshrin Eugene L · Bridgehampton, NYBuilt 1946 · S/N 7AC-3768 N85042Roth Sean C · Tucson, AZBuilt 1946 · S/N 7AC-3769 N85049Shipman Jesse L · Honey Grove, TXFirst renewal noticeBuilt 1946 · S/N 7AC-3776 N8505Lunetta Peter Joseph Jr · Niskayuna, NYBuilt 1973 · S/N 69-73 N85057Letrello Michael F · Saint Charles, MOBuilt 1946 · S/N 7AC-3784 N85059Lachendro Edward M · Beaver Dam, WIBuilt 1946 · S/N 7AC-3786 N85062Flack Ken · Cortland, OHBuilt 1946 · S/N 7AC-3789 N85063Young Thomas M · Homer, AKBuilt 1946 · S/N 7AC-3790 N85065Wade Timothy K · Roanoke, TXBuilt 1946 · S/N 7AC-3792 N85066Anderson Timothy D · Mountain Iron, MNBuilt 1946 · S/N 7AC-3793 N85068Perry Robert P · Chelan, WAS/N 7AC-3795 N85072Grandey Michael D · Sanger, TXBuilt 1946 · S/N 7AC-3799 N85073Wright Ricky G · Austin, INBuilt 1946 · S/N 7AC-3800 N85077Whaley Roger D · Swansboro, NCBuilt 1946 · S/N 7AC-3807 N85079Marrion Raymond E · Bolton, CTBuilt 1946 · S/N 7AC-3809 N8507ERifenburg Brian K · Ward Cove, AKS/N 7GC-75 N85081Classic Aviation LLC · South Saint Paul, MNBuilt 1946 · S/N 7AC-3811 N85082Droege Robert M · Saratoga Springs, NYBuilt 1946 · S/N 7AC-3812

Back to AD 2000-25-02 R1