OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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

N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114N40GECuckler Dale E · Tulsa, OKBuilt 1998 · S/N 1545N40GRPetao LLC · Trinity, FLBuilt 2003 · S/N 21980N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40HYHendrickson Dale W · Denton, TXBuilt 2002 · S/N 2205N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036N40JKMann Nathan · Poulsbo, WABuilt 2022 · S/N 11480N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MBAndersen Thomas · Yoder, COS/N 708N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110CN40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40STAvera Stewart · Pensacola, FLBuilt 1997 · S/N T106AN40VVFaulkner Winthrop S · Anchorage, AKS/N 005N40VXHarder Steven R Trustee · The Sea Ranch, CABuilt 1998 · S/N 5040N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4104XBandy Carla Sr · Texarkana, TXBuilt 1968 · S/N 201N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124N4105ZMccaughey Steven A · Winter Haven, FLBuilt 1964 · S/N 18-8126N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035N4106XRossiter Andrew J · Vancouver, WAS/N 203N4106ZJohnson Royce D · Clinton, ARBuilt 1964 · S/N 188127N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4107XRedsun Oren Daniel · Fairfield, CAS/N 205N4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1964 · S/N 18-8128N4108JMetoyer Eric D · Yukon, OKBuilt 1966 · S/N 28-22421N4108ZRamstad Trygg J · Anchorage, AKBuilt 1964 · S/N 18-8130N4109NRoss George H · Delano, MNS/N 680036N4109ZAlf Robert R · Elkhorn, NEBuilt 1964 · S/N 18-8129N410BPWeiss Michael K · Paige, TXBuilt 2012 · S/N P01-P001/P002-P121N410EKGandy Donald T · Weatherford, TXBuilt 1976 · S/N 17702536N410EMMatejka Jeffrey M · Maple, NCBuilt 2004 · S/N JM801N410ETAndervick · Dalton, GABuilt 1976 · S/N 28-7690391N410FBLuna Roan C · Walled Lake, MIBuilt 1969 · S/N 410
Back to AD 79-10-03 R2