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.
N752MMMc Aviation LLC · Fort Lauderdale, FLN753CAMoon Mountain Montana LLC · Missoula, MTN753FAFarm Air Corp · Hoxie, ARN753FXFederal Express Corporation · Memphis, TNN754FXFederal Express Corporation · Memphis, TNN754LAC & L Holzwarth Inc · Virden, ILN755DMMdst Aircraft Leasing LLC · Ripon, WIN755EMSea Star Inc · Wetumpka, ALN755FXFederal Express Corporation · Memphis, TNN7580BMec International Trading LLC · Daytona Beach, FLN7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXN758KCentral Virginia Aviation Inc · North Dinwiddie, VAN758LALowry Flying Service Inc · Grinnell, IAN75AWSemper Blue Aviation LLC · New Braunfels, TXN75LVCook Childrens Health Enterprises · Fort Worth, TXN75LW4t Aviation LLC · Maypearl, TXN75MSDodson International Parts Inc · Rantoul, KSN75PGDasch Air LLC · Alamo, CAN75ZDynamic Avlease Inc · Bridgewater, VAN760JEIslander Holdings Ltd · Fort Lauderdale, FLN761CGCoulson Aviation (USA) Inc · Portland, ORN761FEFederal Express Corporation · Memphis, TNN762FEFederal Express Corp · Memphis, TNN763FEFederal Express Corporation · Memphis, TNN7644SIslander Holdings Ltd · Ft Lauderdale, FLN765FEFederal Express Corporation · Memphis, TNN767FEFederal Express Corp · Memphis, TNN767TPNuage Holdings LLC · Sioux Falls, SDN768FEFederal Express Corp · Memphis, TNN768SXRentco LLC · Deer Park, TXFirst renewal noticeN769FXFederal Express Corp · Memphis, TNN769JSSpurlock Benjamin · Eugene, ORN76AZHubbard Broadcasting · Saint Paul, MNN76CGCsc Delaware Trust Co Trustee · Wilmington, DEN76DNFastboy Equipment LLC · Beasley, TXN76EXIsland Express Helicopters Inc · Henderson, NVN76FLHelinet Aviation Services LLC · Van Nuys, CAN76GMDodson International Parts Inc · Rantoul, KSN76KAKenmore Air Harbor LLC · Kenmore, WAN76MGCook Brothers Farms LLC · Princeton, KYN76PM2012 Leasing Inc · Saint Paul, MNN76QDynamic Avlease Inc · Bridgewater, VAN770DCRam Aviation LLC · Alexandria, LAN770FEFederal Express Corporation · Memphis, TNN770FLTailwinds Aviation LLC · Wilmington, DEN770VFGuardian Flight LLC · Lewisville, TXN771MGEaglemed LLC · Wichita, KSN772AAPro-Air LLC · Alexandria, LAN772HPWilmington Trust Co Trustee · Wilmington, DEN772JBJsb Aviation LLC · Wichita Falls, TX
Back to AD 2016-05-13