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.

N81HWJones Bradley · Farmerville, LABuilt 1981 · S/N 18504141N81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeBuilt 1985 · S/N 172RG1184N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386N81KSChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10659N81LAMiller Arland E · Guaynabo, PRBuilt 1980 · S/N 18504063N81LBGaravaglia Gary E · Statesville, NCBuilt 2001 · S/N 18281042N81LTDob Air LLC · Baiting Hollow, NYBuilt 1958 · S/N 51547N81LWCloud Seven LLC · Fort Pierce, FLBuilt 1976 · S/N 17702455N81MPPatriot Aviation Inc · Greenville, DEBuilt 1985 · S/N 18268520N81RPLull William G · Ramona, CABuilt 1971 · S/N 177RG0170N81SCGl Aircraft Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 21059382N81TJHelgerson Nicky A · Zwingle, IABuilt 1964 · S/N 18255385N81TPPowers Charles M · Greenwood, MSBuilt 1979 · S/N 210-63426N81ZHCarlsbad Raceway Corp · Hemet, CABuilt 1978 · S/N 21062541N8200FCallanan Craig E · Stillwater, NJBuilt 1966 · S/N 15064300N8200GRj Vincent Enterprises LLC · Rancho Santa Fe, CABuilt 1971 · S/N 177RG0100N8200SPoms Maxfield David · Groveland, CABuilt 1965 · S/N 15061800N8200XKlad-Air LLC · Catlett, VABuilt 1961 · S/N 17248700N8201FYellott Jerry L Jr · Dequincy, LABuilt 1966 · S/N 15064301N8201GMetzgen Richard A · Groveland, CABuilt 1971 · S/N 177RG0101N8201LLonghorn Fligh Training LLC · Midlothian, TXBuilt 1967 · S/N 17256401N8201SMann Derek W · Burwell, NEBuilt 1965 · S/N 15061801N8201ULerma Homero G · Mcallen, TXBuilt 1964 · S/N 17252101N8202AWeaver Savannah N · Fortson, GABuilt 1952 · S/N 25054N8202F98x LLC · Caddo Mills, TXBuilt 1966 · S/N 15064302N8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 17256402N8202SBell Tammy L · San Antonio, TXS/N 15061802N8202UBudget Flyers · Shreveport, LABuilt 1964 · S/N 17252102N8202VCebulski Barry A · Fairbanks, AKBuilt 1966 · S/N 18051704N8202XFerris Tyler S · Pompano Beach, FLFirst renewal noticeS/N 17248702N8203AVista Aviation Services LLC · Boone, IABuilt 1952 · S/N 25055N8203GWarne Samuel S · Salisbury, NCBuilt 1971 · S/N 177RG0103N8203KHandy Air Inc · Douglas, GABuilt 2004 · S/N 20608203N8203MBottle Meister Inc · San Luis Obispo, CABuilt 1969 · S/N 21059203N8204GLowe Clinton V · Lake Point, UTBuilt 1971 · S/N 177RG0104N8204LJohnson Kathy L · Wellsburg, WVBuilt 1967 · S/N 17256404N8204TChampion Anthony R · Troy, MOBuilt 1960 · S/N 17556904N8204USchenck Paul · Glendale, CAS/N 17252104N8204XWallace Howard C · Lompoc, CABuilt 1961 · S/N 17248704N8204ZLfs Inc · Ekalaka, MTFirst renewal noticeBuilt 1963 · S/N 205-0204N8205BHarrison Joseph T · Pensacola Beach, FLBuilt 1957 · S/N 36005N8205FRegistered aircraftBuilt 1966 · S/N 15064305N8205SMckay Christopher · Point Arena, CAS/N 15061805N8205UDby Flights LLC · Pennock, MNBuilt 1964 · S/N 17252105N8205ZMcdaniel George C · Mission Viejo, CABuilt 1963 · S/N 205-0205N8206AWalker Jack A · Klamath Falls, ORBuilt 1952 · S/N 25058N8206LPratt Errol C · Fayetteville, GABuilt 1967 · S/N 17256406N8206MMaxon William D · Santa Paula, CABuilt 1976 · S/N 18264563N8206UShortridge Gary F · Dover, TNBuilt 1964 · S/N 17252106N8206VRegistration Pending · Wasilla, AKRegistration pendingBuilt 1966 · S/N 18051708
Back to AD 79-10-14 R1