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.
N701RALaith Aviation LLC · Goose Creek, SCN7044CPappas Tevis · Atlanta, TXN705WHSky Craft LLC · Powell, OHN70EF720 Degrees Inc · Santa Monica, CAN70MHN70mh LLC · Wilmington, DEN711ABL J S Enterprises Inc · Albany, TXN711CVSmtm Holdings Inc · Wilmington, DEN711TYTas Technical Consulting Inc · Schaumburg, ILN7194CCivil Air Support LLC · Phoenix, AZN71DSSchauer Donald Glen · Minden, NVN71EFSandercock Mark L · Pewaukee, WIN720GCCox Gary E · Davis, CAN722WMPegasus Enterprises LLC · Granbury, TXN7271CChesley James Philip · Mesa, AZN727HALinfield Steven J · Westminster, MDN727HSSandstar Aviation LLC · Lewes, DEN727PGDowns Donald S · Lake City, FLN7284CSeed Richard J IV · Wicomico Church, VAN72MHQuasar Aircraft Corp · Jacksonville, FLN72SJCoghlan Douglas G · Salem, SCN730XSbh Alliance LLC · Sauk Rapids, MNN734TNConsolidated Aviation Services LLC · Seymour, TNN743EDAir Adventure LLC · Sheridan, WYN745ATLysenko Aleksandr D · Medford, NJN746BCentral Arkansas Flying Club Inc · Bryant, ARN749CSBower John M · Santa Cruz, CAN75046Esson Michael · Durand, MIN75050Delaware State University · Dover, DEN75127Amob 2 LLC · Baton Rouge, LAN75152Gibb John R · Ellensburg, WAN75153Island Aviation Management LLC · Daytona Beach, FLN75182Donkel Douglas L · Hillsboro, ORN751KSWarstler Michael · Dayton, OHN75278Jmo Aviation LLC · Oakland, CAN75293N75293 LLC · Pembroke Pines, FLN752KSTaffet Jay · New Orleans, LAN75340High Point Aviation LLC · Spencerport, NYN75386Three Piloteers LLC · Bloomington, INN753KSCoastal Alabama Aviators LLC · Daphne, ALN7599CHurd Air LLC · Sioux Falls, SDN7627DVanhouse Daniel W · Topeka, KSN762MBlaisdell Frederick C · Anderson, CAN765CBJillco Enterprises Inc · Wilmington, DEN7674CFiyalko Wayne · Fort Myers, FLN769JHorn Warren B · Athens, GAN771PTPilot Training Center LLC · Miami, FLN772FTJazz Air LLC · Melbourne, FLN7736CSt Pete Aviation Services LLC · Saint Petersburg, FLN773FTRatte David R · W Melbourne, FLN774LRCampbell Jeffrey R · Surprise, AZ
Back to AD 82-06-11 R1