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.
N825SDGreat Valley Management Inc · New Castle, DEN826FPMango Air 2 LLC · Oxnard, CAN826XTransport Services LLC · Birmingham, ALN827DLGa Ventures LLC · Scott, LAN828FCGuardian Flight LLC · Lewisville, TXN828GBG B Aerial Applications Inc · Slaton, TXN828PGPowell 737pg LLC · Baton Rouge, LAN828SSSusanaire LLC · Dallas, TXN829MCKidd Johnston Aviation LLC · Odessa, TXN829RTMcclendon Services LLC · Marianna, ARN829SJInternational Air Services Inc Trustee · Carson City, NVN82AXBank Of Utah Trustee · Salt Lake City, UTN82CXEpic Aircraft LLC · Bend, ORN82LHAirborne Support Group LLC · Marion, MTN82XLFast Fly Inc · Dallas, TXN83110Jones Aviation Inc · Biggs, CAN831FEFederal Express Corporation · Memphis, TNN831LAAg Concepts Inc · Morgan City, MSN831VFEpic Aircraft LLC · Bend, ORN8347KPorter Flying Service LLC · Missoula, MTN835ACBank Of Utah Trustee · Salt Lake City, UTN838RAT206 Aviation LLC · Stockton, CAN839FBFarm Brothers Flyers A LLC · Gould, ARN83FTR E E Inc · Beaumont, TXN83GTChambliss Aerobatics LLC · Chandler, AZN83PWMotion Skies LLC · Rocky Mount, NCN83RWEhr Ventures LLC · Jourdanton, TXN83WEMiner'S Inc · Hermantown, MNN840CAMetrea Special Aerospace Isr Inc · Bethany, OKN840JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN841BFWells Flying Services LLC · Holdrege, NEN841FEFederal Express Corp · Memphis, TNN841KYPinaire Holdings LLC · Hendersonville, TNN841LABank Of Utah Trustee · Salt Lake City, UTN842EElectric Boat Corp · Groton, CTN842EBIsr Aviation LLC · Wilmington, DEN842KAKh Aviation LLC · Langdon, NDN843BHGaylord Theodore Scott DBA · La Grange, CAN843DBDoan Creek LLC · Walla Walla, WAN843EElectric Boat Corp · Groton, CTN843FEFederal Express Corporation · Memphis, TNN844FEFederal Express Corporation · Memphis, TNN845FEFederal Express Corporation · Memphis, TNN846BEM D Airways Inc · Derby, KSN846DJHeritage Aviation Management Ltd · Conroe, TXN846FEFederal Express Corporation · Memphis, TNN846RDRegistration Pending · Naples, FLRegistration pendingN847BABeech Transportation Inc · Eden Prairie, MNN847CPFedair LLC · Indianapolis, INN847FAAerial Crop Services LLC · East Prairie, MO
Back to AD 2016-05-13