AD 2016-19-13
Registered aircraft · 959
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-19-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-19-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-19-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-19-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.
N460SJDarby Holdings II LLC · Baltimore, MDN465RDMagnum 465rd LLC · Las Vegas, NVN466JCBank Of Utah Trustee · Salt Lake City, UTN468AMAmc 50 LLC · Chicago, ILN469SSDeez-Nuts LLC · Goodlettsville, TNN46ERegistered aircraftN46FRegistered aircraftN46HADjt Equipment LLC · Cocoa Beach, FLN46HBSunshining Aviation LLC · Wilmington, DEN46RBaci LLC · Portland, ORN470MKBank Of Utah Trustee · Salt Lake City, UTN472KChoice Hotels International Services Corp · Rockville, MDN47EGWing And Rotor Transportation Holdings LLC · Morristown, NJN47VWG 137 LLC · Wilmington, DEN480ECRegistered aircraftN482ECConstellation Energy Generation LLC · New Castle, DEN483CMAircraft Trustee Services Inc Trustee · Dover, DEN483ECRegistered aircraftN4840WGolden Ben Air LLC · Nashville, TNN484ECConstellation Energy Generation LLC · New Castle, DEN484FMV1vr LLC · Wilmington, DEN488GBHanging Valley Aviation LLC · Green Bay, WIN488MHSmyrna Ready Mix Concrete LLC · Nashville, TNN48CGCorning Inc · Corning, NYN48FBWkc Corp · St Louis, MON48KZN48kz LLC · Long Beach, CAN48MFAm Specialty Insurance Co · Dallas, TXN48RRBase III Falcon LLC · Oklahoma City, OKN491NIndium Corporation Of America · Clinton, NYN493CFShamrock Air LLC · Baltimore, MDN499MHHollingshead Aviation Services LLC · Murfreesboro, TNN49HTPnc Bank Na · Boise, IDN4BAMonte Carlo Associates LLC · Santa Ana, CAN4DFCds Equipment LLC · Cincinnati, OHN4FCFinco Aviation LLC · Sandy, UTN4HDRegistered aircraftN4SM4sm LLC · West Palm Beach, FLN4TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4WCMid-Atlantic Aviation IV LLC · St Petersburg, FLN500BLBnb LLC · Wilmington, DEN500CFPool Plane LLC · Seattle, WAN500FJGood Bus LLC · Midland, TXN500JJUltimate Human Aviation LLC · Coconut Grove, FLN500LY1380 Jets LLC · Pittsfield, MAN500MAAndretti Autosport Aviation LLC · Fort Lauderdale, FLN500RHHms Holdings LLC · Charlotte, NCN500WAWestern Aviation LLC · Fort Worth, TXN501KLKl Air LLC · Mooresville, NCN501MMN501mm LLC · North Little Rock, ARN501NSoinair LLC · Beavercreek, OH
Back to AD 2016-19-13