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.

N390XDDecathlon Xtreme Inc Trustee · Wilmington, DEBuilt 2014 · S/N 1144-2014 N3911AAllen Richard P · Southampton, NJBuilt 1956 · S/N 7BCM-452 N3913EGirten Patrick J · Evansville, INBuilt 1947 · S/N 11AC-S100 N3914ETennis Stephen D · Hudson, MIBuilt 1947 · S/N 7AC-7119 N3918ERonald E Giddens · Boynton Beach, FLBuilt 1947 · S/N 7AC-7125 N3919EMiller Glenn E · Selma, CABuilt 1947 · S/N 7AC-7121 N391ACAmerican Champion Aircraft Corp · Rochester, WIBuilt 1979 · S/N 400-98 N391AJOreck Tom · Asheville, NCBuilt 2004 · S/N 954-2004 N391DMKirvida James M · Dellwood, MNFirst renewal noticeBuilt 2000 · S/N 1302-2000 N391MAMilton Chuck · Onalaska, WABuilt 2002 · S/N 440-2002 N391PDMarteney Donald L · Sarasota, FLBuilt 1946 · S/N 7AC-5891 N3920ELadd Daniel T · Loudon, NHBuilt 1947 · S/N 11AC-S95 N3923AMason William R · Putnam, CTBuilt 1947 · S/N 47-1214 N3923EMatter Nathan · Saukville, WIBuilt 1947 · S/N 11BC-5 N3924EBrooks Jerald Ward · Anderson, CABuilt 1947 · S/N 11BC-6 N3925EJones Patrick L · Fort Wayne, INBuilt 1947 · S/N 11BC-7 N3928PAtkinson William Gary · Canton, NYBuilt 1947 · S/N 7DC-38 N3931EStorer Daniel A · Guthrie, OKBuilt 1947 · S/N 11BC-13 N3933EWatrud Joel C · Waskish, MNBuilt 1947 · S/N 11BC-15 N3935EHoag Michael R · Three Rivers, MIBuilt 1947 · S/N 11BC-17 N393MAVandelay America LLC · Newport Beach, CABuilt 2007 · S/N 514-2007 N393TMAvion Acrobatico LLC · Waterloo, ILBuilt 1973 · S/N 82-73 N3941ESadler George C · Ludington, MIBuilt 1947 · S/N 11BC-22 N3942EErickson Lambert A · Littlefork, MNBuilt 1947 · S/N 11BC-23 N3946EWilcox Darrol A · Nenana, AKBuilt 1947 · S/N 11BC-27 N3949EJestice Cyrus A · Viola, ARBuilt 1947 · S/N 11BC30 N394RBJones Luther L · Covington, LABuilt 1999 · S/N 837-99 N394RLLynn Robert C · Cheyenne, WYBuilt 2017 · S/N 588-2017 N3951ESundberg Robert A Jr · Corinna, MEFirst renewal noticeBuilt 1947 · S/N 11BC-32 N3954EScott Shawn C · Albuquerque, NMS/N 11BC-38 N3955EJackson Ronald Lee · Brainerd, MNBuilt 1947 · S/N 11BC-39 N395TEast Iowa Air Inc · Bennett, IABuilt 2023 · S/N 633-2023 N39632Tumbleson Shelly L · San Antonio, TXBuilt 1946 · S/N 7AC-6147 N39634National Machinery & Conveyor Inc · Marion, INBuilt 1945 · S/N 11AC-2 N3963APultz Jeremy · Dinwiddie, VABuilt 1948 · S/N 7CCM-471 N39642Melby Mark G · Mount Pleasant, WIBuilt 1945 · S/N 7AC-10 N3966EVick Karl A · Elko, MNBuilt 1947 · S/N 11BC-51 N3967EReid Robert Alan · Big Lake, AKBuilt 1947 · S/N 11BC-52 N3969EHill Chad R · Bellevue, NEBuilt 1947 · S/N 11BC-54 N396ACMayfly Aviation LLC · Quincy, FLBuilt 2002 · S/N 895-2002 N396BGLow And Slow Flyers LLC · Urbandale, IAS/N 1216-96 N3970EAitchison Jason M · Minot, NDS/N 11BC-55 N3973EAsh Andrew D · Waitsburg, WABuilt 1947 · S/N 11BC-58 N397RDGlover Michael · Parker, TXS/N 533-2010 N3984EBenjamin Robert J · Lebanon, ORBuilt 1947 · S/N 11BC-72 N398AGShin Howard I · New York, NYBuilt 2008 · S/N 1079-2008 N398BCNorthwest Back Country Aircraft LLC · Caldwell, IDBuilt 2026 · S/N 1231-2026 N398SBYuba Sutter Aviation Inc · Olivehurst, CABuilt 1998 · S/N 821-98 N3990EBrudjar Mike V · Vilonia, ARBuilt 1947 · S/N 11BC-78 N3997Shippers Michael S · Williamson, NYBuilt 1947 · S/N 7AC-7052

Back to AD 2000-25-02 R1