AD 2016-15-05
Registered aircraft · 588
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-15-05')
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-15-05')
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-15-05') 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-15-05') 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.
N353BLBank Of Utah Trustee · Salt Lake City, UTN353WWBramac LLC · Denver, CON355MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN356LGRegistered aircraftN358DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN35KVMit Oregon LLC · Portland, ORN360FCNbftm LLC · Saint Paul, MNN360GBHanging Valley Aviation LLC · Green Bay, WIN360MAir4 Aviation LLC · Houston, TXN361DDWeco West LLC · Catarina, TXN365AGAga Holdings LLC · Waterford, MIN365LTProductivity Advantage Inc · Mosinee, WIN370MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN3712CF900ex LLC · Minneapolis, MNN372EXReal Estate Services International LLC · Conshohocken, PAN373EFEmpirical Foods Inc · Dakota Dunes, SDN373RSKalamazoo Group II LLC · Kalamazoo, MIN374RVLmrv Falcon LLC · Phoenix, AZN375GKKs Air 3-7-12 V LLC · Charlotte, NCN376SFSmithfield Packaged Meats Corp · Smithfield, VAN377AGCrest Operations LLC · Pineville, LAN37DFWillamette Flight Management LLC · Mcminnville, ORN37EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN38015Registered aircraftN380FJAviation Resource Group Inc · Fort Lauderdale, FLN382KUMaverick Aire LLC · New Castle, CON387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN388FJKey Corp · Cleveland, OHN38CPRegistered aircraftN39NPWilmington Trust Co Trustee · Wilmington, DEN400THDuke Vacation LLC · Wilmington, DEN401GJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404FWcf Aircraft LLC · Detroit, MIN405DDillon Aviation LLC · Detroit, MIN405EKArlington Aircraft Of Nevada LLC · Sun Lakes, AZN408LSJokyal LLC · White Plains, NYN40LBFirst Premier Corp · Sioux Falls, SDN40NSf1 Holdings LLC · Darien, CTN412ECBank Of Utah Trustee · Salt Lake City, UTN413CGRegistered aircraftN416KCSpenaero Lc · Salt Lake City, UTN419DFSwitch Ltd · Las Vegas, NVN41MBRivers Equipment LLC · Nashville, TNN420PDKms Air LLC · West Bend, WIN421SCStryker Corp · Portage, MIN422FJHca Squared LLC · Nashville, TNN424UAeronavis LLC · Wilmington, DEN425RJFant Aircraft Enterprises LLC · Houston, TXN427MJ427mj LLC · Hazel Crest, ILN428DRMaverick Air II LLC · Deer Park, WA
Back to AD 2016-15-05