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.
N4549TReinemer Rno Philip II · Carthage, TXN4551XLewis Michael A · Alexandria, VAN4552QGrand Air LLC · Granby, CON4555FRegistered aircraftN4555TJb Aviation LLC · Mason City, IAN4559XJlp Flying LLC · Clewiston, FLN4562XVenture West LLC · Mesa, AZN4564FStern Aviation Inc · N Fort Myers, FLN4565TSchendel Daryl R · Barstow, CAN4566XZihala William · North Little Rock, ARN456RRAir America Flight Center LLC · Daytona Beach, FLN456WPrez Carl · San Antonio, TXN4576XElon Aviation LLC · Burlington, NCN4578TMeditz Robert S · Chalfont, PAN4579TNavajo Air LLC · Scottsdale, AZN4583TKeppers Richard W · Alexandria, VAN4586XMccardle Michael L · Houston, TXN4590TOdonald John C · Greenville, MIN4594XAdventure Ventures LLC · Salem, CTN4597TArsenault Ronald L Jr · Newton, ALN459KMCumulus International Corp · Wilmington, DEN460KKBeard Merwin R · Houston, TXN463RNDave Aviation LLC · Naperville, ILN4641FCrosswinds Flying Club Inc · Bloomington, ILN4665FManzani Kelly · Temecula, CAN468PMEarspasm LLC · Brooklyn, NYN46UTVon Schmidt Gordon D · Waretown, NJN4711YAerospace Trust Management LLC Trustee · Wilmington, DEN47227N47227 Inc · Hobe Sound, FLN47228Sg Holdings LLC · Grand Mound, IAN47337Beatty William Keith · Lakeland, FLN47339Grider Aviation Inc · Indianapolis, INN47359Mcilquham Roderick L · Bolingbrook, ILN47361Magpie Inc · Rock Springs, WYN47416Jarriel Investments Inc · Register, GAN47418Billings Chris · Duncan, OKN47419Capp Kevin C · Boswell, PAN47442Registration Pending · Columbus, NERegistration pendingN47445Premier Capital Enterprises LLC · Hurricane, UTN47459Thompson James David · Newborn, GAN47471Piper N47471 LLC · Granby, CON47484Sugarbaker Stephen J · Rocklin, CAN47494Valiair Lc Trustee · Casper, WYN47497Alpha Arrow Flying LLC · Iowa City, IAN47498Strobel John D · Baltimore, MDN47514Groves William K · Faith, SDN47546Robnett Theodore J · Central Point, ORN47551E2 Ventures Inc · Pinehurst, NCN47589Radke John A · Cedar Falls, IAN47605Lovaas Darryl G Trustee · Crescent City, CA
Back to AD 82-06-11 R1