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.

N13CEWilley R Scott · Layton, UTBuilt 1970 · S/N 31007N13CMBolin William E · Smithville, OHBuilt 1972 · S/N 090N13CVRice Jonathan C · Vancouver, WABuilt 1995 · S/N 103N13DBBauer Dereck R · Springfield, ORFirst renewal noticeS/N 12-2919N13ENGunn-Golkin Anna E · Cherry Hill, NJBuilt 2004 · S/N 22426N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046N13EXPitts Capital Of Nevada Inc · Las Vegas, NVBuilt 1999 · S/N 087N13FDSkythrills! LLC · Fullerton, CABuilt 1975 · S/N 10-09N13GEParatus Air Inc · Auburn, INBuilt 2002 · S/N 10018N13GRPayton Shawn · Hot Springs, ARBuilt 1984 · S/N 1133N13GYMarvin Dean · Senoia, GABuilt 2001 · S/N 81355N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810N13HNAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13255N13HUSzalay Dennis R · Mooresville, INS/N 1323N13HYKahler Enterprises LLC · Reedsburg, WIBuilt 1999 · S/N 2050N13JBAltitude Aviation Services LLC · Mountain Home, IDBuilt 1976 · S/N 61P-0323-090N13JHL J H Consulting LLC · Greenleaf, IDBuilt 2021 · S/N 617-2021N13JPFour Kicks Aviation LLC · Atlantic, IABuilt 2015 · S/N 73284N13KAAshby Clark S · Pleasant Grove, UTS/N 413RN13KFRockwood Blake T · Fort Worth, TXBuilt 1965 · S/N 28-2396N13KRKaplan Ronald · Palm Beach Gardens, FLBuilt 1967 · S/N 28-4363N13KTButler Bryan C · Brenham, TXBuilt 1992 · S/N 5250N13LDOjala Denita L Trustee · Eden Prairie, MNBuilt 1990 · S/N O'CONNELL-0001N13LFLuciano Michael · Peachtree City, GABuilt 2007 · S/N 70830N13LPVanderhoof Jon A · Omaha, NEBuilt 1974 · S/N 2077N13LS13 Lima Sierra LLC · Whitesboro, TXBuilt 2007 · S/N 2439N13LWRegistered aircraftBuilt 2010 · S/N 141TN13MDMoorstein Mark A · Manassas, VABuilt 1967 · S/N 680025N13MJVanderbilt Carl D · Saint Johns, FLBuilt 2007 · S/N 2537N13NDDavis Robert N · Tipton, INBuilt 1978 · S/N 6005807961188N13NEQualitair LLC Trustee · MichelstadtBuilt 1984 · S/N 31P-8414035N13NMC3 Aircraft LLC · Burnet, TXBuilt 2014 · S/N CC18-0067N13NVShepherd Howard M · Auke Bay, AKBuilt 2011 · S/N AK18103N13PBZimmerman Michael P · Verona, WIBuilt 2022 · S/N 1483-2022N13PMFly High Aviation LLC · Melrose Park, ILBuilt 1977 · S/N 305-77N13PRTomlinson Dana R · San Angelo, TXS/N 115N13PZCroft Jordan · Rosamond, CABuilt 1994 · S/N 20002CN13QMHerrick Eugene · Chicago, ILS/N 3042N13RGIsland Piper Llp · St Helena Is, SCBuilt 1972 · S/N 28-7310055N13RZBjornstad Eugene N Trustee · Girdwood, AKBuilt 1989 · S/N 570N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431N13TEMaddox Eric L · Grover Beach, CABuilt 1978 · S/N 24-0700N13TMSuntech LLC · St George, UTBuilt 1963 · S/N 115N13TTKlcc Holdings LLC · Boca Raton, FLS/N 27-7554069N13UBJohnson Andrew P · Poquoson, VABuilt 2014 · S/N 40753N13VCWhite Paul J · Apex, NCBuilt 2004 · S/N 0002N13WStl LLC · Savoy, ILBuilt 2001 · S/N 3246185N13WRBillys Blessing LLC · Louisburg, NCBuilt 2000 · S/N 3246154N13XMMathis Mark D · Richmond, TXBuilt 1980 · S/N 0001N13YCBuckin 307 Taildraggers LLC · Casper, WYBuilt 1976 · S/N 590-76
Back to AD 2006-10-21