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.

N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449N2139BN2139b LLC · Newark, DEBuilt 1978 · S/N 28-7911009N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220N2139KPolly P LLC · Fort Worth, TXBuilt 1999 · S/N 27-0271N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147N213CDJungman Frank · Escondido, CABuilt 2000 · S/N 1111N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046N213CRJuarez Justin · Garden City, IDBuilt 1992 · S/N 690-92N213CSAeromarine Airways Inc · Miami, FLBuilt 1978 · S/N 24-0529N213DSLexington Flying Club Inc · Lexington, KYBuilt 2004 · S/N 40.360N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130N213HTValdovinos Candido · Monroe, WABuilt 1968 · S/N 67-16822(780929)N213JMHagleitner Gunther · San Jose, CABuilt 1999 · S/N 22651N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572N213PMainstream Aviation LLC · Benton, KYBuilt 2022 · S/N 3390N213SALatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1973 · S/N 28R-7435138N213SFSeaton Flying Services · Killeen, TXBuilt 2005 · S/N 1534N213SMArrowhawk Imaging LLC · Morgantown, WVBuilt 2003 · S/N 20608206N213TJNewsome Timothy S · Alta Loma, CABuilt 2020 · S/N 2B-3B/4B-1437BN213WTCarmer Jacob D · Mount Morris, MIBuilt 1993 · S/N 1359N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117N2140RStidham Stephen A · North Pole, AKBuilt 1989 · S/N 01N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340N2140WAbbott Bruce E · Seal Beach, CABuilt 1974 · S/N M-1513N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273N21418Woodard Christopher Shane · Forney, TXBuilt 1978 · S/N 32-7840185N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302N2141THorizon Ventures Inc · Red Oak, IABuilt 1971 · S/N 28R-7135144N2141WMeyer Carl F Jr · Eagan, MNBuilt 1974 · S/N M-1514N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089N2142YChanfrau Frederic · Barrington, RIS/N 28-7911142N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211N21438Texas State Technical College · Waco, TXBuilt 1979 · S/N 44-7995051
Back to AD 2006-10-21