OpenAirDocs.org
AD 77-07-04

Registered aircraft · 869

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-07-04')
    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-07-04')
  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-0107N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086N102ASG&P Cheetah LLC · Honolulu, HIBuilt 1977 · S/N AA5A0514N10SXAerodynamics Unlimited LLC · Oklahoma City, OKBuilt 1977 · S/N AA5A0303N1104RInternational Air Services Inc Trustee · Carson City, NVS/N AA5-0471N1118AKing Charles W · Kelseyville, CABuilt 1976 · S/N AA5A-0192N119EKBrady Michael K · Sammamish, WABuilt 1974 · S/N AA5-0595N11ZSSergeant John F C · Fort Myers, FLS/N AA5A-0403N1234DGonzales Jaime T · Mandeville, LABuilt 1979 · S/N AA5A0860N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398N1317RVaughan Andy C · Sacramento, CABuilt 1977 · S/N AA5A0323N1318RWright Wayne S · Linden, MIBuilt 1974 · S/N AA5-0718N1319RJustusson William · Punta Gorda, FLS/N AA5-0719N131KYJett Edward C Jr · Bloomfield, KYBuilt 1979 · S/N AA5A0828N1321RRamineni Raja S · Fort Mill, SCBuilt 1974 · S/N AA5-0721N1327RYost 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-0748N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755N1359REllingson Jason J · Edina, MNBuilt 1975 · S/N AA5-0759N1361RLeslie 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-0769N1376RParker Brian L · Columbus, GABuilt 1975 · S/N AA5-0776N1377RHendrix David S · Benbrook, TXBuilt 1975 · S/N AA5-0777N1385RCulleton Frederic · Flowery Branch, GABuilt 1975 · S/N AA5-0785N1388RTrybe LLC · Frisco, TXBuilt 1975 · S/N AA5-0788N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798N141ACGann Steve W · Southaven, MSS/N AA5-0743N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213N155BYYount Brian C · Fullerton, CAS/N AA5-0184N158GCWebster Scott A · Plant City, FLBuilt 1976 · S/N AA5A-0158
Back to AD 77-07-04