AD 79-10-14 R1

Registered aircraft · 56,582

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-14-R1')
    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-14-R1')
  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.

N64359Brogan Anni T · Anacortes, WABuilt 1975 · S/N 17265190N6435BCookson Brian E · Cookson, OKS/N 29635N6435DMarion Military Institute · Marion, ALBuilt 1979 · S/N 17272799N6435EForte Aviation Parts Inc · Fort Lauderdale, FLBuilt 1959 · S/N 46535N6435GMountain Home Aviation Llp · Mountain Home, IDBuilt 1970 · S/N 15071935N6435SCarney Paul P · Massena, NYBuilt 1967 · S/N 15067235N6435VKirk James B · Lancaster, SCBuilt 1980 · S/N 172RG0696N64364B&R Aircraft LLC · Wadsworth, OHBuilt 1975 · S/N 17265194N64367Hardin John M · Terrell, TXBuilt 1975 · S/N 17265196N6436BConway Jenna M · Camarillo, CABuilt 1978 · S/N 21062763N6436FOrnelas Miguel A · Tucson, AZBuilt 1973 · S/N A1500444N6436TWalker Billy W · Dallas, GABuilt 1960 · S/N 17836N6436VJones Gregory D · Pueblo, COS/N 172RG0697N64377Faircloth William H Jr · Morehead City, NCBuilt 1975 · S/N 17265204N6437ATwin Oaks Aircraft Maintenance LLC · Hillsboro, ORBuilt 1956 · S/N 33237N6437BBrown Michael W · Merced, CABuilt 1956 · S/N 29637N6437EFremont Flight Service LLC · Fremont, MIBuilt 1959 · S/N 46537N6437FWilliams Michael A · Hartsville, INBuilt 1966 · S/N 15063037N6437SFiresheets William R · Zwolle, LABuilt 1967 · S/N 15067237N6437TOcotillo Wells Mobile Off Road Rentals Inc · Cardiff By The Sea, CABuilt 1960 · S/N 17837N64382Roost Leasing LLC · Sturgis, MIBuilt 1977 · S/N 18052896N64383Mission Aviation Training Academy · Arlington, WABuilt 1975 · S/N 17265208N6438AP M Leasing Inc · Perris, CABuilt 1956 · S/N 33238N6438BEllis Matthew P · Broken Arrow, OKBuilt 1957 · S/N 29638N6438FRegistration Pending · Everett, WARegistration pendingBuilt 1973 · S/N A1500445N6438GAero Equities LLC · Ventura, CAS/N 15071938N6438TCactus Clover Inc · El Paso, TXBuilt 1960 · S/N 17838N64390Zarpak Shahab Mike · Bethesda, MDBuilt 1982 · S/N 17275552N6439EBritt Thomas K · Riverview, FLBuilt 1959 · S/N 46539N6439NSpectraq LLC · Las Vegas, NVBuilt 1978 · S/N 21063015N6439SKarren Alexander M · Herriman, UTBuilt 1967 · S/N 15067239N643CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283073N643GAir Leasing Inc · Evanston, ILS/N 15071543N643GWFoxtrot93 Holdings LLC · Wilmington, DEBuilt 2023 · S/N 18283216N643PEColiseum Aviation LLC · Little Rock, ARBuilt 2004 · S/N 18281343N643SPRegistered aircraftBuilt 1998 · S/N 172S8051N643UFRegistered aircraftN-number assigned (import), not yet registeredS/N 21064551N64408Dematteis James A · Erie, PABuilt 1966 · S/N R1720104N6440BWolfe Transportation Inc · Meridian, IDBuilt 1978 · S/N 21062764N6440DBurns John Michael III · San Mateo, CABuilt 1979 · S/N 17272801N6440YTamarack Graphics LLC · Salt Lake City, UTBuilt 1981 · S/N 21064380N64411Anderson Gregory S · Reedsville, PABuilt 1975 · S/N 17265209N64413Hammerton Kenneth R · Olive Branch, MSBuilt 1975 · S/N 17265210N64414Skyhawk N64414 LLC · Walpole, MABuilt 1975 · S/N 17265211N64418Mackey Jeffrey S · Dunlap, TNBuilt 1975 · S/N 17265214N6441BSanpete Air LLC · Spring City, UTBuilt 1957 · S/N 29641N6441DInter State Aviation Inc · Pullman, WABuilt 1979 · S/N 17272802N6441FMach III Flying Inc · Platte City, MOBuilt 1979 · S/N 17273224N64420Pelletier Kevin C · Fort Fairfield, MEBuilt 1975 · S/N 17265216N64421Celtic Flight LLC · Lewes, DEBuilt 1982 · S/N 17275558
Back to AD 79-10-14 R1