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.

N201NUGolden Seal Enterprises Inc · Winchester, VABuilt 1977 · S/N 24-0277N201NVSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 24-0294N201NWBravo Echo LLC · Eagan, MNBuilt 1977 · S/N 24-0276N201NXSzajer Gregory · Catskill, NYBuilt 1977 · S/N 24-0283N201NZMooney M20j Brokers LLC · Saint Charles, MOBuilt 1977 · S/N 24-0300N201PMarshall Christopher R · Oshkosh, WIBuilt 1976 · S/N 240070N201PBHumphrey Richard Ingraham · Keller, TXBuilt 1977 · S/N 24-0146N201PCGreatest Show Management LLC · Bee Cave, TXBuilt 1977 · S/N 24-0083N201PDOlmstead Cecil Jay III · Houston, TXBuilt 1977 · S/N 24-0170N201PFMooney Flyers LLC · Minot, NDBuilt 1977 · S/N 24-0145N201PJBrownfield Izzy · Denton, TXBuilt 1977 · S/N 24-0180N201PKMininger John · Quakertown, PABuilt 1977 · S/N 24-0278N201PNAkins Anthony · Meridian, IDBuilt 1977 · S/N 24-0302N201PPRohrbach James S · Fort Lauderdale, FLBuilt 1979 · S/N 24-0846N201PSEmbrey Matthew D · Murrieta, CABuilt 1977 · S/N 24-0113N201PTWells Tony · Knob Lick, KYBuilt 1977 · S/N 24-0106N201PVCowan George L · Scranton, SCBuilt 1977 · S/N 24-0321N201PXNecessary Richard A Jr · Rural Hall, NCBuilt 1977 · S/N 24-0315N201PYRandolph Paul D · Easley, SCS/N 24-0310N201PZSmits Joel R · Crete, ILBuilt 1977 · S/N 240329N201QAIron Wing Flying Club Inc · Shelby Township, MIBuilt 1977 · S/N 24-0317N201QCDigital Outdoor Adertising LLC · Reno, NVS/N 24-0305N201QEWaters Michael C · Social Circle, GABuilt 1977 · S/N 24-0343N201QHPodd Bradley Stephen · Wilmington, NCBuilt 1977 · S/N 24-0348N201QJDubritz Michael J · Dix Hills, NYBuilt 1977 · S/N 24-0347N201QMNordica Group Ltd · Chicago, ILBuilt 1977 · S/N 24-0339N201QRJennings Denise E Trustee · Fullerton, CABuilt 1977 · S/N 24-0353N201QVJohnson Philip H · Bluffton, SCS/N 24-0355N201QWRose James D · Fort Worth, TXS/N 24-0236N201QXRegistration Pending · Portland, ORRegistration pendingBuilt 1977 · S/N 24-0367N201QYJohnson Seth M · Arlington, TXBuilt 1977 · S/N 24-0357N201QZFogle Adventure Air LLC · Neeses, SCS/N 24-0358N201RMay Jack C · Conroe, TXBuilt 1977 · S/N 24-0203N201RAMooney 201ra Holding LLC · San Diego, CABuilt 1982 · S/N 24-1319N201REFowler W Kirk · Longmont, COBuilt 1977 · S/N 24-0341N201RFMfc Corp · Washington, DCS/N 24-0135N201RJLoyless John B · Lubbock, TXBuilt 1977 · S/N 24-0115N201RLGmg Associates · Madison, CTBuilt 1977 · S/N 24-0143N201RRGuthrie Edward J · Lincoln Univ, PABuilt 1977 · S/N 24-0089N201RSWilliams Ken L · Palmer, AKBuilt 1976 · S/N 24-0062N201RUMoore James B · Yorktown, VAS/N 24-0360N201RWRodriguez Ricardo A · Norristown, PAS/N 24-0158N201RYTop Shelf LLC · West Fargo, NDBuilt 1977 · S/N 24-0257N201RZGoller Daniel M · Grass Lake, MIBuilt 1977 · S/N 24-0327N201SAQuinn Timothy M · South Haven, MIBuilt 1977 · S/N 24-0114N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630N201SGPhoturis LLC · New Carlisle, OHBuilt 1977 · S/N 24-0178N201SKBu James · South Pasadena, CABuilt 1977 · S/N 24-0142N201SLCooley Ben · Owensboro, KYBuilt 1977 · S/N 24-0191N201SNBecker Dean · Sarasota, FLBuilt 1977 · S/N 24-0319
Back to AD 2006-10-21