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.
N854CMHeritage Aviation Management Ltd · Conroe, TXN854FAAdams Aerial Solutions LLC · Decatur, ILN85516United States Department Of State · Melbourne, FLN855FEAircraft Structures International Corp · Enid, OKN855LAWilmot Airplane Ventures LLC · Mer Rouge, LAN856FEFederal Express Corporation · Memphis, TNN857FEFederal Express Corp · Memphis, TNN858AAAg Aviation Inc · Muleshoe, TXN858FEFederal Express Corporation · Memphis, TNN858MAMess Aero Inc · Grand Forks, NDN859FEFederal Express Corporation · Memphis, TNN85CLAircraft Structures International Corp · Enid, OKN85HWHigh Notes LLC · Nashville, TNN85LGBank Of Utah Trustee · Salt Lake City, UTN85TKStreamline Aviation LLC · Leawood, KSN860AR412 Jw Aviation LLC · Dover, DEN861FEFederal Express Corporation · Memphis, TNN861MAAerodynamics Worldwide Inc · Wilmington, DEN861PPIrlbeckbruch Plane LLC · York, NEN861ZGGeneral Energy Research Group · Conroe, TXN862FEFederal Express Corporation · Memphis, TNN862KABank Of Utah Trustee · Salt Lake City, UTN863FEFederal Express Corp · Memphis, TNN863MAMartinaire Aviation LLC · Addison, TXN864SFAlaska Skypower LLC · Fairbanks, AKN865DKKubecka Daniel P · Edna, TXN865FEFederal Express Corporation · Memphis, TNN865MASchuman Carriage Co Ltd · Honolulu, HIN865NFNew Frontier Aviation LLC · Fort Benton, MTN866FEFederal Express Corporation · Memphis, TNN866KMMac Aviation LLC · Fargo, NDN867BFBunkie Flying Service Inc · Bunkie, LAN867FEFederal Express Corporation · Memphis, TNN867HCNe Ia Helicopter LLC · Tekamah, NEN867HPCaravan International Leasing Inc · Carson City, NVN869FEFederal Express Corporation · Memphis, TNN869HCPlane LLC · Grove, OKN869SSWells Flying Services LLC · Holdrege, NEN869XATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN870A & S Aviation LLC · Chesterfield, MON870BBBottoms Up Flying LLC · Gould, ARN870CBRaci Management Company Inc · Ogden, UTN870ESPrecision Air LLC · Dermott, ARN870FEFederal Express Corporation · Memphis, TNN870HFHutcherson Flying Inc · Forrest City, ARN870JTBeta Fleet LLC · South Burlington, VTN870JWRice Ag Service Inc · Brinkley, ARN870LAWestern Pilot Service Inc · League City, TXN870MRRice Ag Service Inc · Brinkley, ARN870SSRice Ag Service Inc · Brinkley, AR
Back to AD 2016-05-13