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.

N8346LJones Mark B · Angleton, TXBuilt 1968 · S/N 17256546N8346XMessinger Donald C · Wasilla, AKBuilt 1961 · S/N 17248846N8346ZHerrick William L · Howell, MIBuilt 1963 · S/N 205-0346N8347GKeyes Mitchell R · Cornelius, NCBuilt 1965 · S/N 15062447N8347LSchye Ted E · Billings, MTBuilt 1968 · S/N 17256547N8347SShaffer Dyke T · Santa Rosa, CABuilt 1965 · S/N 18256447N8347ULeupp Matthew C · Canal Winchester, OHS/N 17252247N8348AKelly David M · Issaquah, WAS/N 25200N8348BSogg Steven L · Auburn, WABuilt 1957 · S/N 36148N8348LPrice William B · Lamar, SCBuilt 1968 · S/N 17256548N8348MWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280589N8349ASudtell Chad S · Wasilla, AKS/N 25201N8349EArment C Randall · Valentine, NEBuilt 1979 · S/N 17272191N8349MMarker Nathan E · Amherst, OHBuilt 1969 · S/N A1500049N8349TStefan Terrence J · Dodge City, KSBuilt 1961 · S/N 17557049N8349UMassey Jay C · Mineral Wells, TXBuilt 1964 · S/N 17252249N8349XRoberts Thomas Randy · Amarillo, TXBuilt 1961 · S/N 17248849N834CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281303N834DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12567N834KXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2011 · S/N 172S11140N834ZGroshel Joseph C · State College, PABuilt 1955 · S/N 32038N8350APhillabaum Stephen D · Deer Park, WABuilt 1952 · S/N 25202N8350BTatum Travis · Gatesville, TXBuilt 1957 · S/N 36150N8350JSustarich Stephen M · Ketchikan, AKS/N 15066250N8350SRegistration Pending · Wheatland, CARegistration pendingBuilt 1965 · S/N 18256450N8350UColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17252250N8350XLee Daryl P · Poplarville, MSBuilt 1961 · S/N 17248850N8351JRkd Aviation Services Inc · Dallas, TXBuilt 1967 · S/N 15066251N8351LPlane Junkies LLC · Dover, DEBuilt 1968 · S/N 17256551N8351MWheaton Eric J · Gig Harbor, WAS/N A1500051N8351TLazic Nina · Wilmington, OHBuilt 1962 · S/N 17557051N8351URappa Colin C · Nazareth, PAS/N 17252251N8351XSky Rangers Inc · Stockton, CAS/N 17248851N8352AWood Jeremy D · Girdwood, AKBuilt 1952 · S/N 25204N8352BRoark Larry W · Wheatland, INBuilt 1957 · S/N 36152N8352JByrds Wholesale Inc · Clayton, NCS/N 15066252N8352LFielding David · Scarborough, MES/N 17256552N8352MOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1969 · S/N A1500052N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213N8352SMacwilliamson Roger · Hollister, CABuilt 1965 · S/N 18256452N8352UVirani Shamshuddin · Fayetteville, GAS/N 17252252N8352XSchmid William J · Anchorage, AKBuilt 1961 · S/N 17248852N8353BRodriguez Antonio M · Presidio, TXFirst renewal noticeBuilt 1957 · S/N 36153N8353GHove Jeffrey P · Saint Paul, MNBuilt 1965 · S/N 15062453N8353XAcme Racing LLC · Overland Park, KSBuilt 1961 · S/N 17248853N8353ZMccoy Jesse Jacob · Cabot, ARBuilt 1963 · S/N 205-0353N8354BTri Flight LLC · Cottonwood, MNBuilt 1957 · S/N 36154N8354LEast Texas Imperial Petroleum LLC · Flint, TXBuilt 1968 · S/N 17256554N8354SNorthrop Kimberlei A · Spokane, WABuilt 1965 · S/N 18256454N8354UErvin Jerome · Lometa, TXBuilt 1964 · S/N 17252254
Back to AD 79-10-14 R1