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.

N574BFKrusemark Emma A · Pender, NES/N 28-25047N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574DGSmith Bruce Martin Trustee · Spirit Lake, IDBuilt 2003 · S/N 777N574FLDynamic Aviators LLC · San Angelo, TXS/N 28-7125421N574KRPhoenix Rising Aviation Inc · Bartlesville, OKS/N 22-5273N574LBThoft Matthew M · Wasilla, AKBuilt 1977 · S/N 18-7709109N57505Archipelago Group Llcc · Alexandria, VAS/N 267-73N5750QMelnyk Richard V · Uniontown, PABuilt 1965 · S/N 3077N57517Du Aircraft Leasing · Green Bay, WIS/N 526-73N57519L & L Flying Inc · Glen Allan, MSS/N 532-73N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826N57522Baker Brad L · Salcha, AKBuilt 1973 · S/N 534-73N5752QJackson John E · Oak Harbor, WABuilt 1965 · S/N 3078N5752URiggin Flight Service · Madison, SDS/N 28-26575N57532N57532 LLC · Wasilla, AKS/N 18-7809089N57534Sale Reported · Drake, NDSale reported, pending cancellationBuilt 1978 · S/N 18-7809090N5753FRauch Jack · San Rafael, CABuilt 1968 · S/N 28-25056N5753WRegistration Pending · Royse City, TXRegistration pendingS/N 28-1490N5753ZFereday Richard R · Mccall, IDBuilt 1963 · S/N 18-8026N5754DRocca John · Box Elder, SDS/N 22-4454N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5754FStorm Joseph K · Enumclaw, WABuilt 1968 · S/N 28-25057N5754QHamm Martin C · Southport, NCBuilt 1965 · S/N 3079N5754UAuthement Michael Ray · Pecos, TXBuilt 1969 · S/N 28-26577N57550Freese Marc Alan · Fulda, MNBuilt 1977 · S/N 18-7709122N57555Norden Paul E · Anchorage, AKS/N 18-7709124N5755DNathan Timothy A · Arnold, MDBuilt 1956 · S/N 22-4455N5755UKyzer Aviation Holdings LLC · Fort Mill, SCS/N 28-26579N5755WSchmidt Mia H · Van Nuys, CABuilt 1963 · S/N 28-1499N57562Sitter Timothy L · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809093N5756FStewart Larry E · Seymour, INBuilt 1968 · S/N 28-25059N5756QDominguez Juan · Austin, TXBuilt 1965 · S/N 3080N5756YLamascus Mark S · King City, CAS/N 18-8325N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935N5757FWaletzko David L · Avon, MNBuilt 1968 · S/N 28-25060N5757WN63e LLC · Fallon, NVBuilt 1964 · S/N 28-1527N5758FTipnis Zachary Arjun · Troy, NYS/N 28-25061N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833N5758QAviation Forza Inc · Pompano Beach, FLS/N 3081N5758VNelson Mike R · Philip, SDS/N MB-41N5759FGelnett Dean A · Lansdale, PABuilt 1968 · S/N 28-25062N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836N5759WChimera Air Inc · Maumee, OHBuilt 1964 · S/N 28-1529N575ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496203N575BBZielich Matthew · Glendale, AZBuilt 1975 · S/N 28-7515378N575DSGotfredson Allen S · Ten Sleep, WYBuilt 1975 · S/N 885-75N575PAGrw Air Services LLC · Springport, INBuilt 1975 · S/N 28-7525330N575RVEzzo Donna L · Lancaster, NYBuilt 2006 · S/N 70479N575TDDahl Russell · Nashua, MTBuilt 1976 · S/N 17268034
Back to AD 79-10-03 R2