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.

N236PDHeitz Kenneth Joe · Boynton Beach, FLBuilt 1979 · S/N 28-8011029N236PMCummings Ralph L · Rmv, CABuilt 1982 · S/N 28-8211032N236PRConnecticut Flyers Inc · Madison, CTBuilt 1979 · S/N 28-7911272N236RCCarter Rodney D · Artesia, NMBuilt 1983 · S/N R18201963N236RHMesmer Robert F · Grand Island, NYBuilt 1988 · S/N 236N236SHAir 2 Sea LLC · Martin, TNBuilt 1979 · S/N 28-7911169N236SP83l Ventures LLC · San Carlos, CABuilt 1999 · S/N 172S8213N236TFChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 172S12134N236TTPoole Mark · Meriden, CTBuilt 1981 · S/N 32R-8113110N236WYSouders Lee · Durango, COBuilt 2015 · S/N 3236N236ZKMaximum Ceiling Aviation LLC · Farmingdale, NYS/N 2843401N2370EPowers Thomas Jr · Westerly, RIS/N 18280540N2370JOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S10100N2370WSall LLC · Mill Valley, CABuilt 1998 · S/N 18280405N2370XSouthwest Aircraft Enterprises · Haslet, TXBuilt 1999 · S/N T20608026N2371HSan Jose Aviation LLC · Mission, TXBuilt 1999 · S/N T20608060N2372CMartin Land Improvement Inc · Elk Rapids, MIBuilt 1978 · S/N R18200164N23735Leighton Farms Ltd · Griswold, IABuilt 1999 · S/N 18280458N2373CDs Flight Services LLC · Battle Ground, WABuilt 1978 · S/N R18200165N2373GCentral Iowa Aviation LLC · Ankeny, IABuilt 1998 · S/N 172S8073N2373KReading Aero Club Inc · Reading, PABuilt 1999 · S/N 172S8074N2373MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10592N2373WFayettenam Aero LLC · Laurinburg, NCBuilt 1966 · S/N MA-3N2373ZN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8075N2374CJackson Jeffrey D · Elk City, OKBuilt 1978 · S/N R18200166N23756Sweet Fred A · Loves Park, ILBuilt 1998 · S/N 18280429N2375CEverwind Aviation LLC · Kalispell, MTBuilt 1978 · S/N R18200167N2375JBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280451N2376RRegistered aircraftBuilt 1999 · S/N 18280431N2376VPeyrot Eric M · Summerland Key, FLBuilt 1998 · S/N 18280432N2376XMueller Howard W · Winston Salem, NCBuilt 1999 · S/N 18280433N2377Young Robert L · Oakwood, ILBuilt 1970 · S/N 16408488N2377PLammers William Scott · Deer Park, ILBuilt 1998 · S/N 18280434N2377YTerral William C · Farmerville, LABuilt 1998 · S/N 18280436N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116N23781Paragon Air Group · Fort Worth, TXBuilt 1999 · S/N T20608017N23782Zylstra Cycle Co Inc · Ames, IAFirst renewal noticeBuilt 1999 · S/N 18280448N2378XState Of Utah · Salt Lake City, UTBuilt 1999 · S/N T20608023N2378YLindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608025N23798Jet Air Inc · Iowa City, IABuilt 1998 · S/N 17280603N2379CWest Country Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R18200170N2379FWebster Douglas Clark · Las Vegas, NVBuilt 1999 · S/N T20608019N237AJSuo Anttila Ahti · Albuquerque, NMBuilt 2000 · S/N 18280794N237BMarcum William N · Corpus Christi, TXBuilt 2003 · S/N 60070N237CADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608239N237HHatfield R Andrew · Grand Junction, COBuilt 1996 · S/N 022N237HYZeus Flight LLC · Ketchum, IDBuilt 2003 · S/N 2237N237KBHenke Aircraft Holdings LLC · Dayton, TXBuilt 1978 · S/N 78-31144N237MEWestbank Fishing LLC · Kiln, MSBuilt 2000 · S/N 18280756N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815
Back to AD 2006-10-21