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.

N144PGCsi Flight Services LLC · Mcminnville, ORBuilt 2008 · S/N 12349N144PHDel Rio Aviation Inc · Paso Robles, CABuilt 1991 · S/N S1517N144RFRio Farms LLC · King City, CABuilt 2002 · S/N 1223N144RLHanshew James M · Phoenix, AZS/N AA5B1034N144RPBenrud Aviation LLC · Rice, MNS/N 0766N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323N144SJTrigger Down LLC · Virginia Beach, VABuilt 1978 · S/N 61P-0545-233N144SRCedar Ridge Aviation LLC · Knox City, TXBuilt 2003 · S/N 10079N144TLNielson Mark Allen · Willmar, MNBuilt 1959 · S/N 24-1205N144TMSale Reported · Crystal, MNSale reported, pending cancellationBuilt 2004 · S/N M-II-1898N144TPAndrews Clark N · San Diego, CABuilt 1974 · S/N 144N144VHHiggins David W · Meansville, GABuilt 1993 · S/N 0144N144WBUniversal Aviators Academy Inc · El Monte, CABuilt 1998 · S/N 0545N144WTPerformancez LLC · Nederland, TXS/N 0601N144XNelson James G · Santa Rosa, CABuilt 2001 · S/N JGN001N1450RSammy Shwan · Danvers, MABuilt 1972 · S/N 28R-7335060N1450TBruce James E · Prattville, ALBuilt 1972 · S/N 28-7205300N1450XHopkins David M · Bell Buckle, TNBuilt 1975 · S/N 32-7500042N1451HCavanaugh Darrel N · Wasilla, AKFirst renewal noticeBuilt 1950 · S/N 15AC-520N1451JMatthias Jack M · Bonita, CABuilt 1976 · S/N 451N14525Tropeano Joseph P · Ocala, FLBuilt 1977 · S/N 487N1454CFreespirit Ventures LLC · Bear, DEBuilt 1977 · S/N 17702731N1454XPetrak Richard A · Hunker, PABuilt 1975 · S/N 28-7505230N1455HKephart Walter F · Anchorage, AKBuilt 1949 · S/N 15AC-525N1455XAviation Capital Management LLC · San Jose, CABuilt 1975 · S/N 28R-7535285N1456JDelene Joseph R · Elkhorn, WIBuilt 1976 · S/N 456N1456XYoung Daniel J · Cedarburg, WIBuilt 1975 · S/N 28R-7535286N14574Owls Head Transportation Museum · Owls Head, MEFirst renewal noticeBuilt 1975 · S/N C-1N1457JRatcliff David R Trustee · Ellensburg, WABuilt 1976 · S/N 457N1458Bradley Nigel D · Longwood, FLBuilt 1998 · S/N 1621N1458JEastcoast Investment Holdings Inc · Wilmington, DEBuilt 1976 · S/N 458N145ABAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3137N145ACTrusler William L · Magnolia, TXBuilt 1992 · S/N 684-92N145ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010047N145ASCarlson Robert V · Bethel, AKBuilt 2004 · S/N 556EN145BCassels James M · Checotah, OKBuilt 1973 · S/N 74-32-133N145BBScott Jeffrey E · Cherokee Village, ARBuilt 1982 · S/N 1N145BCMazur Steve J · Fairbanks, AKBuilt 2004 · S/N 456-2004N145DLWallace Air Holdings LLC · Anchorage, AKBuilt 2005 · S/N 81286N145HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2001 · S/N 172S8745N145HRNeufeld Mark W · Coeur D Alene, IDBuilt 2007 · S/N 1778N145MDBingham John R · Leawood, KSBuilt 2007 · S/N 755EN145MEAbdelmotal Elsadig · Pearland, TXBuilt 2000 · S/N 172S8429N145RHFlying L Aircraft Inc · Fort Denaud, FLBuilt 1986 · S/N 1N145RVColeman Ronald · Bastrop, TXBuilt 2011 · S/N 003N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145N1460JMoore Ronnie G · Santa Fe, TXBuilt 1976 · S/N 460N1461JJanak Jeffrey · Corpus Christi, TXBuilt 1976 · S/N 461N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430
Back to AD 2006-10-21