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.

N2723LJkr7 LLC · The Dalles, ORBuilt 1967 · S/N 17255923N2724CN2724c LLC · Levering, MIBuilt 1954 · S/N 26268N2724DRojas Conrad · Fairbanks, AKBuilt 1952 · S/N 25266N2724FIsley Rocky · Lacey, WABuilt 1965 · S/N 18256824N2724JHorseshoe Air LLC · Pella, IAS/N 185-1474N2724REcho Flight LLC · Tucson, AZBuilt 1998 · S/N 18280322N2724UGarner Harry W · Le Roy, NYBuilt 1963 · S/N 17250324N2724XParrott Charles F · Bridgton, MEBuilt 1965 · S/N 18051524N2725F85 Charlie Papa LLC · Phoenix, AZBuilt 1965 · S/N 18256825N2725JQuinn Timothy · Bountiful, UTBuilt 1974 · S/N A1500572N2725LFulenchek Raymond D · Sherman, TXS/N 17255925N2726DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 25268N2726GFarmhouse Aerospace LLC · Laurel, MTBuilt 1959 · S/N 52026N2726USampan Aviation LLC · Greenville, TXS/N 17250326N2726VTurpin Michael · Rcho Sta Marg, CABuilt 1975 · S/N 177RG0673N2726XSuttman Robert · Dayton, OHBuilt 2007 · S/N 18281913N2727CWennersten Donald A · Ann Arbor, MIBuilt 1954 · S/N 26271N2727DMcfarlane Scott J · Denair, CABuilt 1952 · S/N 25269N2727QEstes Gregory T · Jonesville, VABuilt 1967 · S/N 18257927N2727SMiller Colin B · Fargo, NDBuilt 1967 · S/N 15066627N2727URoy Justin C · Georgetown, OHBuilt 1963 · S/N 17250327N2727VFitzgerald Kevin C · College Station, TXS/N 177RG0674N2728BBig Island Gravity LLC · Kapaau, HIBuilt 1959 · S/N 52028N2728CMeidl Jared · Crivitz, WIS/N 26272N2728JWahlberg · Pearland, TXBuilt 1974 · S/N A1500573N2728LPotter Mark H · Santa Rosa, CABuilt 1967 · S/N 17255928N2728UCatsakis Andrew W · Lovettsville, VABuilt 1963 · S/N 17250328N2728XUsda Forest Service Fepp · Trenton, NJBuilt 1965 · S/N 18051528N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARBuilt 1965 · S/N 18256829N2729QCraft Phyllis C · Damascus, GABuilt 1967 · S/N 18257929N2729SDates Lauren C · Red Creek, NYBuilt 1967 · S/N 15066629N2729UDenair Inc · Canandaigua, NYBuilt 1963 · S/N 17250329N272BBearair II LLC · Libertyville, ILBuilt 1975 · S/N 18264193N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857N272FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13454N272HFHorizon Flight Center LLC · Chesapeake, VABuilt 2022 · S/N 172S12776N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439N272LPAa-Aero Inc · Fairfield, NJBuilt 2002 · S/N 172S9272N272MMTownair LLC · Sandy, UTBuilt 2006 · S/N 172S10105N272NSKroeber Thomas · Pawlet, VTBuilt 1980 · S/N 18267402N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914N272SBBailey Aviation LLC · Chesapeake, VABuilt 2001 · S/N 172S8908N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939N272SPBlue Ryan LLC · Billings, MTBuilt 1998 · S/N 172S8016N272TLSanders Flight Training Center · Jasper, ALS/N 17270719N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803N272VWigley Ben Jr · Huntington, ORBuilt 1956 · S/N 33362N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677
Back to AD 79-10-14 R1