Skip to content

AD 2001-10-04 R1

Registered aircraft · 1,467

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.

N9156COconnor Dallas · Poplar, MTBuilt 1993 · S/N 401-0898 N9159ABarajas Samuel · Mission, TXS/N 401-0900 N915RAB&S Air Inc · Lumpkin, GABuilt 2019 · S/N 802A-0809 N9179AFrontier Agricultural Services Inc · Calexico, CABuilt 1993 · S/N 401-0904 N9179NWilliams Delbert D · Goldfield, NVBuilt 1989 · S/N 401-0897 N917JBNick'S Flying Service Inc · Lagrange, INBuilt 2018 · S/N 802A-0769 N917RARegistered aircraftBuilt 2024 · S/N 802A-1174 N9184QMowata Farms LLC · Mamou, LABuilt 1993 · S/N 502-0209 N9184UWest Hills Aviation Inc DBA · Huron, CABuilt 1993 · S/N 502-0211 N9185FFarm Brothers Flyers A LLC · Grady, ARBuilt 1993 · S/N 502-0206 N9185GDodson International Parts Inc · Rantoul, KSBuilt 1993 · S/N 502-0213 N9185XWilbur-Ellis Co · Salinas, CABuilt 1993 · S/N 401-0910 N9186JSwancutt Aviation Inc · Chester, IABuilt 1993 · S/N 401-0912 N9187QLewis Flying & Maintenance Service Inc · Morse, LABuilt 1993 · S/N 502-0219 N9187VPlu'S Flying Service Inc · Ekalaka, MTS/N 401-0907 N9187WAcadian Dusters LLC · Church Point, LABuilt 1993 · S/N 502-0220 N9187ZEagle LLC · Sleepy Eye, MNBuilt 1993 · S/N 502-0223 N9188BTlc Flying Inc · Colfax, WABuilt 1993 · S/N 401-0899 N9190QDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N 401-0925 N9190VT&T Highcountry Flying Service LLC · Saint Anthony, IDFirst renewal noticeBuilt 1993 · S/N 402-0919 N91918Thiel Air Care Inc · Chowchilla, CABuilt 1993 · S/N 502-0227 N9192BKracke Spraying Service Inc · Fargo, NDBuilt 1993 · S/N 401-0929 N9192JAir Care Inc · Lamar, COS/N 502-0228 N9193VMurtagh Flying Service Inc · Lexington, MSBuilt 1994 · S/N 502-0231 N9194PLeading Edge Aero LLC · Southampton, NJBuilt 1993 · S/N 502-0233 N91959Aslesen Leasin LLC · Halstad, MNBuilt 1994 · S/N 802A-0008 N9195XRba LLC · Kimberly, IDBuilt 1993 · S/N 502-0235 N9196CWoodley Aerial Leasing LLC · Walnut, ILBuilt 1994 · S/N 402A-0937 N9196ZOscar Aviation LLC · Livonia, LAS/N 502B-0238 N9197DT-C Aerial LLC · Littlefield, TXBuilt 1994 · S/N 502B-0240 N9197QInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N 401-0943 N9197VA+ Aviation Services LLC · Goodland, KSBuilt 1994 · S/N 401-0944 N923LHGrowers Air Service Inc · Woodland, CABuilt 2012 · S/N 502B-2797 N926LADevil Dusters Inc · Artesia, NMBuilt 1993 · S/N 402-0911 N927BSB&S Air Inc · Lumpkin, GABuilt 2022 · S/N 802A-0973 N927JPBair Aviation Inc · Lake City, SDBuilt 2008 · S/N 402B-1203 N928BABrekke Aviation Inc · Edmore, NDBuilt 2018 · S/N 802A-0754 N928GP402wd Holdings LLC · Robstown, TXBuilt 2011 · S/N 402B1242 N928JESky Apply LLC · Hector, MNBuilt 1989 · S/N 502-0065 N928SMFirst State Ag Air Inc · Viola, DEBuilt 2012 · S/N 802A-0443 N928TNBoettcher Aerial Company Inc · Beloit, KSBuilt 2013 · S/N 502B-2872 N939LAConfederate Air Inc · Mcgehee, ARBuilt 2013 · S/N 502B-2939 N941LARice Flying LLC · Poplar Bluff, MOBuilt 2022 · S/N 802-0941 N94ZL9zl Leasing LLC · Plover, WIBuilt 1994 · S/N 502B-0241 N950HCRoma Air Corp · Belle Glade, FLS/N 802A-0233 N951FANeal Aircraft Inc · Slaton, TXBuilt 2014 · S/N 802A-0565 N952LAFlying S Aviation · Palacios, TXBuilt 2014 · S/N 502B-2952 N953FAAir Support 1 Inc · Middletown, DES/N 802A-0585 N953JWWade Aviation Inc · Calhoun City, MSBuilt 2014 · S/N 502B-2953 N957CWWischer Enterprises LLC · Grandin, NDBuilt 2011 · S/N 402B-1245

Back to AD 2001-10-04 R1