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.

N134FSAlcione LLC · Miami, FLBuilt 1978 · S/N 27-7854117N134GWFord Matthew L · Clayton, GABuilt 2002 · S/N T18208134N134JFFlamingo Ridge Aviation LLC · Interlachen, FLBuilt 1993 · S/N 27-0150N134JPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1999 · S/N 170N134JSSparling Albert E · Hubbard Lake, MIBuilt 1968 · S/N 28R-30517N134MHLa Charter And Rental LLC · New Iberia, LABuilt 2013 · S/N 30055CN134MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496483N134MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496593N134PJHelibro LLC · Red Bluff, CABuilt 2002 · S/N 172S9187N134PSBountiful Flight LLC · Woods Cross, UTBuilt 2004 · S/N 40.407N134RTTaylor Robert E · Soldotna, AKBuilt 2017 · S/N 78N134TSDobalian Vaughn E · Jacksonville Beach, FLBuilt 1973 · S/N 61-0134-072N134VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281191N134WDRoorda Thomas D · Port Angeles, WABuilt 1996 · S/N 20921N134WSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 28020137N1350JFish Associates Inc Trustee · Wilmington, DEBuilt 1976 · S/N 516N1350UCain Ronald August · Slidell, TXS/N 248N1350WMaxwell Don P · Longview, TXS/N 2631N13511Meteor Aviation · Kirkland, WAFirst renewal noticeS/N 17702430N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708N1351WAllen Mark S · Reno, NVBuilt 1963 · S/N 2632N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433N1352JBecker Norbert E · Lake Ozark, MOBuilt 1975 · S/N 352N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709N1353JBledsoe Robert · Orlando, FLBuilt 1975 · S/N 353N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242N1353YRust Joyce A · Bourbon, INBuilt 1974 · S/N 28-7405152N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434N1354TRiverside Flight Academy Inc · Riverside, CABuilt 1972 · S/N 28R-7235268N1355JHlatshwayo Mbusi S · Alhambra, CABuilt 1975 · S/N 355N1355TRmf Trucking LLC · Tuscaloosa, ALBuilt 1972 · S/N 32-7240115N1355WBloch Matthew William · Marquette, MIS/N 2636N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438N1356QRouth Frank D · Marion, NCBuilt 1982 · S/N JAR-1N1357CSummit Concepts Inc · Wilmington, DES/N 17702710N1358WDavis Charles S · Fairfield Bay, ARBuilt 1964 · S/N 2722N13596Gary Rollin F · Dallas, TXS/N 17702440N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711N1359TNahir Ehud · Woodland Hills, CABuilt 1972 · S/N 28-7205288N1359WKroll Richard · Laguna Niguel, CABuilt 1963 · S/N 2640N135EG305 Aviation Group Inc · Miami, FLS/N 28-8290170N135EKEc Aviation Group Corp · Ponte Vedra, FLS/N 902N135ESStutzer Lukas P · Chugiak, AKBuilt 1981 · S/N 18-8109074N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077N135GAMicke Thomas B · Mansfield, MABuilt 1992 · S/N 2102N135JCNelson Bradley L · Portland, ORBuilt 1967 · S/N 670337N135JWMackay Matthew · Deer Park, WABuilt 2016 · S/N 3267
Back to AD 2006-10-21