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.
N314PWJ&S Corley LLC · Peoria, AZN31604Sun Mountain Flying LLC · Cody, WYN3161TKoester Carsten · San Jose, CAN31649Runway Hero LLC · Wayland, MAN31694Rey Al · Burlington, NCN316EFLibra Air Inc · Las Vegas, NVN316XKinney Shawn M · Camp Verde, AZN31734Oscar Air LLC · Bethlehem, PAN317NCField Daniel James · Bloomfield, CTN31870Flight Level Aviators LLC · Glendale, AZN3189QBoll Weevil Flyers LLC · Reedville, VAN31906Bosveld Bobby J · Markesan, WIN31930Patrick Juan Hughes · Hernando, FLN31950Kasparie Ronald · Quincy, ILN31970Benefield John H Jr · Cedartown, GAN31994Montrose Douglas K · Glen Ellyn, ILN31TLT M L Aircraft Inc · Narrowsburg, NYN31VUJav Enterprises LLC · Broomfield, CON32020N32020 LLC · Springfield, MON32047Sat Aircraft LLC · Clermont, FLN32129Weaver Arnold G · Sandusky, MIN3216QSoma 1953 LLC · Arcadia, FLN32172International Aviation Group LLC · Lake Wales, FLN32196Overstreet Bradley · Greenville, SCN321CNInternational Air Services Inc Trustee · Carson City, NVN32294Cloud Dancer Aviation Inc · Deland, FLN322SSJohnson Robert Wayne · Lebanon, TNN32344Cunningham James L · Oshkosh, WIN32357Malone Bernard G · Frenchtown, NJN32379Erkert Jason A · Phoenix, AZN32393Mcnamee James R · Cocoa, FLN323BGElectric Cowboy Aviation LLC · Okeechobee, FLN323CCBarrett James P · North Little Rock, ARN323MGRstv Inc · Dubuque, IAN323TMElliott Properties-Series 4 LLC · Washoe Valley, NVN32427Mcfadden Robert K · Port Orange, FLN32444Jtz Aviation LLC · Wilmington, DEN32469Dufresne Justin Barth · Temple City, CAN32481Flyboy Fantasy Inc · South Lake Tahoe, CAN32483Showah Jason M · Brentwood, TNN32492Doyle Dylan D · Cerrillos, NMN32521Proflite Of Alaska LLC · Fairbanks, AKN32524Barth Tom L · Manhattan, KSN32552Garys Fork Auto Service LLC · Hydes, MDN3256QManzella Aviation LLC · Brandon, FLN32613Gray Matthew C · Enterprise, ALN32622Region Flyers LLC · Valparaiso, INN32665White Richard L Trustee · Los Altos, CAN32680Neumann Peter G · Cape Coral, FLN32693Oconner Brian E · Santa Cruz, CA
Back to AD 82-06-11 R1