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.

N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091N38385Wahl Michael John · Jefferson, IABuilt 1977 · S/N 28R-7703211N383DANew Mexico Flying Eagle Inc · Tucson, AZBuilt 2003 · S/N 2844098N38440Decoria Dustin E · Kennewick, WABuilt 1977 · S/N 28R-7703218N38444Middlebrook Lary · Lakeside, CABuilt 1977 · S/N 28R-7703221N38457Registration Pending · Phoenix, AZRegistration pendingBuilt 1977 · S/N 28R-7737094N38468Emmons Kevin D · Vincennes, INBuilt 1977 · S/N 28R-7703225N38485Duke Kyle N · Laurel, MTS/N 28R-7703226N38486Lone Tree Aero LLC · Lone Tree, COBuilt 1977 · S/N 28R-7703228N38495St Peter Christopher E · San Mateo, CABuilt 1977 · S/N 28R-7703229N384NDJmfb Enterprises LLC · Concord, NCBuilt 2003 · S/N 2844095N38538Jurecka Joseph W · Lubbock, TXBuilt 1977 · S/N 28R-7703237N38539Sale Reported · KyivSale reportedBuilt 1977 · S/N 28R-7703238N38555Grimm Chris · Burlington, IABuilt 1977 · S/N 28R-7703239N38557Bowyer Ronald D · Keene, TXBuilt 1977 · S/N 28R-7703242N38564Ck Leasing Services LLC · Wilmington, DEBuilt 1977 · S/N 28R-7737097N38565Olson Michael S · Ellsworth, KSFirst renewal noticeBuilt 1977 · S/N 28R-7737098N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100N38594Vineyard David D Md · South Lake, TXBuilt 1977 · S/N 28R-7703249N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102N38610Whiskey Tango Foxtrot Aviation LLC · Broomfield, COS/N 28R-7703252N38632Tappan Michael L · Miamisburg, OHBuilt 1977 · S/N 28R-7737103N38636Fre Investments LLC · Enterprise, ALBuilt 1977 · S/N 28R-7703253N38639Mccullough Peter Lee · Doylestown, PABuilt 1977 · S/N 28R-7703255N38655Wensmann Joel · Sartell, MNBuilt 1977 · S/N 28R-7737105N38664Aerostyles LLC · Colorado Springs, COS/N 28R-7703259N38701Sefton James Patrick · Carolina Beach, NCBuilt 1977 · S/N 28R-7703260N38703Ollieboy Productions LLC · Kalispell, MTBuilt 1977 · S/N 28R-7703261N38716Spartan Aviation Group LLC · Williamsburg, VABuilt 1977 · S/N 28R-7737109N38717Meiller Richard S · Kill Devil Hills, NCBuilt 1977 · S/N 28R-7737110N38718Vgw LLC · Morgantown, WVBuilt 1977 · S/N 28R-7737111N38720Arrow N38720 LLC · West Des Moines, IABuilt 1977 · S/N 28R-7703264N3873MMorris Air LLC · Hopkinsville, KYBuilt 1978 · S/N 28R-7803198N38741Hoyda Jeffrey A · Tiffin, OHBuilt 1977 · S/N 28R-7703267N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117N38776Warnock Air LLC · Eagle, IDBuilt 1977 · S/N 28R-7703274N38791Gehl Timothy E · Houston, TXBuilt 1977 · S/N 28R-7703276N38792Tysdan Aviation LLC · Lake Worth, FLBuilt 1977 · S/N 28R-7703277N38793Siegfried Todd · Brentwood, CABuilt 1977 · S/N 28R-7703278N38871Arrow Blue N38871 LLC · Turpin, OKBuilt 1977 · S/N 28R-7703281N38875Landau Victor M · Lake City, FLBuilt 1977 · S/N 28R-7703282N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123N38944Lewis David A · Fairfield, CAFirst renewal noticeBuilt 1977 · S/N 28R-7703284N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376N38981Kreck Blake T · Terrell, TXBuilt 1977 · S/N 28R-7703290N38991Jaquez Francisco P · Corona, NYBuilt 1977 · S/N 28R-7703291N38995Baxter Donald J · Dallas, TXBuilt 1977 · S/N 28R-7703292
Back to AD 82-06-11 R1