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.

N828TATravelaire Service Inc · Wilmington, DEBuilt 1973 · S/N 18502245N828WWMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2016 · S/N 172S11730N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168N8290BSchooman Clarence G · Marion, TXBuilt 1957 · S/N 36090N8290LPretty Plane LLC · Nixa, MOBuilt 1967 · S/N 17256490N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8291AScott William M · Spring Hill, FLBuilt 1952 · S/N 25143N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177N8291GBullock Brooks M II · Cartersville, GABuilt 1971 · S/N 177RG0191N8291LUsglap LLC · Fort Morgan, COBuilt 1967 · S/N 17256491N8291MElbs Aviation LLC · Pell City, ALBuilt 1976 · S/N 18264581N8291SSipes Jacob L · Sunbury, OHBuilt 1965 · S/N 15061891N8291TKnight James M · Wilton, CABuilt 1961 · S/N 17556991N8291UBarnett William M · Rolla, MOBuilt 1964 · S/N 17252191N8291XChandler Christopher G · Cooperstown, NYS/N 17248791N8292Gulf Coast Helicopters Inc · Pearland, TXBuilt 1997 · S/N 17280048N8292ADeforest Dennis L · Hamilton, INBuilt 1952 · S/N 25144N8292BEagle Eye Aerial Imaging LLC · Chagrin Falls, OHS/N 36092N8292EP&N Corp · Marion, IAS/N 17272178N8292LBrown Troy M · Austin, TXBuilt 1967 · S/N 17256492N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292N8292QFitzgerald John A Jr · Ester, AKS/N 18503643N8292SStephens Ralph W · Reno, NVBuilt 1964 · S/N 18255792N8292URettkowski Brady A · Hermiston, ORBuilt 1964 · S/N 17252192N8292XHeadings Daniel E · Salem, ORBuilt 1961 · S/N 17248792N8292ZBenedick Yachal O · Wilsey, KSBuilt 1963 · S/N 205-0292N8293AMcgreevy Stephen P · Poplar Grove, ILBuilt 1952 · S/N 25145N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154N8293TNational Refining Co · Owosso, MIBuilt 1962 · S/N 17556993N8293ZAv8r Aviation LLC · Yakima, WABuilt 1963 · S/N 205-0293N8294FWalters Craig S · Lake City, FLS/N 15064394N8294SLogtime Flight LLC · Lancaster, TXBuilt 1965 · S/N 15061894N8294XFranco Stephen B · Chicago, ILBuilt 1961 · S/N 17248794N8295AHairston Marvin A · Peck, IDBuilt 1952 · S/N 25147N8295BSkywriters Inc · Ferndale, WABuilt 1957 · S/N 36095N8295EFrump Leasing Inc · Newburgh Heights, OHS/N 17272181N8295UCrawfish Co LLC · Starkville, MSBuilt 1964 · S/N 17252195N8296EMosbach Rene A · Sandia, TXBuilt 1979 · S/N 17272182N8296GKiehl Austin J · Winnett, MTBuilt 1973 · S/N 18801293N8297BSchler Joseph B · Reno, NVBuilt 1957 · S/N 36097N8297EConaway Scott J · Traverse City, MIBuilt 1979 · S/N 17272183N8297SBergmann Joshua A · Menomonie, WIBuilt 1965 · S/N 15061897N8297UMcburney Richard O · Hudson, NCBuilt 1964 · S/N 17252197N8297ZMartinez Gabriel M · Santa Fe, NMBuilt 1963 · S/N 205-0297N8298EAberdeen Flying Service · Aberdeen, SDBuilt 1979 · S/N 17272184N8298FAustin Leslie M · Greenville, INBuilt 1966 · S/N 15064398N8298UCollins Roberto · Naples, FLBuilt 1976 · S/N 15077915N8299AStevenson James W · Oregon, WIBuilt 1952 · S/N 25151N8299BJohnston Keith G · Honolulu, HIBuilt 1951 · S/N 36099
Back to AD 79-10-14 R1