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.
N724LA464c59 LLC · Santa Monica, CAN725SANaples Air Center Inc · Naples, FLN729PAK2 Aviation LLC · Greenwood Village, CON730PCDs Altitude Alliance LLC · Eastpoint, FLN737AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN737LADa40 Club LLC · Atkinson, NEN738LAElizabeth City State University · Elizabeth City, NCN741LAWilcrest Asset Group LLC · Austin, TXN748LABhe Enterprises LLC · Leesburg, VAN755LAJetnexa Four LLC · Gilbert, AZN756PASteelhawk Aviation Inc · Lake Mary, FLN757MNPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN761PSDiamond Aircraft Sales USA Inc · London OntarioN767AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN769LLift Aircraft LLC · Carmel, INN779RARight Attitude Aviators LLC · Bella Collina, FLN781PSAero Acre One LLC · Belmont, NHN786KMMyflight Three LLC · Lake Mary, FLN787AMSeabreeze Mc LLC · East Islip, NYN787AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN787LBTalespin Expeditions LLC · Highland Beach, FLN787MFPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN787SYYing Susan X · Cottonwood, AZN787WSWoa Aviation Inc Trustee · Wilmington, DEN78PACharter Pro Services LLC · Naples, FLN790EREmbry Riddle Aeronautical University Inc · Prescott, AZN791EREmbry-Riddle Aeronautical University Inc · Prescott, AZN792EREmbry-Riddle Aeronautical University Inc · Prescott, AZN793EREmbry-Riddle Aeronautical University Inc · Prescott, AZN7NGSpeedwash America LLC · Cunningham, KYN805FMCoastal Wings LLC · Torrance, CAN805PAK2 Aviation LLC · Greenwood Village, CON809LLift Aircraft LLC · Carmel, INN810LLift Aircraft LLC · Carmel, INN812LASkydonk LLC · Midlothian, VAN814LLift Aircraft LLC · Carmel, INN817LLift Aircraft LLC · Carmel, INN819LLift Aircraft LLC · Carmel, INN821BREva Flight Training Academy · Mather, CAN822BREva Flight Training Academy · Mather, CAN823BREva Flight Training Academy · Mather, CAN829TDAircraft Guaranty Corp Trustee · Oklahoma City, OKN834LLift Aircraft LLC · Carmel, INN835LLift Aircraft LLC · Carmel, INN8383Aviation Hub Inc Trustee · Cheyenne, WYN842LATribal Aviation LLC · San Carlos, CAN844LATrustline Aviation LLC · Fort Wayne, INN844RHPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN845LAGhai Rikesh L · West Chester, OHN845PASword Aviation LLC · Allen, TX
Back to AD 2016-22-06