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.
N592AEKilo Alpha Group LLC · Fayetteville, ARN5935Ponderosa Airtankers LLC · Safford, AZN593GGCircle S Air LLC · Wilmington, DEN594MWBank Of Utah Trustee · Salt Lake City, UTN594WAFifth Direct Air LLC · Polson, MTN597PGuardian Flight LLC · Lewisville, TXN599CZN599cz LLC · Milwaukee, WIN59AGUnited States Government · Fort Belvoir, VAN59EHSale Reported · Dawsonville, GASale reported, pending cancellationN59MDynamic Avlease Inc · Bridgewater, VAN59WFLes Chardons Inc Trustee · Wilmington, DEN5HTHigh Calling LLC · Golden, CON5PPVerplowens Aviation LLC · Steamboat Springs, CON5XMMiddle Tennessee State University · Murfreesboro, TNN6000JAndy Riddell Flying Service Inc · Marvell, ARN6002HTumbleweed Leasing LLC · Tacoma, WAN6002TH & C Consulting LLC · Wilmington, DEN6003GPrecision Ag Air LLC · East Prairie, MON6005RAufderheide Flying Service Inc · Dewitt, ARN6007SAaa Flying LLC · Tillar, ARN600EVLfw Investments LLC · Hillsborough, NCN600HMFarm And Harvest Machinery LLC · Del Mar, CAN600KSPlane Fun Inc Tr Trustee · Snellville, GAN600NCOdac LLC · Colorado Springs, CON600WRBell Aire LLC · Mesa, AZN6011CAero Applications Inc · Burley, IDN6014SReabe Spraying Service Inc · Plover, WIN6017EGeorges Aerial Spraying Service Inc · Sutton, NEN60255Big Wings Ag Inc · Delavan, MNN6027Agri Tech Aviation Inc · Indianola, IAN60282American Ag Aviation Inc · Five Points, CAN602AADickson Shannon · Plains, KSN602AFMile High Aviation Inc · Estes Park, CON602AGGarrett & Smith Aviation LLC · Prattville, ALN602APPrecision Air Of Franklin LLC · Gilbert, LAN602AWMile High Aviation Inc · Estes Park, CON602BAScott Kyle J DBA · Fort Morgan, CON602BEHolly Grove Flying Service Inc · Holly Grove, ARN602BFWoods Aviation LLC · Kearney, NEN602BKBunkie Flying Service Inc · Bunkie, LAN602BLCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN602BWNorthstar Aerospray Inc · Clara City, MNN602CCWooten Jason · Dimmitt, TXN602CMBank Of Utah Trustee · Salt Lake City, UTN602CRLittle Gator Aviation Inc · Fairfield, NCN602DAWoodline Aviation LLC · Memphis, MON602DMAero Applicators · Sterling, CON602DNWoodley Aerial Leasing LLC · Walnut, ILN602EWSunrise Dusters Inc · Robbins, CAN602FAA+ Aviation Services LLC · Goodland, KS
Back to AD 2016-05-13