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.

N30676Michaelis Gary DBA · Goodwin, ARBuilt 2014 · S/N 802A-0573 N3067JHartley Flying Service Inc · Stuttgart, ARBuilt 2014 · S/N 802A-0554 N3067WMg37 Investments LLC · Holdrege, NEBuilt 2014 · S/N 502B-2977 N3069SRoma Air Corp · Belle Glade, FLBuilt 2014 · S/N 802A-0559 N3070EG B Aerial Applications Inc · Slaton, TXBuilt 2014 · S/N 802A-0551 N3070FDakota Air Spray LLC · Huron, SDBuilt 2014 · S/N 802A-0577 N3070GWilliamsburg Air Service Inc · Kingstree, SCBuilt 2013 · S/N 402B-1303 N3071KAurora Cooperative Elevator Co · Aurora, NEBuilt 2015 · S/N 502B-3014 N3071WWood Flying Inc · Panhandle, TXBuilt 2014 · S/N 502B-3009 N3072FGreat Plains Application LLC · Slayton, MNBuilt 2014 · S/N 502B-2999 N3072YAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0588 N3073CCentral Plains Spraying Inc · Hart, TXBuilt 2014 · S/N 502B-3015 N3074FDeterding James L DBA · Pond Creek, OKBuilt 2014 · S/N 502B-3006 N30757Moses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2013 · S/N 802A-0534 N3075D49 Flying Service LLC · Greenwood, MSBuilt 2015 · S/N 502B-3016 N3076HPost Rock Aviation Inc · Lincoln, KSBuilt 2015 · S/N 502B-3017 N3076WRba LLC · Kimberly, IDBuilt 2015 · S/N 502B-3024 N3078TBarts Flying Service Inc · Storm Lake, IABuilt 2015 · S/N 502B-3027 N307BRRice Flying LLC · Poplar Bluff, MOBuilt 2017 · S/N 802-0718 N3082PCustom Air Inc · Roe, ARBuilt 2015 · S/N 802A-0600 N3082VMid Missouri Spray Service LLC · Richmond, MOBuilt 2015 · S/N 802A-0620 N30832Bank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 502B-3039 N3083KBoyds Aviation LLC · Rayville, LABuilt 2015 · S/N 802A-0618 N3083RAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0627 N3085QAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0628 N3086AArrow Aviation Inc · Broken Bow, NEBuilt 2015 · S/N 802A-0616 N309PFPalmer Flying Service Inc · Manito, ILBuilt 2025 · S/N 802A-1213 N312LARoth Aerial Spraying LLC · Milford, NEBuilt 2015 · S/N 502B-3022 N313FAAg Air Flying Service Inc · Toppenish, WABuilt 2016 · S/N 802A-0655 N313TWWiebe Aerial Applications LLC · Whitewater, KSBuilt 2013 · S/N 502B-2890 N3157BMarlow Aviation LLC · Lamoni, IAS/N 400A-0449 N3160QAg Cat Applicators LLC · Avoca, TXBuilt 1982 · S/N 400-0477 N3160XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1983 · S/N 301-0479 N31626James Richard W · Chowchilla, CABuilt 1983 · S/N 400-0511 N3164BL & L Flying Inc · Glen Allan, MSBuilt 1984 · S/N 400-0513 N3166YDixie Crop Care Inc · Dixie, GABuilt 1984 · S/N 400-0515 N316LAAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1316 N316WRHoxie Sprayers Inc · Hoxie, KSBuilt 1995 · S/N 502A-0316 N319LACrop Air LLC · Eaton, COBuilt 2015 · S/N 502B-3019 N321ATBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 502B-2746 N321DASherer Robert O · Deadwood, SDBuilt 1991 · S/N 402A-0814 N321GAHoppe Air LLC · Beaman, IAS/N 502-0069 N324BSB&S Air Inc · Lumpkin, GABuilt 2025 · S/N 802A-1189 N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144 N326LAMurtagh Flying Service Inc · Lexington, MSBuilt 2018 · S/N 502A-3126 N329BRHorizon Air LLC · Lumpkin, GABuilt 2008 · S/N 502B-2633 N329KHDixie Air Applicators LLC · Itta Bena, MSBuilt 2018 · S/N 502B-3132 N329LAWells Flying Services LLC · Holdrege, NES/N 802A-0345 N329RSolace Aerial LLC · Walnut Hill, FLBuilt 2007 · S/N 502B-2614 N331KECrop Air LLC · Eaton, COBuilt 1982 · S/N 400A-0460

Back to AD 2001-10-04 R1