AD 2006-10-21

Registered aircraft · 44,908

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:2006-10-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
  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.

N135KAcord Aviation Co L L C · Chandler, OKBuilt 1967 · S/N TD-691N135LUS Department Of The Interior · Boise, IDBuilt 2016 · S/N CC18-0079N135MAAppel Joshua · Wasilla, AKBuilt 2008 · S/N 3034N135MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496594N135RCCox Steven C · St George, UTBuilt 2003 · S/N 3335N135RJKontz Gary Lee · Canby, MNBuilt 1967 · S/N 31-52N135SSpencer William D · Martinsville, VAS/N 27N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001N135UInter American University Of Puerto Rico · Bayamon, PRBuilt 1997 · S/N 4496015N135WPLager Patrick J · Hollis, NHBuilt 2008 · S/N CC18-0030N1360JLambert Brian · Tahlequah, OKBuilt 1975 · S/N 360N1360TDibrino Ruth G · Hillsboro, ORBuilt 1972 · S/N 28R-7235269N1360WRiggs Aviation LLC · Heath, TXS/N 2641N13612Harry Philip Scott · Asheville, NCBuilt 1976 · S/N 17702443N1361CHuckaby William C Trustee · Loudon, TNBuilt 1977 · S/N 17702712N1361JWilliams Jack G · Wichita, KSBuilt 1975 · S/N 361N1361MLux Aero Operations LLC · Belmont, CABuilt 2005 · S/N 172S9842N1361SHughes Shannon E · Jameson, MOBuilt 1997 · S/N 0074N13621Fowler Gerald · Springfield, MOBuilt 1976 · S/N 17702444N1362JHendrix Aviation Inc · Plantation, FLBuilt 1975 · S/N 362N13647Winn William D · Fallbrook, CABuilt 1976 · S/N 17702447N1364WTriple B Properties Ltd · Aledo, TXS/N 2645N13656Groth Abigail · Oxford, GAS/N 17702448N13667Fuller Air Inc · Wilmington, DEBuilt 1976 · S/N 17702450N1366RParodi Carlos Guillermo · Austin, TXBuilt 1975 · S/N AA5-0766N1367TN1367t LLC · Mount Dora, FLBuilt 1972 · S/N 28R-7235271N1367WSelover Richard D · Colusa, CABuilt 1963 · S/N 2648N13681Davis Jerry L · Rural Retreat, VABuilt 1976 · S/N 17702453N1368PDoan William Terry · Furlong, PABuilt 2019 · S/N 1240N1369Low Country Skyways LLC · Wilmington, DEBuilt 1969 · S/N RLG-316N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454N1369JWalsh Mark · Andover, MABuilt 1975 · S/N 369N1369QAmeriflyers Of Texas Inc · Addison, TXBuilt 2005 · S/N 172S9946N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301N136ACPreacher John R · Jackson, GAS/N 673-92N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004N136CCShelk John Brian · Bend, ORBuilt 2002 · S/N 9953CCN136CPMaule Flight Inc · Moultrie, GABuilt 2002 · S/N 18071CN136DBuckeye Ridge Farm LLC · Vidalia, GABuilt 1978 · S/N 14361N136DCStreamline Aviation LLC · Battlefield, MOBuilt 1982 · S/N 136N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168N136FSale Reported · Broomfield, COSale reportedBuilt 2001 · S/N 60300N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171N136HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9711N136HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21094CN136MMMiller Carl A · Vero Beach, FLBuilt 1993 · S/N 21718N136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 10164N136SMMartens Aerosports LLC · Garden City, NYBuilt 1998 · S/N 066N136TRRv6a136tr LLC · Merrillville, INBuilt 2000 · S/N 34132
Back to AD 2006-10-21