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.
N501JVJetvue Texas LLC · Richardson, TXN501RBLone Star Land & Cattle Co · Houston, TXN509CQBwp Aviation LLC · Nashville, TNN50BHTravel Link LLC · Vienna, VAN50LKTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTN510FROneflight International Inc · Englewood, CON510MGSuperior Transportation Associates Inc · Costa Mesa, CAN510SPKitty Hawk LLC · Fort Worth, TXN511KA1111 Giv LLC · Downey, CAN512CCCd 357 LLC · Austin, TXN513LSSpec Air LLC · Saint Petersburg, FLN515RAA & E Hawker Lp · Santa Ana, CAN516MCPjk Aviation LLC · Great Neck, NYN519NHStratus Air LLC · Alpharetta, GAN51PRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN520NANasa Langley Research Center · Hampton, VAN522VRBank Of Utah Trustee · Salt Lake City, UTN527DDK&A Advisors LLC Trustee · Wilmington, DEN527JCGiv Exec Jet LLC · Ithaca, NYN535JMWhiskey Uniform LLC · Wichita Falls, TXN53KWWiley Bob Inc Trustee · Troy, ALN53WGAlliance Aviation Group LLC · Lawrence, KSN540EALastra Air Cargo Express · Saint Petersburg, FLN550JFTs Aviation LLC · New York, NYN551CBModern Industrial Services Inc · Beaumont, TXN554SLStewart Aviation Services LLC · Birmingham, ALN555DWInstitue Of Aeronautical And Aerospace Institute · Aguadilla, PRN557GGArmo Aviation LLC · Los Angeles, CAN559LCOlympia Aviation LLC · Detroit, MIN55TDLandlocked Company LLC · Dover, DEN565RVCsc Delaware Trust Co Trustee · Wilmington, DEN5689TT2 Aviation LLC · Sheridan, WYN56LK2 Investment Fund LLC · Zephyr Cove, NVN570DCWebster Air LLC · Houston, TXN583AJKot Aviation LLC · Brea, CAN584ERMsp Recovery Aviation LLC · Miami, FLN58JEKamali Aviation LLC · Great Neck, NYN592RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN5GFSdl Gulfstream LLC · Wilmington, DEN5MCGeorgetown Interstate Aviation Inc · Santa Barbara, CAN600CKNb Airlines LLC · Miami, FLN604JMRegistered aircraftN605RASmb G-IV Vii LLC · Longwood, FLN606MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN606PSWorldwide Option LLC · Lewes, DEN607SBPerfect Agreements Leasing Inc · Trabuco Canyon, CAN608BGN A S A Lyndon B Johnson Space Center · Houston, TXN608LHAsturias Air Services Inc · Miami, FLN60GGSuperior Transportation Associates Inc · Costa Mesa, CAN60LDRegistered aircraft
Back to AD 2016-20-06