OpenAirDocs.org
AD 76-04-05

Registered aircraft · 859

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

N105NABond Gary G · Harvest, ALBuilt 1978 · S/N AA5B-1016N1082ZJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA5B0346N111LAAmmons Curtis D · Hernando, MSBuilt 1976 · S/N AA5B-0249N112FTColesanti Richard A · Poughquag, NYBuilt 1975 · S/N AA5B-0180N114BJBig Q Aviation · Helena, MTS/N AA5B0656N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N117LWBlasdel Michael J · Fort Worth, TXBuilt 1975 · S/N AA5B-0057N119STSandberg Brian · Lancaster, CABuilt 1975 · S/N AA5B-0119N11JVHoltz Jeff · Liberty Lake, WABuilt 1977 · S/N AA5B0593N11LTG T Flying Club LLC · Bellaire, TXBuilt 1977 · S/N AA5B0616N123ESPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 1021N125RMGurtman Samuel · Deerfield, ILBuilt 1978 · S/N AA5B0698N126DGSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N AA-5B-0099N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84N144RLHanshew James M · Phoenix, AZS/N AA5B1034N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008N1502RSale Reported · San Diego, CASale reported, pending cancellationBuilt 1974 · S/N AA5B-0002N1503RBeck Wally J · Davenport, IABuilt 1974 · S/N AA5B-0003N1504RFlying Tiger LLC · Broomfield, COBuilt 1974 · S/N AA5B-0004N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030N1515ROwen Ray M · Columbia Station, OHBuilt 1974 · S/N AA5B-0015N1516RMckenzie Pools Inc DBA · Springfield, ORBuilt 1974 · S/N AA5B-0016N1519RSims John · Ingleside, TXBuilt 1974 · S/N AA5B-0019N1520Littler David E · Largo, FLBuilt 1978 · S/N AA5B0957N1520RCastro Jose M · Conway, ARS/N AA5B-0020N1521RPerkins J R III · The Dalles, ORBuilt 1975 · S/N AA5B-0021N1523RDement Myers Michael W · Newberg, ORBuilt 1975 · S/N AA5B-0023N1527RFilkins Barbara L · Fillmore, CABuilt 1975 · S/N AA5B-0027N1529RBall Chad M · Delaware, OHBuilt 1975 · S/N AA5B-0029N1531RMorgan Virginia K · Artesian, SDBuilt 1975 · S/N AA5B-0031N1532RAdkins Todd D · Manassas, VABuilt 1975 · S/N AA5B-0032N1533RAnderson Michael · Byhalia, MSBuilt 1975 · S/N AA5B-0033N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038N1540RPolar Tigers Inc · North Oaks, MNBuilt 1975 · S/N AA5B-0040N1541RHall Daniel · Haskell, OKBuilt 1975 · S/N AA5B-0041N1542RHoose Michael J · Cortland, NYS/N AA5B-0042N1543RHettlinger Eric R · Terre Haute, INBuilt 1975 · S/N AA5B-0043N1545RSanders Harrison S · West Columbia, TXBuilt 1975 · S/N AA5B-0045N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048N1555RDickenson William P · Lockport, NYBuilt 1975 · S/N AA5B-0055N1558RTaylor Scott Douglas · Bethlehem, CTBuilt 1975 · S/N AA5B-0058N1559RMoore Kira G · Newcastle, CABuilt 1975 · S/N AA5B-0059N1560RAbria Consulting LLC · New Milford, NJS/N AA5B-0060N1561RKimmerer William J · Berkeley, CABuilt 1975 · S/N AA5B-0061N1562RArnesen Thomas · Sioux Falls, SDBuilt 1975 · S/N AA5B-0062N1568RRobinson Leonard C · Boca Raton, FLBuilt 1975 · S/N AA5B-0068N1572RBurke Kenneth L · Colleyville, TXBuilt 1975 · S/N AA5B-0072
Back to AD 76-04-05