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.

N41525County Line Flying Service Inc · Coy, ARS/N 802A-0231 N4155PAndersons Flying Service Inc · Robbins, CABuilt 2008 · S/N 502B-2629 N41608Higgins Leasing Inc · Spring, TXBuilt 2007 · S/N 502B-2613 N41612Puryear Rodney K · Pampa, TXBuilt 2007 · S/N 502B-2612 N41613All In Flying Co · Wilmington, DEBuilt 2008 · S/N 802A-0273 N41647Odessa Air Service Inc · Moses Lake, WABuilt 2007 · S/N 802A-0279 N41675Aero Spraying Service Inc · Williston, NDBuilt 2008 · S/N 502B-2650 N41687Over The Top Aviation Inc · Jonesboro, ARBuilt 2008 · S/N 802A-0309 N4170SLowry Flying Service Inc · Grinnell, IAS/N 802A-0278 N4172USki Ag Aviation LLC · Bismarck, NDBuilt 2010 · S/N 402B-1228 N417BMMilhon Air Inc · Martinsville, INBuilt 2007 · S/N 802A-0276 N41854Alpha Ag Air LLC · Little River, KSBuilt 2008 · S/N 502B-2624 N41991Bravo Gildardo F · Mission, TXBuilt 2008 · S/N 502B-2623 N419FFMccreary Flying Service LLC · Clarksdale, MSS/N 802A-0191 N4200SWood Flying Inc · Panhandle, TXBuilt 2008 · S/N 502B2625 N4203WFast Ag Air LLC · Watertown, SDBuilt 2006 · S/N 802A-0253 N42086Beta Ag Inc · Ralls, TXBuilt 2008 · S/N 502B-2637 N420SAKingrey William S III · Richmond, TXBuilt 1990 · S/N 402-0776 N4215WAero Applicators Inc · Sterling, COBuilt 2009 · S/N 402B-1211 N4216KBecker Barton C · Oneill, NES/N 402A-1219 N4216WTri Air Farms LLC · Mamou, LAS/N 802A-0320 N42190Matecumbe Flying Service Inc · Immokalee, FLS/N 502B-2705 N4219MBombero Aviation LLC · Childress, TXBuilt 2007 · S/N 802A-0264 N4219WEverett Flying Service Inc · Holly Grove, ARS/N 802A-0334 N4219YTri State Aerial LLC · Canton, SDBuilt 2010 · S/N 802A-0352 N421CAD&D Aerial LLC · Gratiot, WIBuilt 2009 · S/N 502B-2672 N4220WRegistered aircraftBuilt 2010 · S/N 502B-2696 N4221STri Rotor Spray & Chemical · Ulysses, KSBuilt 2008 · S/N 802A-0305 N4223GTowe Flying Service · Madison, ALBuilt 2009 · S/N 502B-2675 N422JCChorman Spraying LLC · Milton, DEBuilt 2018 · S/N 802A-0762 N422RDAir-Sprayers Inc · Two Buttes, COBuilt 2009 · S/N 402B-1224 N4244FOli Grow LLC · Baskin, LABuilt 2009 · S/N 802A-0316 N4244PPrairie Ag Service LLC · Des Arc, ARS/N 802A-0308 N4247UHiggins Leasing Inc · Woodlands, TXBuilt 2016 · S/N 802-4001 N425BFBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2014 · S/N 502B-3018 N4265DVisser Ag Inc · Rigby, IDBuilt 2007 · S/N 802A-0259 N426LAC And C Flying Service Inc · Pocahontas, ARBuilt 2012 · S/N 802A-0441 N427AAAero Leasing LLC · Virden, ILS/N 402A-1032 N427NSVisser Ag Inc · Rigby, IDBuilt 2003 · S/N 802A-0153 N428JJKingrey William S · Richmond, TXBuilt 2014 · S/N 402B-1307 N428LAFletcher Flying Service Inc · Roe, ARBuilt 2006 · S/N 802A-0228 N42EAEscott Aerial Spraying LLC · El Reno, OKBuilt 2012 · S/N 402B-1269 N432DABob Donner Enterprises LLC · Belview, MNBuilt 1997 · S/N 401B-1029 N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435 N4350JPhoenix Equipment Lc · Nickerson, KSBuilt 1982 · S/N 400A-0463 N438RJSunflower Aero Inc · Atwood, KSBuilt 1996 · S/N 502A-0345 N439PSTlb Air Llp · Grafton, NDBuilt 2023 · S/N 502A-3426 N443LARubbert Jan · Upham, NDS/N 502A-3143 N444ASAas LLC · Ovid, MIBuilt 1982 · S/N 400-0438 N444MSAas LLC · Ovid, MIS/N 400-0444

Back to AD 2001-10-04 R1