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.

N767RWWhitt Robert L · Carolina Beach, NCBuilt 1977 · S/N 15079378N767VKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 172S13021N767XMNew Landing Aviation LLC · Yonges Island, SCBuilt 2007 · S/N 18282043N7680GGulyash Michael J · Ukiah, CAS/N 17259380N7680KStripe Joseph R · Olympia, WAS/N 18052700N7680YMeekin Michael J · Palmer, AKBuilt 1961 · S/N 1850190N7681GCompass Aviation Inc · Shelby, NCBuilt 1970 · S/N 17259381N7681KNewberry Robert L · Lakeland, FLBuilt 1976 · S/N 18052701N7681UTunnel Electric Inc · Shingle Springs, CAS/N 21064975N7682MVan De Hei Mike · Pioneer, CABuilt 1959 · S/N 55982N7682TPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 17249073N7682UTech Flight Corp · South Hamilton, MAS/N 15077808N7682XRosenlof Dean F · Tempe, AZBuilt 1961 · S/N 17248182N7683GBalgoyen James T · Charlotte, MIBuilt 1970 · S/N 17259383N7683MHarmon Katlyn E · Gypsum, COS/N 55983N7683TCleary Michael A · Folsom, CABuilt 1960 · S/N 47283N7684KWard Keven R · Juneau, AKBuilt 1976 · S/N 18052702N7685AAnderson Clarence D Trustee · Anchorage, AKBuilt 1956 · S/N 32582N7685NFranklin Construction Inc · Chico, CAS/N 21063247N7687MMckown Kevin · Edgewood, NMS/N 55987N7687XMost Ronald · Apple Valley, CABuilt 1961 · S/N 17248187N7688MCampbell Ronald M · Upland, CABuilt 1959 · S/N 55988N7688TRodgers Bruce W · Pine Bluff, ARBuilt 1960 · S/N 47288N7688XMauldin Gary · Navajo Dam, NMBuilt 1960 · S/N 17248188N7689GMerrihew Jerry R · Ashby, NEBuilt 1970 · S/N 17259389N7689MMoreland Wesley · Mckinney, TXBuilt 1959 · S/N 55989N7689TMcclatchey Steven C · Linn Grove, IABuilt 1960 · S/N 47289N768SPLast Sea LLC · Saint Augustine, FLBuilt 2001 · S/N 172S8700N7690GScott Kyle J · Fort Morgan, COBuilt 1973 · S/N 15074716N7690TFranwick Industries LLC · Westbrook, CTBuilt 1960 · S/N 47290N7690XNeu Aviation LLC · Benton, LABuilt 1960 · S/N 17248190N7691DScout Aviation LLC · Homer, AKBuilt 1968 · S/N U206-1015N7691GBorden John A · Hoover, ALBuilt 1974 · S/N 18263327N7691MKoch Doug L · Wentworth, SDBuilt 1959 · S/N 55991N7691TDewitt Dennis M · Collinsville, ALBuilt 1960 · S/N 47291N7691XAndrade Nelson J · Redwood City, CABuilt 1960 · S/N 17248191N7692MMeyer Lynn O · Olathe, KSBuilt 1959 · S/N 55992N7692UDaso Manuel Sebastian · Spring Hill, FLBuilt 1976 · S/N 15077818N7692XJohnson Kevin D · Eldorado, KSS/N 17248192N7693GA J L M Partners LLC · Hershey, NEBuilt 1970 · S/N 17259393N7693MBaumann William E · Eureka, NVBuilt 1959 · S/N 55993N7693TButler Richard A · Gatesville, TXFirst renewal noticeBuilt 1960 · S/N 47293N7693UPerkins Robert A · New Richmond, WIS/N 15077819N7694THeaps John J · Dunlap, IABuilt 1960 · S/N 47294N7694UDanfelt Eric A · Bend, ORBuilt 1976 · S/N 15077820N7694VMarkowski John J · Guilford, CTBuilt 1976 · S/N 177RG0904N7695GPfeifer Kenneth J · Bridger, MTS/N 17259395N7695MOboyle Thomas R · Manhattan, KSBuilt 1959 · S/N 55995N7696MForchtner Thomas J · Oklahoma City, OKBuilt 1959 · S/N 55996N7697GFlight School Inc · Spring, TXBuilt 1970 · S/N 17259397
Back to AD 79-10-14 R1