AD 2016-22-06
Registered aircraft · 467
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-22-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-22-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-22-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-22-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.
N323EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN324EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN324PSDial-Up Media LLC · Ladera Ranch, CAN327EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN327PSRockhill Group Inc · Molino, FLN328EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN328WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN329EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN332AFAspen Higher Learning Flight Academy Inc · Aspen, CON334PAArapahoe 1880 LLC · Orlando, FLN334WBTdt Marketing LLC · Queen Creek, AZN335PSRockhill Group Inc · Molino, FLN336WBBlue World Aviation LLC · Woodbury, MNN336XAJetnexa Six LLC · Gilbert, AZN337XAJetnexa Seven LLC · Gilbert, AZN338WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN338XAJetnexa Eight LLC · Gilbert, AZN339XAJetnexa Nine LLC · Gilbert, AZN342NDCirrus Aviation Inc · Sarasota, FLN342TDirect Capital Holdings LLC · Colorado Springs, CON3434Aviation Hub Inc Trustee · Cheyenne, WYN351LLift Aircraft LLC · Carmel, INN361BZFlying Molly LLC · Midland, TXN362PSOmnia Investing LLC · Orlando, FLN3652TAir Born Legacy LLC · Manlius, NYN366LLift Aircraft LLC · Carmel, INN367LLift Aircraft LLC · Carmel, INN368LLift Aircraft LLC · Carmel, INN36PSRivercity Air LLC · Hawkinsville, GAN374AWUnited States Air Force · Apo, APN374YJUnited States Air Force · Apo, APN375PADa40 LLC · Myrtle Beach, SCN37TLPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN383MFPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN385LBrickyard Connection LLC · Indianapolis, INN386LLift Aircraft LLC · Carmel, INN387LLift Aircraft LLC · Carmel, INN387LAMaverick Aviation LLC · Sheridan, WYN388LLynx Connection LLC · Indianapolis, INN388LARashleigh Holdings LLC · Savannah, GAN389LLift Aircraft LLC · Carmel, INN390LLift Aircraft LLC · Carmel, INN390LASce Aviation LLC · Reddick, FLN391LLift Aircraft LLC · Carmel, INN392LBrickyard Connection LLC · Indianapolis, INN399SKAlf Ix LLC · Chicago, ILN39AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN400NGInternational Air Services Inc Trustee · Carson City, NVN403BLJb Flight Services LLC · Carlsbad, NMN406BLVonaviation Group III N406bl LLC · Lewes, DE
Back to AD 2016-22-06