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.

N19782Herber David · Stanwood, WABuilt 1976 · S/N 17702594N19783Sky Hi Inc · Frederick, MDBuilt 1976 · S/N 17702595N19787Reinhardt Ryan S · Russell, KSBuilt 1976 · S/N 17702596N1978HHarow Peter M · Forked River, NJBuilt 1977 · S/N 28-7790364N1978YMeinert Matthew A · Columbia, MOFirst renewal noticeBuilt 1964 · S/N 265N19793Lopez Vicente · San Juan, PRBuilt 1976 · S/N 17702598N1979GBerardo Frederick Andrew · Redmond, ORBuilt 1978 · S/N AA5B1041N197ATBlue Air Training Corp · Las Vegas, NVBuilt 1974 · S/N 07N197AWO'Steen James D Jr · Laurel, FLS/N 670295N197BALewis University · Romeoville, ILBuilt 1997 · S/N 17280314N197BCSeruset Jeffrey G · Butler, PABuilt 2004 · S/N 461-2004N197DJN197dj LLC · Palm Harbor, FLBuilt 1997 · S/N 32-46074N197DLSchier Del J · Lake City, FLBuilt 2001 · S/N 0586N197HLCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 1386N197LABg Family Limited Partnership · Edinburg, TXBuilt 1997 · S/N 4636098N197MAShore Air LLC · Trappe, MDBuilt 1997 · S/N 4636079N197MCLewis University · Romeoville, ILBuilt 2006 · S/N 172S10197N197MEPremier Air Of Delaware Inc · Flemington, NJBuilt 2000 · S/N 172S8472N197PMRegistered aircraftBuilt 1997 · S/N 4636086N197SATalley Rentals LLC · Hobart, OKFirst renewal noticeBuilt 1963 · S/N 28-1087N197SHSierra Hotel LLC · Gardena, CABuilt 2007 · S/N 4197N197TACoast Aviation LLC · Costa Mesa, CABuilt 2002 · S/N 172S9197N197TFSky West Aviation Inc Trustee · Albuquerque, NMS/N 72N197XTMona Paul George · New Harmony, UTS/N 23754N19800Cardinal LLC · South Easton, MABuilt 1976 · S/N 17702599N19806Overseas Aviation Inc · Wilmington, DEBuilt 1976 · S/N 17702600N1980TSpiegel Kirk · San Luis Obispo, CABuilt 1971 · S/N 28-7105200N1980YJorgensen Sarah B · Anchorage, AKS/N 267N19814Dix Aviation LLC · Indianapolis, INBuilt 1976 · S/N 17702601N1981HRegistration Pending · Saint Louis, MORegistration pendingBuilt 1977 · S/N 32-7700013N1981TWatson Barrett Consulting LLC · Hermitage, TNS/N 28-7105201N19824Gadola Alan J · Maple Grove, MNBuilt 1976 · S/N 17702605N19828Walker Clint · Indianapolis, INBuilt 1976 · S/N 17702606N1982HWasley David L · Harwinton, CTBuilt 1977 · S/N 32R-7780212N1982KN1982k LLC · Wilmington, DEBuilt 2005 · S/N T18208442N1982YSale Reported · Mount Pleasant, SCSale reportedBuilt 1964 · S/N 269N1983HGroeteke Robert W · Ravenna, NEBuilt 1977 · S/N 32R-7780213N1983LWindsor Aero Holdings LLC · Columbia, SCBuilt 1976 · S/N M-1841N19847Wheatley William L · Springfield, KYBuilt 1976 · S/N 17702607N1984TGettelfinger Bart A · Indianapolis, INBuilt 1971 · S/N 28-7105202N19857Rutledge James M · Cresson, TXBuilt 1976 · S/N 17702608N1986LPhillips Alan K · Junction City, ORBuilt 1976 · S/N M-1843N1986VSpeer 182 LLC · Kalispell, MTBuilt 2005 · S/N T18208443N1987YTipton Inc · Turners Station, KYBuilt 1964 · S/N 274N19880Mach 1 Pilots Association Inc · Hillsborough, NJBuilt 1977 · S/N 17702610N1988LPortal Planes LLC · Knoxville, TNS/N M-1842N1988TAtkins Robert M. · Hermosa Beach, CAFirst renewal noticeBuilt 1971 · S/N 28-7105203N1988YReyst Derek C · Manchester, MIBuilt 1964 · S/N 275N19895Fms Aviation LLC · Littlestown, PABuilt 1976 · S/N 17702612N1989LTriple D LLC · Scotland, PAS/N M-1847
Back to AD 2006-10-21