OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3182QMagnusson Ralph L · Wyoming, MNBuilt 1967 · S/N 18258182N3182RSeven Hills Sky Divers Inc · Madison, WIBuilt 1967 · S/N 18258582N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646N3182UGarcia-Martinez Jose Victor · Birmingham, ALBuilt 1963 · S/N 18254582N3182XHerrera Lizann · Sumner, WABuilt 1966 · S/N 15064582N3182YHeckethorn Philipp · Baker, NVBuilt 1962 · S/N 18254182N3183DT2k Aircraft · Austin, TXBuilt 1955 · S/N 31981N3183JRank Brian Andrew · Oxford, MIBuilt 1966 · S/N 15065883N3183QMj Syndicate LLC · Vancouver, WAS/N 18258183N3183RRusso Anthony G · Melbourne Beach, FLS/N 18258583N3183SJohnson Richard · Winnebago, MNBuilt 1964 · S/N 18255683N3183XTrimble John Sr · Stone Mountain, GABuilt 1966 · S/N 15064583N3183YAlc Aviation LLC · Milwaukee, WIBuilt 1962 · S/N 18254183N3184BCerisano Kevin · Trussville, ALBuilt 1952 · S/N 25426N3184DRitchie Rex W · Lopez Island, WABuilt 1955 · S/N 31982N3184QBeaugh Anthony H · Platteville, COBuilt 1967 · S/N 18258184N3184RGardner Daniel J · Alvord, TXBuilt 1967 · S/N 18258584N3184SThrash Farms Inc · Pelahatchie, MSBuilt 1964 · S/N 18255684N3184XSandlapper Aviation Of De · Bennington, VTBuilt 1966 · S/N 15064584N3184YFunkhouser David E · Weatherford, OKBuilt 1962 · S/N 18254184N3185BThomas Coby M · Fairbanks, AKBuilt 1953 · S/N 25427N3185DMorgan Douglas C · Anchorage, AKBuilt 1955 · S/N 31983N3185F85 Foxtrot LLC · Redmond, ORS/N 18257285N3185QPara Tactics LLC · Shelton, WABuilt 1967 · S/N 18258185N3185XSanders John L · Sikeston, MOS/N 15064585N3185YGochenour Air Inc · Fort Wayne, INBuilt 1962 · S/N 18254185N3186DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 31984N3186JHowenstein John G · Roseville, CABuilt 1966 · S/N 15065886N3186QKimbril Steve · Hartselle, ALBuilt 1967 · S/N 18258186N3186RHuey Gale R · Celeste, TXBuilt 1967 · S/N 18258586N3186XPanus Mark V · Hinsdale, NYBuilt 1966 · S/N 15064586N3186YJram Air Parts LLC · Henderson, NVBuilt 1962 · S/N 18254186N3187BRitchie Robert E · Centennial, COBuilt 1953 · S/N 25429N3187CHemm Colby L · Newcastle, CABuilt 1954 · S/N 30986N3187FVolatile Aero Ventures LLC · Boulder City, NVBuilt 1966 · S/N 18257287N3187JBrar Amuldeep S · Austin, TXBuilt 1966 · S/N 15065887N3187UMillikan Kimball S · Honolulu, HIBuilt 1963 · S/N 18254587N3187YMiller Richard G · Anson, TXS/N 18254187N3188AReints Rydell J · Wasilla, AKBuilt 1953 · S/N 25832N3188JFlight Time Builders Inc · Memphis, TNBuilt 1966 · S/N 15065888N3188QLutz Paul A Trustee · Seville, OHBuilt 1967 · S/N 18258188N3188SCrossman Charles · Rusk, TXBuilt 1964 · S/N 18255688N3188TRucinski Edward A · Climax, NCS/N 17700488N3188UAsb Avionics LLC · Mojave, CABuilt 1963 · S/N 18254588N3188YIngram Patrick Joseph · Pinedale, WYS/N 18254188N3189CSmith David J · Duluth, MNBuilt 1954 · S/N 30988N3189SMarvin Franz Interests Inc · Victoria, TXS/N 18255689N3189ULaney Donald R · Inkster, MIS/N 18254589N3189VMunn Julian · Spring, TXS/N 15076413N318CCVan Schoonhoven Nicholas R · Kent, WABuilt 1966 · S/N 18257289
Back to AD 79-10-14 R1