Skip to content

AD 2001-10-04 R1

Registered aircraft · 1,468

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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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.

N1546HAero Spray Inc DBA · Appleton, MNBuilt 1992 · S/N 802A-0003 N1546UBauer Charles A · Graceville, MNBuilt 1992 · S/N 401-0873 N1546XHopkins Robert E Jr · Sumter, SCBuilt 1992 · S/N 401-0874 N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183 N1554KBasin Aviation Inc · Rio Oso, CAS/N 401-0882 N1556WPrecissi Flying Service Inc · Lodi, CABuilt 1992 · S/N 502-0185 N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884 N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175 N1558URba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0188 N157LAWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0157 N166LAAeronautical Technologies Inc · Clovis, NMBuilt 2004 · S/N 802A-0166 N166MMCrider Flying Service Inc · Swifton, ARBuilt 1999 · S/N 502A-0572 N169JTTidwell Flying Service Inc · Carlisle, ARBuilt 2014 · S/N 802A-0574 N173TANew Frontier Aviation LLC · Fort Benton, MTBuilt 2004 · S/N 802A-0178 N174MLNew Frontier Aviation LLC · Fort Benton, MTBuilt 2003 · S/N 802A-0168 N175LAMitchell Andrew D Trustee · Winnie, TXBuilt 2004 · S/N 802A-0175 N1802MMeyerkorth Aviation LLC · Rock Port, MOBuilt 2016 · S/N 802A-0678 N1802QPontiac Flying LLC · Pontiac, ILBuilt 2012 · S/N 802A-0484 N182PBDodson International Parts Inc · Rantoul, KSS/N 402-0806 N186DCAir Care Inc · Lamar, COBuilt 1992 · S/N 502-0186 N187LALocker Fred · Muleshoe, TXBuilt 2001 · S/N 802A-0108 N18KDH & W Ag Services Inc · Veribest, TXBuilt 2007 · S/N 402B-1187 N194BMBombero Aviation LLC · Childress, TXBuilt 2008 · S/N 802A-0283 N194CAAir Tractor Inc · Olney, TXS/N 802A-1350 N196CFAir Tractor Inc · Olney, TXS/N 802A-1277 N196LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0196 N196PK3m Ag LLC · Beebe, ARBuilt 1996 · S/N 502B-0364 N197RKArg Aviation LLC · Lexa, ARBuilt 1997 · S/N 502B-0413 N198LAVissair LLC · Rigby, IDBuilt 1993 · S/N 502-0198 N20001Dcs Air LLC · Lewes, DEBuilt 2011 · S/N 802A0418 N2003BBrylen 502 LLC · Dumas, TXBuilt 2011 · S/N 502A-2741 N2003YOops LLC · Cheyenne, WYBuilt 2011 · S/N 802A-0428 N200LAAsap Flying Service Inc · Hermiston, ORBuilt 2008 · S/N 802A-0292 N200WHDcs Air LLC · Lewes, DEBuilt 2018 · S/N 802A-0755 N2017NKen Grubbs Aero Inc · Harrisburg, ARBuilt 2011 · S/N 802A-0429 N2019PAgricultural Air Services LLC · Jupiter, FLBuilt 2011 · S/N 502B-2792 N2022BWil-Co Flying Service LLC · De Witt, ARBuilt 2011 · S/N 802A-0433 N2022QHartley Flying Service Inc · Stuttgart, ARBuilt 2011 · S/N 802A-0435 N2022YPinecliff Aerial Inc · Camilla, GABuilt 2011 · S/N 502B-2760 N202FHTr Flying Service LLC · Milan, MNBuilt 1992 · S/N 402A-0867 N2032KKing Ag Leasing Inc · Sudan, TXBuilt 2011 · S/N 502B-2749 N2035EGibson Flying Service Inc · Marianna, ARBuilt 2011 · S/N 502B-2791 N2038QAt402 LLC · Banquete, TXBuilt 2013 · S/N 502B-2878 N2039YDelta Dusters LLC · Newellton, LABuilt 2011 · S/N 802A-0403 N2040EWeaver Flying Service Inc · Quincy, WABuilt 2011 · S/N 502B-2743 N2045GOught 9 LLC · East Helena, MTBuilt 2012 · S/N 502B-2820 N2047VWilliamsburg Air Service Inc · Kingstree, SCBuilt 2012 · S/N 402B-1253 N20527Schwenk Aircraft Inc · Appleton, MNBuilt 2012 · S/N 502B-2798 N205CGSeewald Jeffrey W · Great Bend, KSBuilt 2006 · S/N 502A-2603 N205KCWalton Agwings Inc · Jonesboro, ARBuilt 2017 · S/N 802A-0728

Back to AD 2001-10-04 R1