AD 2016-20-06
Registered aircraft · 453
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-20-06')
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-20-06')
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-20-06') 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-20-06') 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.
N757MCSmtv Ontario LLC · San Diego, CAN763DBTrans Exec Air Service Inc · Van Nuys, CAN765RMBd Giv 2 LLC · New York, NYN769MMBank Of Utah Trustee · Salt Lake City, UTN76EJValiair Lc Trustee · Casper, WYN770KSBest Aircraft Deals LLC · Salt Lake City, UTN774MBVida Trade And Management Group · Charlotte, NCN7799TSn 1474 LLC · Wilmington, DEN779LCTulsa Technology Center School District No 18 · Tulsa, OKN779LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN77FKOcean Aviation 26 LLC · Great Neck, NYN789TNNorth Bristol Partners LLC · Santa Monica, CAN78AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN78ETSteven Brothers Aviation LLC · Wichita, KSN7DKAerotrust Services Corp Trustee · Wilmington, DEN800ARPerpetual Aviation LLC · Arlington, VAN800BHHabib Aviation LLC · West Palm Beach, FLN804NANasa Neil A Armstrong Flight Research Center · Edwards, CAFirst renewal noticeN805FTG4sp Blackbox Holdings LLC · North Palm Beach, FLN808CFBoss 8 LLC · Fort Worth, TXN808MFCd 321 LLC · Cypress, TXN808NANasa Neil A Armstrong Flight Research Center · Edwards, CAN80QJRegistered aircraftN810TMNomad Air LLC · Dover, DEN814NANasa Neil A Armstrong Flight Research Center · Edwards, CAN815DTAviation Development Group LLC · Kalispell, MTN816SPJmd Aviation LLC · Jupiter, FLN818MECape Clear LLC · Westboro, MAN818VBPhoenix Air Group Inc · Cartersville, GAN819VDAdams Aviation Services Inc Owner Trustee · Wilmington, DEN825CPPilgrim Air 2 LLC · Van Nuys, CAN826RPTbf Group Aviation LLC · Great Neck, NYN827GAPpg Industries Inc · West Mifflin, PAN828AHAircraft Holding Solutions LLC Trustee · Newark, DEN840ERTikchik LLC · Anchorage, AKN842PAValiair Ltd Co Trustee · Casper, WYN850RTFlying Owl Aviation LLC · Lewisville, TXN852SPStephens Pipe & Steel LLC · Jamestown, KYN857PRTravel Link LLC · Vienna, VAN857STSeminole Tribe Of Florida · Hollywood, FLN85GC4lions LLC · Chula Vista, CAN85WDAerovision-Logos Aircraft Holdings Vii Corp · Dover, DEN869MDEmo Systems LLC · Wilton Manors, FLN869SCPerennial Investments Inc · Anaheim, CAN86MSAb Jet Co II LLC · Metairie, LAN874CTrans-Exec Air Service Inc · Van Nuys, CAN876GLGlj Aviation LLC · Pompano Beach, FLN877AAircraft Holding Solutions LLC Trustee · Newark, DEN877LCLetica Leasing LLC · Rochester Hills, MIN878SMWorld Heir Inc · College Park, GA
Back to AD 2016-20-06