AD 2002-19-03
Registered aircraft · 12,723
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-03')
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-03')
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-03') 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-03') 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.
N115DSOverly Christopher Daniel · Williamsport, OHN115DWMav LLC · Erie, CON115FMCary Steven B · Brookshire, TXN115GTWahl John H · Rockwell City, IAN115HPCam Aviation LLC · Valparaiso, INN115JDC R Aviation Inc · Miami, FLN115JWFeric Drazen · Mesa, AZN115KTMulva Jonathan · De Pere, WIN115MDSpecial Orthogonal Group LLC · Dover, DEN115PFHigh Tech Metals Inc · Harrisburg, PAN115PSAg Farmacy Applications LLC · Erie, ILN115RHRegional Helicopters LLC · Anchorage, AKN115SJWolf Richard · Yerington, NVN115SZThree Greens LLC · San Jose, CAN115TPCavu Enterprises · Edgerton, WIN115VSSei Vincent J · Albuquerque, NMN1162UHamel Raymond F Jr · Wellesley, MAN1164JTyson Bradley · Sherrills Ford, NCN1165XLechtenberg Lance · El Dorado, KSN1165ZRegistration Pending · Las Cruces, NMRegistration pendingN116CPCivil Air Patrol · Maxwell Afb, ALN116DRegistration Pending · Reese, MIRegistration pendingN116GRegistration Pending · Sheridan, WYRegistration pendingN116GWMajestic Airlines Inc DBA · Lynden, WAN116MFWeber Donald E · Saint David, AZN116RCMiesch Gary D · Gowen, MIN116SB114b Holding Inc Trustee · Wilmington, DEN116SLXcel Aviation LLC · Eagle, IDN116SMArchie Aero LLC · Beaverton, ORN116VGBruns Phillip T · Shiro, TXN116WBDunch David J Trustee · Poland, OHN116ZXVranjes Peter · Johnstown, CON1171JNational Test Pilot School · Mojave, CAN1174CGeorgia Forestry Commission · Macon, GAN1176RBas Part Sales LLC · Greeley, CON1176TP C O Leasing Inc · Dobbin, TXN1176ZAirborne Support Inc · Bourg, LAN1177AN1177a LLC · Lewes, DEN117BDHall Alan Ray · Willow Park, TXN117BMManeck Aviation LLC · Columbus, GAN117CSSam Airlines LLC · Wilmington, DEN117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKN117HREmax LLC · Perry, GAN117JCHillsboro Flying Club · Hillsboro, ORN117KRFox Planes LLC · Sterling Heights, MIN117LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeN117MCParish Of East Baton Rouge · Baton Rouge, LAN117SEHalsell Jason · Wolfforth, TXN117TDGiffin Craig D · Windermere, FLN117WVRedline Onsite Services LLC · Opelousas, LA
Back to AD 2002-19-03