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.

N6CWRegistered aircraftBuilt 1973 · S/N 18262125N6CXMora Leo G · Groveland, CAS/N P3370076N6DEE & R Properties Of Florence LLC · Ridgeway, SCBuilt 1978 · S/N 21062802N6DNLowery William D · Geneva, FLBuilt 1963 · S/N 18255161N6DRHiggins Robert DBA · Gill, MABuilt 1979 · S/N 18266779N6EKCjh Aviation LLC · New Bern, NCBuilt 1967 · S/N 15066827N6FVAlexis Asplundh Studio LLC · Atlantic Beach, FLBuilt 1978 · S/N 177RG1365N6HGBagwell Harold G · Garner, NCBuilt 1978 · S/N 21062624N6HNTalbott Philip A · Galena, OHBuilt 1971 · S/N 172-60326N6HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281070N6HQNazir Donna La Cruz · Boca Raton, FLBuilt 1966 · S/N U206-0581N6HRKornegay Stephanie L · Charlotte, NCBuilt 1974 · S/N 18263470N6JVRanney Gayle · Cordova, AKBuilt 1974 · S/N 18502397N6JYYoung John B · Panacea, FLBuilt 1956 · S/N 28217N6KKUey Aviation Group LLC · Newtown, CTBuilt 1979 · S/N 18267153N6LRClipper 6 Lima Romeo LLC · Rapid City, SDS/N P3370119N6LTDierks Herman D Jr · Round Rock, TXBuilt 1970 · S/N 18052111N6MAShewmaker Air LLC · Bentonville, ARBuilt 1979 · S/N 18267389N6MBSierra Whiskey Aircraft LLC · Oakland, CABuilt 1968 · S/N 17257279N6MDCessna 6md LLC · Englewood, FLBuilt 1963 · S/N 2050315N6MFMission Aviation Fellowship · Nampa, IDS/N U20605926N6MTSchwartz Amy A · Chandler, AZBuilt 1966 · S/N 15062848N6NXGold James M · Kerrville, TXBuilt 1961 · S/N 18253173N6PDNewcomb Clint · Benton, ARS/N 21061930N6QTM And K Industries LLC · Anchorage, AKBuilt 1964 · S/N 18255232N6SFWeatherbe Mark B · Lincoln, MEBuilt 1974 · S/N 18052498N6TKPritchard James A III · Maysville, GABuilt 1981 · S/N 180-53186N6TPRiver Birch Landings LLC · Lewes, DES/N 18263148N6TVTravelaire Service Inc · Wilmington, DES/N 17275278N6URAvidyne Corp · Melbourne, FLBuilt 1978 · S/N 18265967N6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676N6WHWoldow Fredric A · Morton, ILBuilt 1974 · S/N 18052492N6XSWhere On Earth Services Inc · Saranac Lake, NYS/N 1851424N6ZBAsh Reed · Atlanta, GABuilt 1974 · S/N 15075784N6ZDCawley Galen P · Coloma, MIBuilt 1965 · S/N 337-0209N6ZPAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274020N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179N70006Colorado Red LLC · Dillon, COBuilt 1971 · S/N 18501886N7000AHaley Michael R · Hobbs, NMFirst renewal noticeBuilt 1956 · S/N 29100N7000ESchweitzer Mark A · Susanville, CABuilt 1960 · S/N 56500N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907N7000MWht LLC · Noonan, NDBuilt 1958 · S/N 55300N7000TCarter Jared · Lebanon, TNBuilt 1959 · S/N 46600N7001ALkp Aviation LLC · Montgomery, INS/N 29101N7001EMaupertuis Philippe F · Winchester, CABuilt 1960 · S/N 56501N7001GWhite Richard L · Pittsburgh, PABuilt 1973 · S/N 15074601N7001MRush Michael J · Nashua, NHBuilt 1958 · S/N 55301N7001XMoore Aviation Service LLC · Selma, ALS/N 15059101
Back to AD 79-10-14 R1