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.

N4704XHighsmith Michael D · Chipley, FLBuilt 1966 · S/N 15064754N4705DN4705d LLC · Oklahoma City, OKS/N 17272335N4705KYi Ranches Lp · Reedley, CABuilt 1975 · S/N 18263704N4705NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267295N4705UIverson James P · Soldotna, AKBuilt 1964 · S/N 18051405N4706BCollegiate Peaks Aviation LLC · Salida, COBuilt 1955 · S/N 31604N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336N4706KWitman Michael R · Milliken, COBuilt 1975 · S/N 18263705N4706NReef Clipper LLC · Pittstown, NJS/N 18267296N4706QRegistration Pending · Polson, MTRegistration pendingBuilt 1966 · S/N 185-1160N4706XKey Joseph E · Eltopia, WABuilt 1966 · S/N 15064756N4707BOlathe Spray Service Inc · Olathe, COBuilt 1955 · S/N 31605N4707KKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1975 · S/N 18263706N4707NBrandon Gregory R · Talking Rock, GAS/N 18267297N4707UZero Seven Uniform LLC · Palmer, AKBuilt 1964 · S/N 18051407N47084Tabor Peter C · Durango, COBuilt 1975 · S/N 18263783N4708NSkylane LLC · Billings, MTBuilt 1979 · S/N 18267298N4708QCole Brent R · Anchorage, AKBuilt 1966 · S/N 185-1162N4708VSpears Patricia C · Longmont, COBuilt 1953 · S/N 30165N4709DMagalsky Jacob J · Wilsall, MTBuilt 1957 · S/N 34809N4709KAlexander & Knizley Inc DBA · Mobile, ALBuilt 1975 · S/N 18263708N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013N470EHKirkwood Aeronautics LLC · Bicknell, INBuilt 1976 · S/N 15077831N470EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11599N470FSCustom Air International LLC · Homestead, FLBuilt 1973 · S/N 17262011N470HDChandler Dennis · Castroville, TXBuilt 1958 · S/N 55288N470JBLong James · Lyman, WYS/N 55041N470JCCox Patrick A · Torrance, CABuilt 1972 · S/N 18052265N470KMAv Chase LLC · Kirtland, OHBuilt 1998 · S/N 17280614N470PGreentree Aviation LLC · Sewell, NJBuilt 2004 · S/N 18281290N470RVFlyguys Aviation LLC · Bay City, MIBuilt 1968 · S/N 18259314N470UNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 17280415N470XSale Reported · Priest River, IDSale reportedBuilt 1965 · S/N 18256370N4710QNeitz Frank A · Bethel, AKBuilt 1966 · S/N 185-1164N4711CN4711c Inc · Stillwater, MNBuilt 1958 · S/N 36623N4711DTimmons Colton R · Parker, COBuilt 1957 · S/N 34811N4711EOregon Seaplanes LLC · Canby, ORBuilt 1979 · S/N 18503845N4711FCharter Equine Inc · Amarillo, TXBuilt 1966 · S/N P206-0311N4711KFhk Inc · Verona, PABuilt 1975 · S/N 18263710N4711VLiddy Alan A · Seabrook Island, SCS/N 172RG0368N4712DWerkema Thomas L · Caledonia, MIBuilt 1957 · S/N 34812N4712XBludorn Matthew R · Bryan, TXBuilt 1966 · S/N 15064762N4714BGeissler Charles H · Stanton, MNBuilt 1955 · S/N 31612N4714CGorman Aviation LLC · Bartlesville, OKBuilt 1979 · S/N 21063596N4714DWallace Brian T · Ogden, UTBuilt 1957 · S/N 34814N4714FHastings Stephen J · Palmer, AKS/N 17273075N4714KJld Air LLC · North Hampton, NHBuilt 1976 · S/N R1722016N4714NOwen John E · Aiken, SCBuilt 1979 · S/N 18267303N4714RAlford William J · Erie, MIBuilt 1979 · S/N 172RG0014N4714XHoffman Zachariah M T · Glendale, AZBuilt 1966 · S/N 15064764
Back to AD 79-10-14 R1