OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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-03-R2')
    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-03-R2')
  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.

N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439N5565FHenley Brett · Manchester, TNFirst renewal noticeBuilt 1968 · S/N 28-24905N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438N5566UKingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26293N5566WRegistered aircraftBuilt 1962 · S/N 28-660N55671Brown Christopher A · Tigard, ORBuilt 1973 · S/N 28-7305440N55673Smith Gordon H · Racine, WIBuilt 1973 · S/N 28-7305442N55675Sykes Kinsley · Palm Coast, FLBuilt 1973 · S/N 28-7305443N5567MAnderson Layne A · Wichita Falls, TXBuilt 1967 · S/N 092N5567QRicol Aviation LLC · Naples, FLBuilt 1965 · S/N 2972N5567W3k Weavers Investment Group LLC · Shelbyville, KYBuilt 1962 · S/N 28-661N55680Madsen Pest Management LLC · Siren, WIBuilt 1973 · S/N 28-7325466N55687Rieber Russell C · Stockton, CABuilt 1973 · S/N 28-7305444N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632N5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationS/N 28-662N55691Brown Alan · Lugoff, SCS/N 28-7305447N5569MWichita Flight Training LLC · Wichita, KSBuilt 1967 · S/N 079N5569QBrian C Elbert · Rochester, NHBuilt 1965 · S/N 2973N5569UJapikse Bert · Pawleys Island, SCBuilt 1970 · S/N 28-26884N5569WBridges Michael D · Clovis, NMBuilt 1962 · S/N 28-663N556FLKarg Asset Management LLC · Pocahontas, ARS/N 28-7125395N556JRSemmig Jeffrey C · Oceanside, CABuilt 1987 · S/N 1144N556MKurdzel Mark A · Chattanooga, TNS/N 10150N556PAAviator Corp · Wilmington, DEBuilt 1972 · S/N 28-7225477N556PCChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 4496074N556PSPotter Mark W · Portland, ORBuilt 1998 · S/N 124N556SHNovember Alpha LLC · Dover, DEBuilt 2004 · S/N 3581N55701Level Up Aviation LLC · Newton, ALBuilt 1973 · S/N 28-7325460N55702Seay Horace M · Desoto, TXBuilt 1973 · S/N 28-7325461N55706Camp Justin P · Edwall, WABuilt 1973 · S/N 28-7305448N5570FCherokee Adventure Corp · Wilmington, DEBuilt 1968 · S/N 28-25006N5570MFlythebat.Com LLC · Chicago, ILBuilt 1967 · S/N 135N5570URegistration Pending · Mesa, AZRegistration pendingBuilt 1969 · S/N 28-26299N55716Norby Aviation LLC · Hopkinton, MABuilt 1973 · S/N 28-7325465N55719Coffey County Airport · Burlington, KSBuilt 1973 · S/N 287325467N5571MEdwards Larry N · Saint Joseph, MOBuilt 1967 · S/N 105N5571QBerry Charles P · Monroe, NCBuilt 1965 · S/N 2974N5571VColeman Douglas E · Tallahassee, FLBuilt 1959 · S/N 23-1784N55722Cactus Aero LLC · Haslet, TXBuilt 1973 · S/N 28-7305451N55724Parker David G · Bristol, TNBuilt 1973 · S/N 28-7305452N5572UPoor Farmer Aviation LLC · Saint Marys, OHBuilt 1969 · S/N 28-26302N5572VWood Charles S · Fox Island, WABuilt 1977 · S/N 28-7725241N55730K&D Ip LLC · Chicago, ILBuilt 1973 · S/N 28-7325468
Back to AD 79-10-03 R2