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.

N182DPCopeland Aviation LLC · Cedar Park, TXBuilt 2002 · S/N 18281124N182ESwanson Jorge A · Douglas, AZBuilt 1979 · S/N R18201114N182EB182 Flyers LLC · Spartanburg, SCBuilt 1980 · S/N R18201520N182EGBurnette Ric · Sebastian, FLBuilt 1979 · S/N R18200787N182FBDownwind Abeam Inc · Pasadena, CABuilt 1979 · S/N R18201422N182FNSumner Investments LLC · Denham Springs, LABuilt 1997 · S/N 18280004N182FRRedwood Airport LLC · River Ridge, LABuilt 1977 · S/N 001N182GFGormley Lane Martin · Stanwood, WAS/N 18280058N182GHTroy-Oakland Pilots Flying Club Inc · Troy, MIBuilt 1998 · S/N 18280003N182GMBaker Charles W · Lake Worth, FLBuilt 2005 · S/N 18281635N182GNWorthington Greg · San Francisco, CABuilt 2002 · S/N T18208112N182GZAircraft By Farkas LLC · Middleburg Heights, OHS/N R18200195N182HATurner Company LLC · Hearne, TXS/N R18200100N182HCDrake Craig C · Brandon, MSBuilt 1978 · S/N R18200734N182HFCook Daniel E · Gulf Breeze, FLBuilt 2005 · S/N 18281586N182HZElings Heath R · Conrad, MTBuilt 2002 · S/N T18208129N182JDRegistered aircraftBuilt 2000 · S/N 18280770N182JSJohn W Spurlock Md Ltd · Bethlehem, PABuilt 1999 · S/N 18280655N182JZMercer Fraser Co · Eureka, CAFirst renewal noticeBuilt 2004 · S/N T18208258N182KCBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201139N182KGKeefe Patrick M · Watersmeet, MIS/N 18280020N182KHDowning Billy G · Imboden, ARBuilt 1998 · S/N 18280246N182KSAltivor LLC Trustee · Sheridan, WYBuilt 1978 · S/N R18200144N182LKEllison William G · Telluride, COS/N T18208182N182LMCommercial Diving Inc · Melbourne, FLBuilt 2004 · S/N 18281412N182MASterling Flight Training LLC · Jacksonville, FLBuilt 2015 · S/N 172S11590N182MGTurnidge Austin Michael · Seattle, WABuilt 2001 · S/N T18208046N182MJNelson Theresa H · Knoxville, TNBuilt 1979 · S/N R18200718N182MUTru Flight Materials LLC · Wilmington, DEBuilt 2004 · S/N T18208334N182NCKrizauskas David F · Moncks Corner, SCBuilt 1979 · S/N R182-01015N182NWNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11043N182PJHarris William · Bullard, TXBuilt 1998 · S/N 18280270N182PMRg Aviation LLC · Fulton, MSBuilt 2004 · S/N 18281330N182PPPatch Patricia A Trustee · Titusville, FLBuilt 2005 · S/N T18208389N182RHFinnelly Patrick J · Hunts Point, WABuilt 2004 · S/N 18281429N182RNNensel Richard E · Sylvania, OHBuilt 1978 · S/N R18200311N182RRDont Be Nosy LLC · Fresno, CABuilt 2005 · S/N 18281675N182SHColes Robert John Jr · Santa Barbara, CABuilt 1980 · S/N R182-01348N182SPT Mark Fay Consulting Inc · Naperville, ILBuilt 1979 · S/N R18201003N182SVSky-Vu Flyers Inc · Fishers, INBuilt 2001 · S/N 18280928N182TPepper Gregory Lee · Fayetteville, GABuilt 1967 · S/N TD-687N182TAJeppesen Employees Flying Assiciation Inc · Englewood, COS/N 18280062N182TSLynch Larry E · West Branch, IABuilt 2004 · S/N T18208237N182UKarl Mark G · Wilbraham, MABuilt 1982 · S/N R18201864N182VBNemirsky Nicholas · Huntington Beach, CABuilt 1997 · S/N 18280025N182VMBergey-Shisler Joanna · Chalfont, PABuilt 2001 · S/N 18281005N182VPJobsight Delta Inc · Sugar Grove, ILBuilt 1998 · S/N 18280247N182VTStarbros Aviation LLC · Southlake, TXBuilt 2003 · S/N 18281215N182WDLewis W D III · San Carlos, CABuilt 1979 · S/N R18200848N182WGBurgett Dale · Lake Lure, NCBuilt 2000 · S/N 18280831
Back to AD 2006-10-21