OpenAirDocs.org
AD 77-13-21

Registered aircraft · 3,193

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:77-13-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:77-13-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.

N8919PHealey Patrick T · Tucson, AZBuilt 1966 · S/N 24-4374N891MDCharbonneau John E · Manhattan, KSBuilt 1960 · S/N 24-2045N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926PGallagher Derek P · O Fallon, ILS/N 24-4382N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388N8934PNermernuh LLC · Chester, CTBuilt 1966 · S/N 24-4390N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396N8942PAncelet Grant D · Crowley, LABuilt 1966 · S/N 24-4398N8944PPittner Hans C · Goshen, NYBuilt 1966 · S/N 24-4400N8944YTallman Michael Daniel · Latrobe, PABuilt 1971 · S/N 39-105N8945YPipers Are Still Better LLC · Carson City, NVS/N 39106N8946PBreding Ralph E · American Falls, IDBuilt 1966 · S/N 24-4402N8947YStroh Chuck · Yukon, OKBuilt 1971 · S/N 39-108N8948YKilpatrick Kerry · Somerset, NJBuilt 1971 · S/N 39-109N8951PJames Donnie E · Collinsville, ALBuilt 1966 · S/N 24-4408N8952PBreckenridge Lester James Jr Trustee · Appleton City, MOBuilt 1966 · S/N 24-4409N8953PTendie Time Flying LLC · San Diego, CABuilt 1966 · S/N 24-4410N8954PKramer Kartie K · Mckinney, TXBuilt 1966 · S/N 24-4411N8955PPropwash LLC · Princeville, ILBuilt 1966 · S/N 24-4412N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8957PCreedon John · Mc Cormick, SCBuilt 1966 · S/N 24-4414N8958PVan Dyke David M · Portland, ORBuilt 1966 · S/N 24-4415N8959PMosel Properties LLC · Marrero, LABuilt 1966 · S/N 24-4416N8961PRegistered aircraftBuilt 1966 · S/N 24-4418N8962PDunning John · Stow, MABuilt 1966 · S/N 24-4419N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N8964PPerkins Michael W · Warren, MIBuilt 1966 · S/N 24-4421N8965PChancellor Richard · Palmer Lake, COBuilt 1966 · S/N 24-4422N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N8966PLautensack Peter · Oswego, NYBuilt 1966 · S/N 24-4423N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427N8971PDerrel Luce Pc · Waco, TXBuilt 1966 · S/N 24-4428N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430N8973YAire Ryder LLC · Roseville, MNS/N 39-139N8974P4papa LLC · Gig Harbor, WABuilt 1966 · S/N 24-4432
Back to AD 77-13-21