OpenAirDocs.org
AD 2021-14-12

Registered aircraft · 1,103

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:2021-14-12')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-14-12')
  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.

N1000SButler County Warbirds Inc · Middletown, OHBuilt 1972 · S/N AA5-0107N100XXAskew Stell Blake III · Durham, NCBuilt 1975 · S/N AA1B-0578N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086N1012GForwalt Lucas A · Chesapeake, VABuilt 1969 · S/N AA1-0122N1047XHuber Frank B · Maple Grove, MNBuilt 1977 · S/N AA1C-0050N109RWMcpherson Michael A · Stephenville, TXBuilt 1971 · S/N AA1A-0250N10FAFlanigan Marie C · Lockport, NYBuilt 1972 · S/N AA1A-0337N1104RInternational Air Services Inc Trustee · Carson City, NVS/N AA5-0471N117TNNichols Timothy P · Reno, NVBuilt 1976 · S/N AA1B0637N119EKBrady Michael K · Sammamish, WABuilt 1974 · S/N AA5-0595N119RCompton Danny M · Kent, OHBuilt 1978 · S/N AA1C0132N11CYOdonnell Justin M · Amelia, OHS/N AA1C-0011N121MPMast Anthony S · Ripon, CAS/N AA1C-0058N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622N12VGHashimoto Noriyuki · Rumford, MEBuilt 1971 · S/N AA1A-0187N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707N131Ekstrand Marshall · Lake Stevens, WABuilt 1972 · S/N AA1B-0050N1318RWright Wayne S · Linden, MIBuilt 1974 · S/N AA5-0718N1319RJustusson William · Punta Gorda, FLS/N AA5-0719N1321RRamineni Raja S · Fort Mill, SCBuilt 1974 · S/N AA5-0721N1325RDavison Mark L · Vacaville, CABuilt 1976 · S/N AA1B-0615N1327RYost Alan · North Andover, MABuilt 1974 · S/N AA5-0727N1328RTrout Fred C · Dallas, GABuilt 1974 · S/N AA5-0728N1329RDeltondo Ralph P · Fullerton, CAS/N AA5-0729N1331RGalindo John S · Hurst, TXBuilt 1975 · S/N AA5-0731N1333RNorris Randy K · Sylvania, GABuilt 1975 · S/N AA5-0733N1335RHughes Michael · Harvard, MABuilt 1975 · S/N AA5-0735N1336RManus Phillip P · Tucson, AZS/N AA5-0736N1337RZimmerman Christopher Paul · Canandaigua, NYBuilt 1975 · S/N AA5-0737N1339RWilcox Marion L Trustee · La Mesa, CABuilt 1975 · S/N AA5-0739N1341RTmp Aviation LLC · Altamonte Springs, FLBuilt 1975 · S/N AA5-0741N1342RGladden Thomas E · Otis Orchards, WABuilt 1975 · S/N AA5-0742N1345RGrumman N1345r LLC · Benton Harbor, MIBuilt 1975 · S/N AA5-0745N1346RPaul Joshua Daniel · Murrieta, CABuilt 1975 · S/N AA5-0746N1347RCharles Kaplove Md Inc · Novato, CABuilt 1975 · S/N AA5-0747N1348RMargolien Brooks · Orange, MABuilt 1975 · S/N AA5-0748N1350RBates Victoria Anna · West Union, WVS/N AA1B0650N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755N1359REllingson Jason J · Edina, MNBuilt 1975 · S/N AA5-0759N1360RBreland James G · Laurel, MSBuilt 1976 · S/N AA1B0660N1361RLeslie Michael H · Ashburn, VABuilt 1975 · S/N AA5-0761N1366RParodi Carlos Guillermo · Austin, TXBuilt 1975 · S/N AA5-0766N1369RRyals Jon Harris · Billings, MTBuilt 1975 · S/N AA5-0769N1372RStephenson John W · Whittier, CABuilt 1976 · S/N AA1B0672N1373RSmith Paul R Jr · Hubbardston, MABuilt 1976 · S/N AA1B0673N1376RParker Brian L · Columbus, GABuilt 1975 · S/N AA5-0776N1377RHendrix David S · Benbrook, TXBuilt 1975 · S/N AA5-0777N137JBMason Harold T · Hesperia, CABuilt 1978 · S/N AA1C0207N137YHenry Vernon C · Stevensville, MTBuilt 1978 · S/N AA1C0137N1380RNevers Joseph R II · Homestead, FLBuilt 1976 · S/N AA1B0670
Back to AD 2021-14-12