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.

N1476JDodgen Charles W · Thomaston, GABuilt 1976 · S/N 476N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735N1479JAbel Paul D · Kalispell, MTS/N 539N1479TWnc Aviation LLC · Arden, NCBuilt 1972 · S/N 28R-7235302N147AJAviation Solutions LLC · Louisville, KYBuilt 2006 · S/N T18208482N147BMarble Jacob G · Sandpoint, IDBuilt 2019 · S/N 081 SRN147BCCard Logging Co Inc · Eugene, ORFirst renewal noticeBuilt 2003 · S/N 447-2003N147BDNageotte Randy K · Fredericksburg, VABuilt 2003 · S/N 70388N147EBMalott David · Glade Park, COBuilt 1975 · S/N 20-1165N147ECAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1963 · S/N 27-2399N147FBrown Helicopter Inc · Pensacola, FLBuilt 1964 · S/N 1432-152N147FWParr William R Jr · Mason, TXS/N 80771N147GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881111N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219N147JSScrobola James M · Wyoming, PABuilt 2019 · S/N SCROBOLA 0001N147LFRed Baron LLC · Middletown, DES/N 161N147LHSchool Board Of Brevard County Florida · Melbourne, FLBuilt 2003 · S/N 2844103N147PCAlexander John S · Warrensburg, NYBuilt 2004 · S/N 1366-2004N147PJVargas Luis A · Isabela, PRBuilt 1972 · S/N 32-7240134N147TPPatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2008 · S/N 10602008N147TQIron Thermal LLC · Hogansville, GABuilt 2003 · S/N 920-2003N147WHRussell Andrew J Trustee · Spokane Valley, WAS/N 71460N148Everything Pitts LLC · Queen Creek, AZBuilt 1983 · S/N 1016N14814Florida Flight Training Center Inc · Venice, FLBuilt 2007 · S/N 172S10451N1481XBadgerland Aero Club Inc · Fitchburg, WIBuilt 1975 · S/N 28R-7535289N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585N1483CWang Helin · Dana Point, CABuilt 2005 · S/N T18208419N1483JMcmillan Gavin · Tarpon Springs, FLBuilt 1977 · S/N 542N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452N1484JGingles Collie Jr · Mint Hill, NCBuilt 1976 · S/N 484N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233N1485CLiebowitz Alan · Sioux Falls, SDBuilt 2005 · S/N T18208421N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93N148AMEightalphamike LLC · Kissimmee, FLBuilt 2001 · S/N 2148N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293N148CCRegistered aircraftBuilt 2003 · S/N 9955CCN148DHLeclerc Robert L · Olympia, WABuilt 1994 · S/N 3082N148DPHenke Kristen C · Bettendorf, IAS/N 11015CN148FRamsey William · Eagan, MNBuilt 2000 · S/N 6035N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520N148GHLattimore Partners LLC · Fort Worth, TXBuilt 2005 · S/N T18208417N148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 2020
Back to AD 2006-10-21