AD 82-06-11 R1
Registered aircraft · 2,375
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:82-06-11-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-06-11-R1')
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:82-06-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-06-11-R1') 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.
N2911WAdduci Alexander Lewis · Trevor, WIN2914RLandrith Robert L · Mustang, OKN2917RCzarnecki Neil A · Racine, WIN2918BMorris Robert B · Billings, MTN2919QRobert D Grace LLC · Amarillo, TXN2919UFrix Richardd · Bluffdale, UTN291MCGonzalez Joseph III · Saginaw, TXN2921RZiegler James F · Darwin, MNN2922YBeckstrand John James Wendell · Eagan, MNN29247Bas Part Sales LLC · Greeley, CON2924MJones Joshua D · Gallatin Gateway, MTN2925NClausen Steven L · Hallam, NEN2925RSpeedbird Aviation Alpha Charlie LLC · Glenn Heights, TXN2927MCooney Francis M · Sunriver, ORN2927QWifa (Washington International Flight Acad) LLC · Gaithersburg, MDN29305Mbs Aircraft Inc · Saginaw, MIN2930RSouthern Warriors International Inc · Port Saint Lucie, FLN29310Talbert James D · Alamogordo, NMN2931MNsain Flight Ops LLC · Fort Worth, TXN2936NTailwinds Aviation LLC · Crystal Lake, ILN2937BHaas Terry D · New Tripoli, PAN2939NPiper Aircraft Inc · Vero Beach, FLN293FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN293MGGeorgia Aviation Authority · Eastman, GAN2940QSkyhawk Flying Club Inc · Omaha, NEN2940RRespass Keith D · Bluffton, SCN2943DSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2943YMatana Aviation Group LLC · Bradenton, FLN2945RHuestis Gary M · Blackfoot, IDN294FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN2950RRebecca Aviatrix LLC · Columbus, INN2952RTowers Roland M · Shady Shores, TXN2953QW-Wingmen LLC · Simi Valley, CAN2954QClark Ronald Joe · Scottsdale, AZN29566International Air Services Inc Trustee · Carson City, NVN295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN2960LLucas Danny O · Ridgeland, SCN2962RHurn Enterpises LLC · Grand Beach, MIN2962WB&R Aircraft LLC · Wadsworth, OHN2962YGutierrez Juan · Sarasota, FLN29638Seal Seismic Service LLC · Oklahoma City, OKN2966RTobin Michael A · Plain City, OHN2969ZJwest Aero LLC · Smyrna, DEN296DMDewitt Gary S · Anacortes, WAN296MGGeorgia Aviation Authority · Eastman, GAN2970LCgi Transport Inc · Fullerton, CAN2970RNorwood Norman · Sheridan, WYN2972RDahl Steven B · Medway, MAN2973RQuinones Roland · Mckinney, TXN2977RRegistered aircraft
Back to AD 82-06-11 R1