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.

N241BDHanus David S · Mound, MNS/N 60477N241DKSale Reported · Wilmington, DESale reportedBuilt 2022 · S/N 367N241EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 172S13238N241GSmith Albert K · Pentwater, MIBuilt 1978 · S/N 14394N241GTBroshchan Ruslan A · Jackson, MSS/N 2141N241HBEngelmann Christopher · Mayer, MNBuilt 2019 · S/N 1241N241HCButcher Robert E · Friendswood, TXBuilt 2005 · S/N 81966N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011N241JESmedshammer Paul J · Petaluma, CABuilt 2001 · S/N 23868N241KRMako Offshore Exploration Inc · Pagosa Springs, COBuilt 2004 · S/N T18208326N241MAKim Sung Su Trustee · Upland, CABuilt 2010 · S/N 3110N241ME#430b LLC · Bruce Township, MIBuilt 2000 · S/N 18280761N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214N241PAHilow LLC · Woodbury, MNBuilt 2009 · S/N 3069N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589N241RBJankowski Richard S · Shenandoah, TXBuilt 1997 · S/N 23274N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916N241TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496559N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113N241VSDjd Aero Corp · Wilmington, DEBuilt 2000 · S/N 0729N241VYShallbetter Joseph R · Marana, AZBuilt 1999 · S/N 1449N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073N241ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881610N24200Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13114N24204Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13115N24205Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13116N24207Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13118N2420LSasscer Michael Scott · Temecula, CABuilt 1994 · S/N 243N24210Atp Aircraft 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13122N24213Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13124N24215Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13128N24218Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13129N24219Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13130N2421RMerryman Todd K · Shickley, NEBuilt 1969 · S/N 28-5618N2421WJohnston John · Sheboygan, WIBuilt 2023 · S/N 2881631N24221Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13131N24222Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13132N24223Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13133N24226Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13134N2422MGuyll Jay D · Denville, NJBuilt 1963 · S/N M-256N2422UDennissan LLC · Noble, OKBuilt 1979 · S/N 32R-8029002N2422YMarker Aviation LLC · Keller, TXBuilt 1966 · S/N 28-3171N24236Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13135N24237Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13136N24238Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13139N24239Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13142N2423RAluminum Falcons Flying Club LLC · Bloomsburg, PABuilt 1969 · S/N 28-5619N2424Savage Bradley · Lac Du Flambeau, WIBuilt 2017 · S/N 30048CN24245Career Track 1 LLC · Wilmington, DEBuilt 2024 · S/N 172S13145
Back to AD 2006-10-21