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.

N43793Casanova LLC · The Plains, VAS/N 28R-7737135N43794Ochoa Luis M · Hollywood, FLBuilt 1977 · S/N 28R-7703314N43798Susong Charles W · Afton, TNBuilt 1977 · S/N 28R-7737130N43817Fraser Roger Douglas · Amelia Island, FLBuilt 1977 · S/N 28R-7737136N4382XN4382x LLC · Tewksbury, MABuilt 1975 · S/N 28R-7635032N43848White David W · New River, AZS/N 28R-7703317N4389XRrg Software LLC · Alpine, CAFirst renewal noticeBuilt 1975 · S/N 28R-7635034N4393TJackson R Allen · Granbury, TXBuilt 1972 · S/N 28R-7235030N4393XGriffin David R · Amarillo, TXBuilt 1975 · S/N 28R-7635035N43966Sims Kenneth Leon · Desert Hot Springs, CAS/N 28R-7737139N43967Jo Air Inc · La Mesa, CABuilt 1977 · S/N 28R-7737140N43970Arrow N43970 LLC · Derry, NHBuilt 1977 · S/N 28R-7703321N43994Harrison Shawn · Salisbury, MDBuilt 1977 · S/N 28R-7703327N43WGMaxfield Kenneth B Trustee · Murray, UTBuilt 1977 · S/N 28R-7703280N4401TMcelroy Shawn · East Falmouth, MABuilt 1972 · S/N 28R-7235026N4406TPollard John R · Melbourne, FLBuilt 1972 · S/N 28R-7235034N44104Reed Matthew · Lander, WYS/N 28R-7435295N44140Helmandollar Steven W · Elkhorn, NEBuilt 1974 · S/N 28R-7435298N4414TRegistration Pending · Rockford, MIRegistration pendingBuilt 1972 · S/N 28R-7235041N44157Gregoire Alexandra Jennifer · Orlando, FLBuilt 1974 · S/N 28R-7435299N441CKWinters John H · Birch Run, MIBuilt 1975 · S/N 28R-7535314N44229Cabelka Jerry L · Glendale, AZBuilt 1974 · S/N 28R-7435301N4422XKeys Andrew S · Harvest, ALBuilt 1975 · S/N 28R-7635038N4424TKoplin Adam · Big Stone City, SDBuilt 1972 · S/N 28R-7235046N44254Bridges D Scott · Paducah, KYBuilt 1974 · S/N 28R-7435304N4428TGauvin Daniel G · Newport, VTBuilt 1972 · S/N 28R-7235047N4428XLeopold Nathan · Fond Du Lac, WIBuilt 1975 · S/N 28R-7635040N442GBas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28R-7703208N44327Big Duke Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 28R-7435306N4434XLusher Frank W II · Prichard, WVBuilt 1975 · S/N 28R-7635041N4437SVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844156N4437WVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844157N44388Zavoda Scott E · Strongsville, OHBuilt 1974 · S/N 28R-7435307N4438DMa Aviation LLC · Danville, ILBuilt 2015 · S/N 2844158N4439XMccormick Robert E · Yakima, WABuilt 1975 · S/N 28R-7635043N4443XFox Two LLC · Camino, CABuilt 1975 · S/N 28R-7635044N44443Jax Navy Flying Club · Jacksonville, FLBuilt 1974 · S/N 28R-7535001N44458Forsman Airways LLC · Glenwood, MNBuilt 1974 · S/N 28R-7435309N444DPStratospheric Ventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 28R-7435167N444HPCrosswind Aviation Inc · Oakley, KSBuilt 1979 · S/N 28R-8031003N444JSIndigo Of South Fl Inc · Sunrise, FLS/N 28R-7703287N444SLD And E Consulting LLC · Taylor, ARBuilt 1973 · S/N 28R-7335111N44521Silker Services LLC · Schaumburg, ILBuilt 1974 · S/N 28R-7435311N4452TUtehin Nick A · San Mateo, CABuilt 1972 · S/N 28R-7235053N4452XAlpha Dairy Chi LLC · Locust Grove, OKBuilt 1975 · S/N 28R-7635048N4455MClear Prop LLC · Roswell, GABuilt 1976 · S/N 28R-7635217N4456XFly By Knight Corp · Shoreview, MNBuilt 1975 · S/N 28R-7635050N44572Hornet Aviation Inc · Tallahassee, FLBuilt 1974 · S/N 28R-7435314N4461TRobinson Joseph B · Washington, DCBuilt 1972 · S/N 28R-7235058N4461XHaggerty James D · Scott Depot, WVBuilt 1975 · S/N 28R-7635051
Back to AD 82-06-11 R1