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.
N66MSInternational Air Services Inc Trustee · Carson City, NVN670XBank Of Utah Trustee · Salt Lake City, UTN671CMElite Air Solutions LLC · Decatur, GAN673CTCentral Texas College · Killeen, TXN674CTCentral Texas College · Killeen, TXN674DTMiller Jeffrey Dale · Brookhaven, GAN675LBOmalley Kevin S · Cordova, MDN679XChagres Aero LLC · Albuquerque, NMN6808JHot Seat Aviation · Blacksburg, VAN6828JKdrd Holdings LLC · Texas City, TXN6849JSecker David A · San Jose, CAFirst renewal noticeN6857JSkyward3 LLC · Kalispell, MTN6862JTraut Joseph W · Sharon, MAN686QPZero2knots Aviation LLC · Canal Winchester, OHN6871JRyan Air Ventures LLC · Auburn, GAN6878JLake Stephen · Geary, OKN687BHTrmg Consulting Services LLC · Edison, NJN687TJMirarchi Joseph F · New Braunfels, TXN688BGJones William E · Birmingham, ALN688TBBiggar Stephen R · Jackson, NJN68CNEichten Steve G · Colleyville, TXN68GFJcp Equipment LLC · Brainerd, MNN68JALost Aviators LLC · Durant, OKN6905JDouble Delta Sierra LLC · Bristol, CTN6911WSwanson Naomi L · Dalton, GAN6919RSouthern Aircraft Consultancy Inc Trustee · Casper, WYN691JInternational Air Services Inc Trustee · Carson City, NVN691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledN6932JRamonetta Vince · Westbrook, CTN6944JJhap LLC · Hubbard, OHN6948C48 Charlie LLC · Columbia, MDN694ACNaiman Harold E · Denver, CON6952CSnoz Inc · Sharon, MAN6952JLagimoniere Gregory · Jacksonville Beach, FLN6973JStracener Adam · Pittsburg, TXN697FTSilvey Michael Duane · Newhall, CAN697LBMtt Aviation Services Inc · Johnstown, PAN6983JLaid Back Investment Holdings LLC · Cairo, GAN6995CDetert Bradley · Valparaiso, INN6998NPacifica LLC · Grand Junction, CON6999JSun West Aviation Inc · Santa Ynez, CAN69GSDaphnee Moise Md Pa · Sarasota, FLN69MWOlson James H · Eleva, WIN69PAWanagel Joshua · Berwyn, PAN69RSBerry Brian R · Tahlequah, OKN6ECDraco Flight School Inc · Chino, CAN7000XWalsh Peter F · Walpole, MAN701CAMkc Aviation LLC · St George, UTN701DCBlack Cat Aviation LLC · Indianapolis, INN701EAPratt Thomas · Muncie, IN
Back to AD 82-06-11 R1