AD 2002-11-05
Registered aircraft · 948
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
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:2002-11-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-05')
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:2002-11-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-05') 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.
N3659NHoppe Air LLC · Beaman, IAN365LAFarm Air Corp · Minturn, ARN369ZPRegistration Pending · Pasco, WARegistration pendingN370JBAurora Cooperative Elevator Co · Aurora, NEN376ASAero Spray Inc DBA · Appleton, MNN379ASAero Spray Inc DBA · Appleton, MNN385LABrunetti Finley Jr · Shelby, MSN386LAHinkle Airspray Inc · Cavalier, NDN389LABailey Air LLC · Delhi, LAN392KWSpradin Flying Service Inc · Petersburg, TXN393LAC&L Holzwarth Inc · Virden, ILN396LANeal Aircraft Inc · Slaton, TXN397LAWil-Co Flying Service LLC · Dewitt, ARN398ASAero Spray Inc DBA · Appleton, MNN398LAWestern Pilot Service Inc · League City, TXN39GJTri County Ag Service Inc · Ipswich, SDN400XXAbernathy Spraying Service Inc · Tipton, OKN401BMBart'S Flying Service Inc · Storm Lake, IAN401CWDakotawild Aviation Inc · Westhope, NDN401KREast Air Aviation LLC · Cullman, ALN401NEBender Jace Edwin Fredrick · Humphrey, NEN401THAerial Ag Services LLC · Hillsboro, TXN402CSWoodley Aerial Leasing LLC · Walnut, ILN402CWThisius Flying Service Llp · Wells, MNN402DEDeby Ag Leasing Lp · Wakarusa, INN402DGNorth Central Aviation LLC · Valentine, NEN402FAgriculture Aviation Services LLC · Clarkfield, MNN402FHAasjng LLC · Holdrege, NEN402GKGress Air LLC · Dunbar, NEN402JDefenbaugh Matthew J · Biggsville, ILN402JGWhalen Mark P · Millington, MDN402JWKeahey Aviation LLC · West Monroe, LAN402KKKevin Kingsley LLC · Lamar, MON402LTBank Of Utah Trustee · Salt Lake City, UTN402PRBarts Flying Service Inc · Storm Lake, IAN402REKingrey William S III · Richmond, TXN402SKOli Grow LLC · Baskin, LAN402SROli Grow LLC · Baskin, LAN402TSunflower Aero Inc · Atwood, KSN402TMShores Ag-Air Inc · Robstown, TXN402TTSky West Aviation Inc Trustee · Albuquerque, NMN402UWestern Ag Aviation Inc · Plains, KSN402VA + Aviation Services LLC · Goodland, KSN402WD402wd Holdings LLC · Corpus Christi, TXN402WRHoxie Sprayers Inc · Hoxie, KSN402YSky West Aviation Inc Trustee · Albuquerque, NMN402ZSevcik Clint · Medford, MNN4036FSaffer Spray Service Inc · Fowler, CON406BMEvergreen Flying Service Inc · Rayville, LAN408ACOver & Under Flying Service Inc · Winamac, IN
Back to AD 2002-11-05