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.
N3059SRatte Clifford H · Gulf Breeze, FLN3059ZHo Chris · Weymouth, MAN3060RArrow N3060r LLC · Sheridan, WYN3060TPalumbo Henry R · Novato, CAN3061RCohns Willie · Elizabethtown, KYN3061TAdventure Lab Aviation LLC · Saint George, UTN3063NConstantinides Chris · Chula Vista, CAN3063RGrant Scott A · Santa Barbara, CAN30640Christianson Cleet M · Enumclaw, WAN3065KBowles William Jr · New Richmond, OHN3065RFlavin Patrick J · Woodbridge, VAN3065ZDreiling Alexander R · Queen Creek, AZN3066KQualitair LLC Trustee · MichelstadtN3066RParker Michael A · Milwaukee, WIN3066ZBate Edward F III · Rhome, TXN3067KLynch Alan J · Auburn, WAN3067RSmith Julia L · Big Bear City, CAN3068QTurbo Arrow IV LLC · Nibley, UTN3068RIsland Aero LLC · Kailua, HIN3069RBean Sheila L · San Antonio, TXN3069YSeufer Trevor Scott · Wrightstown, NJN3070ZGarber Greg · Redmond, ORN3071NBunkie Bird LLC · Tucson, AZN3072RRegistered aircraftN3072XParsons Keir Wurzel D · Naples, IDN3073MRobinson Robert F G · Round Rock, TXN3073RIngraham John W Jr · Redlands, CAN3074RSchwietz Thomas E · Strasburg, VAN3078RKitaguchi Terry S · Stockton, CAN3079RGrace Ryan Aviation LLC · Tomball, TXN3081QInternational Air Services Inc Trustee · Carson City, NVN3084QHibbard Paul A · Mountain Home, IDN3087RCrest Aviation LLC · Palmer, AKN3089RFly Bms LLC · Elkton, SDN3090QLarsen Wayne C · Tremonton, UTN3090RCasper Clarence Jr · Groton, CTN3091TSutton Aircraft Salvalge LLC · Palmer, AKN3092TTango LLC · Quaker Hill, CTN3099RMesserschmidt Brent L · Gainesville, GAN30DWHeffernan Michael James · Wellesley, MAN30JSFixed Wing Holding Co Inc · Pembroke Pines, FLN30LERollins Robert · Gadsden, ALN3100QFly By Nite Aviation LLC · Great Falls, MTN312ABSmith Kenneth R · Senoia, GAN312CNN312cn LLC · Prescott, AZN3131TSilver Express Co Db · Miami, FLN31386S&L Aircraft LLC · Port Trevorton, PAN313EMKjta LLC · Renfrew, PAN31401Fox Flying Club Inc · Wheaton, ILN314LTJacobelli Raphael P · Norwalk, CT
Back to AD 82-06-11 R1