AD 2002-19-10
Registered aircraft · 1,092
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-19-10')
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-19-10')
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-19-10') 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-19-10') 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.
N402FHAasjng 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, LAN40LAMid-Atlantic Aircraft Leasing LLC · Wilmington, DEN41068Woodley Aerial Leasing LLC · Walnut, ILN4106AAir Cover Crop Solutions LLC · Frankford, MON41119Crop Jet Aviation LLC · Gooding, IDN411GRLake Air Service LLC · Jennings, LAN411GSWoodley Aerial Leasing LLC · Walnut, ILN4120RTumbleweed Leasing LLC · Tacoma, WAN4122XEllis Flying Service Inc · Newport, ARN4149PPonderosa Airtankers LLC · Safford, AZN41525County Line Flying Service Inc · Coy, ARN41588Echo Fox Leasing LLC · Wilmington, DEN41600Patriot Ag Air LLC · Huntington, INN41613All In Flying Co · Wilmington, DEN41647Odessa Air Service Inc · Moses Lake, WAN41651Bank Of Utah Trustee · Salt Lake City, UTN41687Over The Top Aviation Inc · Jonesboro, ARN4170SLowry Flying Service Inc · Grinnell, IAN4172USki Ag Aviation LLC · Bismarck, NDN417BMMilhon Air Inc · Martinsville, INN419FFMccreary Flying Service LLC · Clarksdale, MSN419TWMidwest Agri Drone LLC · Saint Joseph, MON42022Central Iowa Agricultural Aviation LLC · Wellsburg, IAN4203WFast Ag Air LLC · Watertown, SDN420SAKingrey William S III · Richmond, TXN4212JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN4215WAero Applicators Inc · Sterling, CON4216KBecker Barton C · Oneill, NEN4216WTri Air Farms LLC · Mamou, LA
Back to AD 2002-19-10