OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N913CVMansfield Douglas M · East Gull Lake, MNBuilt 2002 · S/N CV-3N913FBrooks Benjamin · Little Rock, ARBuilt 1991 · S/N 1801N913LKKeller Logan · Vale, ORBuilt 2021 · S/N 70MN913MSCukovic Naim · Portsmouth, NHBuilt 1976 · S/N 28-7715094N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011N914Daiber Marcus · Jefferson, GABuilt 1972 · S/N 388HN9140DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 18-6529N9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195N9141RInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 1323N9141VFlitton Mark S · Enterprise, ALS/N 690010N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196N9142KSwales Michael K · Harrisville, MIBuilt 1976 · S/N 28-7615177N9143DHellberg Farms LLC · Lowden, WAS/N 18-6533N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197N9143VCrazy Mountain Cub LLC · Helena, MTBuilt 1988 · S/N 1809002N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029N9145JBonertz Brian J · Muscatine, IAS/N 28-3200N9145VRoe Cameron · Salt Lake City, UTBuilt 1969 · S/N 690011N9146DSmith Paul G · Wasilla, AKBuilt 1958 · S/N 18-6536N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201N9146KBartlett Jesse Charles · Henderson, NVBuilt 1976 · S/N 28-7615178N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9146VWood David Allen · Conyers, GABuilt 1969 · S/N 690025N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787N9149JJones Lynn · Birmingham, ALS/N 28-3204N9149SBurnard Russell J · Seward, AKBuilt 2001 · S/N 456RN914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914THanley Stuart · Hollywood, FLBuilt 1960 · S/N TD-347N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N9150DFitzgerald Larry · Fairbanks, AKBuilt 1958 · S/N 18-6540N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N91518Hatfield Timothy E · Parowan, UTBuilt 1996 · S/N 3121N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090N9152KHangar 9 Inc · Aberdeen, SDBuilt 1976 · S/N 28-7615179N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N9153VRegistered aircraftBuilt 1969 · S/N 690027N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213
Back to AD 79-10-03 R2