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.

N803MWMowotech Inc · Boca Raton, FLBuilt 1979 · S/N 18267106N803SPDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 172S8108N8040FWingfield Kyle M · Leesburg, GABuilt 1966 · S/N 15064140N8040SNew Flight LLC · Dublin, VABuilt 1965 · S/N 15061640N8040XMj Coop LLC · Sylva, NCBuilt 1961 · S/N 17248540N80414Garn Darrell L · Palmetto, GABuilt 1976 · S/N 17266576N80419Korona Lawrence K · West Paterson, NJBuilt 1976 · S/N 17266578N80421Kuder Kyp E · Rogers, NDBuilt 1976 · S/N 17266580N80425Fellows Roy H · Augusta, KSBuilt 1976 · S/N 17266582N8042FFlying Hawks Inc · Palmyra, WIBuilt 1975 · S/N 17264378N8042SBanning Braden L · Pleasant Hill, IABuilt 1965 · S/N 15061642N8042VSale Reported · Watford City, NDSale reportedBuilt 1967 · S/N 188-0292N80436N80436 LLC · Columbia, MSBuilt 1976 · S/N 17266585N80439Oklahoma State University · Stillwater, OKBuilt 1976 · S/N 17266586N8043GConnor Robert L · North Little Rock, ARBuilt 1971 · S/N 177RG0043N8043SLund William R · Escondido, CABuilt 1965 · S/N 15061643N8043XStrandberg Kevin L · Pennock, MNBuilt 1961 · S/N 17248543N80440Rockey John · Jupiter, FLBuilt 1976 · S/N 17266587N80442Washburne Seth P · Dallas, TXBuilt 1976 · S/N 17266588N80449Davis Lawrence J Jr · Wasilla, AKS/N 18503119N8044BAshley Ken E · Maiden, NCBuilt 1957 · S/N 29844N8044GTml Services LLC · The Villages, FLS/N 177RG0044N8044LOverton Larry D · Hermiston, ORS/N 17256244N8044ZLever Samuel C · Udall, KSS/N 15071255N8045Mcclure Richard A · Edna, TXS/N 18262046N80454Tadao LLC · Tucson, AZBuilt 1976 · S/N 17266593N80456Barash Geva S · Ashland, MABuilt 1976 · S/N 17266595N80458Kolpack Glenn H · Sonora, CABuilt 1976 · S/N 17266597N8045ASalter James M · Crested Butte, COBuilt 1952 · S/N 20897N8045LAmonett Rodney · Abilene, TXBuilt 1967 · S/N 17256245N8045QEcho Bay Corporation · Bow, WABuilt 1978 · S/N 18503632N8045VGreater Houston Soaring Assoc · Needville, TXBuilt 1967 · S/N 188-0295N80469Hetherly Bryce D · Clintondale, NYS/N 17266603N8046BAnderson Charles D · Fairbanks, AKBuilt 1957 · S/N 29846N8046SHolmes Gerald P · Billerica, MABuilt 1965 · S/N 15061646N8046VSt Bernard Parish Police Jury · Chalmette, LABuilt 1967 · S/N 188-0296N8046ZBest Auto Sales LLC · Plummer, IDS/N U206-0446N80470Coddiwomple LLC · Newberg, ORBuilt 1976 · S/N 17266604N80471Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 17266605N80472Simons George Trustee · Bouse, AZBuilt 1976 · S/N 17266606N80475Texas Southern University · Houston, TXS/N 17266608N80476Sky Roamers LLC · Columbus, NEBuilt 1976 · S/N 17266609N8047BGuidry Janice C · Mechanicsville, VABuilt 1957 · S/N 29847N8047ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268385N8047FPoole Terrell W · Rigby, IDBuilt 1966 · S/N 15064147N8047XFitzgerald Jeff D · Smithfield, UTBuilt 1961 · S/N 17248547N8047ZBooth James L · Bozeman, MTS/N 180-52312N80483Harrell Matthew J · Grand Haven, MIBuilt 1976 · S/N 17266611N80484Mor Aviation 172m LLC · Gaithersburg, MDBuilt 1976 · S/N 17266612N80486Romoser Carey E · Simpsonville, SCBuilt 1976 · S/N 17266613
Back to AD 79-10-14 R1