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.

N39GJTri County Ag Service Inc · Ipswich, SDBuilt 1997 · S/N 401B-1023 N400DQOregon Trail Air Service LLC · Nyssa, ORS/N 301-0343 N400XXAbernathy Spraying Service Inc · Tipton, OKBuilt 1986 · S/N 4000646 N401BMBart'S Flying Service Inc · Storm Lake, IABuilt 1992 · S/N 401-0853 N401CWDakotawild Aviation Inc · Westhope, NDBuilt 1992 · S/N 401-0870 N401KREast Air Aviation LLC · Cullman, ALBuilt 1991 · S/N 401-0813 N401NEBender Jace Edwin Fredrick · Humphrey, NEBuilt 1994 · S/N 401B0960 N401THAerial Ag Services LLC · Hillsboro, TXS/N 401-0875 N402CSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 402A-0816 N402CWThisius Flying Service Llp · Wells, MNBuilt 1998 · S/N 402A-1061 N402DEDeby Ag Leasing Lp · Wakarusa, INBuilt 1991 · S/N 402-0807 N402DGNorth Central Aviation LLC · Valentine, NEBuilt 1999 · S/N 402A-1091 N402FAgriculture Aviation Services LLC · Clarkfield, MNS/N 402A-1125 N402FHAasjng LLC · Holdrege, NES/N 402B-1254 N402GKGress Air LLC · Dunbar, NEBuilt 2004 · S/N 402A-1151 N402JDefenbaugh Matthew J · Biggsville, ILBuilt 2000 · S/N 402A-1117 N402JGWhalen Mark P · Millington, MDBuilt 2013 · S/N 402B-1277 N402JWKeahey Aviation LLC · West Monroe, LAS/N 402B-1249 N402KKKevin Kingsley LLC · Lamar, MOBuilt 2020 · S/N 402B-1430 N402LTBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 402B-1163 N402PRBarts Flying Service Inc · Storm Lake, IABuilt 2013 · S/N 402B-1282 N402REWhitten Flying Service Equipment LLC · Snook, TXBuilt 1997 · S/N 402A-1027 N402SKOli Grow LLC · Baskin, LAS/N 402-0895 N402SROli Grow LLC · Baskin, LABuilt 1994 · S/N 402-0939 N402TSunflower Aero Inc · Atwood, KSBuilt 1998 · S/N 402A-1060 N402TM402wd Holdings LLC · Corpus Christi, TXBuilt 2005 · S/N 402B-1164 N402TTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1304 N402UWestern Ag Aviation Inc · Plains, KSBuilt 1999 · S/N 402A-1116 N402VA + Aviation Services LLC · Goodland, KSBuilt 1998 · S/N 402A-1050 N402WD402wd Holdings LLC · Corpus Christi, TXBuilt 1999 · S/N 402A-1090 N402WRHoxie Sprayers Inc · Hoxie, KSBuilt 2011 · S/N 402B-1244 N402YSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1285 N402ZSevcik Clint · Medford, MNBuilt 2012 · S/N 402B-1252 N4036FSaffer Spray Service Inc · Fowler, COS/N 402A-1058 N406BMEvergreen Flying Service Inc · Rayville, LABuilt 2007 · S/N 802-0265 N407CTCrosswind Aviation LLC · Port Barre, LAS/N 502-0076 N408ACOver & Under Flying Service Inc · Winamac, INBuilt 1993 · S/N 4010921 N409BRMehling Robert C · Hardin, MTS/N 4010909 N40LAMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 802A-0182 N41068Woodley Aerial Leasing LLC · Walnut, ILS/N 402B-1174 N4106AAir Cover Crop Solutions LLC · Frankford, MOBuilt 2005 · S/N 802A-0223 N4109XSky Apply LLC · Hector, MNS/N 502B2602 N410LASunnyside Aero Inc · Schlater, MSBuilt 2020 · S/N 502B-3238 N41119Crop Jet Aviation LLC · Gooding, IDS/N 802A-0229 N411BFNorhtstar Aerospray Inc · Clara City, MNBuilt 2017 · S/N 502A-3082 N4120RTumbleweed Leasing LLC · Tacoma, WAS/N 802A-0232 N4122XEllis Flying Service Inc · Newport, ARBuilt 2017 · S/N 802A-0692 N412KHAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2012 · S/N 502B-2822 N41340Twist Air LLC · Earle, ARS/N 502B-2599 N4149PPonderosa Airtankers LLC · Safford, AZBuilt 2007 · S/N 802A-0255

Back to AD 2001-10-04 R1