AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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.
N61257T&T Highcountry Flying Service LLC · Saint Anthony, IDN6126ABeyer Jay · Bismarck, NDN6126UR & D Leasing Inc · Lemoore, CAN6128WWhitten Flying Service Equipment LLC · Snook, TXN6129XAg-Aviators Inc · Nashville, GAN612LAWindsock Skies LLC · Caldwell, TXN61315East Air Aviation LLC · Hanceville, ALN6131KLt Development Group LLC · Watford City, NDN6132AMaco Aviation Inc · Dayton, WAN6132WWest Hills Aviation Inc DBA · Huron, CAN6133RReed Aviation Inc · Iota, LAN6133ZBruces Flying Service Inc · Arlington, GAN61340Ag Air II LLC · Scott, MSN6134QEast Air Aviation LLC · Hanceville, ALN6134YEsoteric Aviation LLC · Turner, MTN6135UCrop Dusters LLC · Maurice, IAN61366Plantation Flyers LLC · Lettsworth, LAN6136HAurora Cooperative Elevator Company · Aurora, NEN6136MEdwards Flying Service Inc · Leland, MSN61373H & G Farms Inc · Corcoran, CAN6139VRussel Armstrong & Danny Hawk DBA Onstott Dusters · Yuba City, CAN613GGNcp Equipment LLC · Wilmington, DEN613RFB R S Leasing Inc · Wilmington, DEN613TREquipment King LLC · Waco, TXN6142MGentrys Flying Service LLC · Prattville, ALN6143LCkw Aviation LLC · Dalhart, TXN61481Aerial Crop Protection Inc · Belle Glade, FLN6148TAllen Air Ltd LLC · Wray, CON614ARTwin Otter International Ltd · Las Vegas, NVN614CWBank Of Utah Trustee · Salt Lake City, UTN614LAWindsock Skies LLC · Caldwell, TXN614MWCrider Flying Service Inc · Swifton, ARN614YGrowers LLC · Mohall, NDN6159FAero Spray Inc DBA · Appleton, MNN6160GChapman Cody A · Wray, CON6164QRunsick Michael C DBA · Wynne, ARN6165CAir Care Leasing LLC · Lamar, CON6165UTailwinds Air Inc · Morganza, LAN61664Arthur Aviation LLC · Arthur, NDN616EAEmpireair LLC · Spokane Valley, WAFirst renewal noticeN616JBAdams Aerial Solutions LLC · Decatur, ILN616MAMeyers Air Service LLC · Superior, NEN6170XWest Hills Aviation Inc · Huron, CAN6174HWoodley Aerial Leasing LLC · Walnut, ILN6175STri-Rotor Spray And Chemical · Ulysses, KSN6176LTrinkle Aviation LLC · Kingsburg, CAN6176YRegistered aircraftN6177JMcginty Flying Service LLC · Jones, LAN617MMCal-Ore Life Flight LLC · Brookings, ORN617STSartec Corp · Pensacola, FL
Back to AD 2016-05-13