OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N24470Bauer Richard E · Livermore, CABuilt 2000 · S/N 18280823N2447BSilver Express Co · Miami, FLBuilt 1999 · S/N 17280801N2447CLevya Kevin S · Wilbur, WAS/N 30747N2447DAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280803N2447GTroyer Thomas · Chickamauga, GABuilt 1959 · S/N 51747N2447QEaton James B · Green Bank, NJBuilt 1966 · S/N 18257647N2447UMccauley Stephen M · Buckley, WAS/N 17250047N2447YNeu Aviation LLC · Benton, LABuilt 1962 · S/N 17249747N24480Moscair LLC · Nashville, TNBuilt 2001 · S/N 18280932N24483Fly 172r LLC · Peoria, AZBuilt 2000 · S/N 17280982N2448BChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280978N2448DDrake Dwayne D · Fairbanks, AKS/N 20600N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288N2448FFlynn Charles P · Anchorage, AKBuilt 1965 · S/N 18051648N2448QEuroaviation Inc Trustee · KematenS/N 18257648N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348N2448YTennison William T · Osprey, FLBuilt 1962 · S/N 17249748N2449AWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280632N2449CAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 1999 · S/N 18280633N2449DEdwards Samuel W · Shady Shores, TXBuilt 1952 · S/N 20601N2449FBoccuti Salvatore A · Ambler, PABuilt 1966 · S/N 18051650N2449GDimzoff Justin W · Hines, ORFirst renewal noticeBuilt 1959 · S/N 51749N2449JSkydance Northwestern Inc · Minden, NVBuilt 1982 · S/N 18504364N2449LSteier Tim · Salome, AZBuilt 1966 · S/N 17255649N2449QAcme Aircraft Co III LLC · Arvada, COBuilt 1966 · S/N 18257649N2449TElevation Club Air LLC · Hunting Valley, OHBuilt 2005 · S/N 18281727N2449UCurl Eric A · Olympia, WABuilt 1963 · S/N 17250049N244AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13224N244DAPrairie Winds Aviation LLC · Overland Park, KSBuilt 1972 · S/N 17261294N244DBAnsari Ramin · West Lafayette, INBuilt 1976 · S/N 18265043N244EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13283N244FRSmith Larry · Ulysses, KSBuilt 1978 · S/N 17270490N244HEDubin David A · Tucson, AZS/N 21058990N244RPMitchell N Andrew · Bridgeport, CTBuilt 1973 · S/N 182-62311N244RTAircraftwings LLC · Las Piedras, PRS/N 17261037N244SPToth Douglas F · Scottsdale, AZBuilt 1963 · S/N 205-0379N2450GMathieson Erik L · Kapowsin, WABuilt 1959 · S/N 51750N2450LRobinson Brandon J · Winona Lake, INS/N 17255650N2450QSherry Mark A · Walla Walla, WABuilt 1966 · S/N 18257650N2450XBackcountry LLC · Ennis, MTBuilt 1965 · S/N 18256350N2451CWilliams Marc Alomzo · Fallon, NVBuilt 1954 · S/N 30751N2451FMontana Rose 185 LLC · Cornwall, VTBuilt 1965 · S/N 18051652N2451GHerring Gary A · Elverson, PAS/N 51751N2451HBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18280950N2451LSky K Inc · Wilmington, DES/N 17255651N2451NHoelscher Carl D · Garden City, TXBuilt 2001 · S/N 17280989N2451QAviation Mission 3:16 LLC · White Lake, MIBuilt 1966 · S/N 18257651N2451UVandyke John D Trustee · Hudsonville, MIBuilt 2001 · S/N 18280943N2451ZMasciola Michael J · Dunn Loring, VABuilt 2001 · S/N 18280949N24529Rainier Flight Service LLC · Renton, WABuilt 2001 · S/N 17281014
Back to AD 79-10-14 R1