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.
N7770DJenkins Robert H · Kill Devil Hills, NCN777CD777cd LLC · Rochester, MNN777FGMarks Robert L · Ramona, CAN777JDFwm Aviation Inc · Washington, DCN777MDMateusz Dziuda · CambridgeN779AKJust Plane Partners LLC · Yorba Linda, CAN77AHPate Steven H · El Paso, TXN77ENEuroaviation Inc Trustee · KemtenN77LZO'Quinn Debbie M · Jesup, GAN77PMSokrispymedia LLC · Greenville, SCN77RCN77rc LLC · Wilmington, DEN77WESteven Paul Joyner · Austin, TXN780FMIolaire Aviation Inc · Wilmington, DEN781WWMattson William W · Telluride, CON7824CRegistered aircraftN7842FIso Art Ltd · Hamilton, MTN784ASDe Paola Humerto J · Pembroke Pines, FLN786BGGross Kyle F · Salt Lake City, UTN787BGWestchester Flying Club Inc · Purchase, NYN78DJKing David V · Mars, PAN78QBPandion Aviation LLC · West Chester, PAN78WARtd Aviation LLC · Hillsborough, NJN7903CHocking Valley Flying Club Inc · Hebron, OHN7935CRfc Inc · Hiawatha, IAN7954JSouthern Aircraft Consultancy Inc Trustee · Casper, WYN799JHInternational Air Services Inc Trustee · Carson City, NVN79AFBritsch Uwe K · Klamath Falls, ORN79HKHughes Theodore · Maryville, TNN79UReichert John · Port Orange, FLN79VM3 Itg Aviation LLC · Allentown, NJN7JJKarmel Moshe · Aventura, FLN7MEAzary Zoltan D · Occidental, CAN7SKhashimkhodjaev Rustam · Parker, CON7VBDeeb Inc · Port Richey, FLN80018Schurenstedt Carl R · Vail, CON8004MEuroaviation Inc · KematenN80339Green Robert H · Lakewood, CAN8056BChandler Air Service Inc · Chandler, AZN8065CArrow Air LLC · Sioux Center, IAN806BBNoyes Jimmy D · Fruitland, IDN806NDMob Aviation USA LLC · Auburndale, FLN8072HDuncan Anthony · Princeton, NJN8075HMoore David S · Shrewsbury, MAN8075MKrull Benson D · West Richland, WAN8075QG-Force Aviation LLC · Surprise, AZN807MSGilbert Allyn E · Grass Valley, CAN8080UMaas Justin J · Columbus, INN8085ZJli Partners Inc · Miami, FLN8086RColburn Richard S · Fort Mohave, AZN8089BBader Bradley C · Monroe, WI
Back to AD 82-06-11 R1