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.

N8421RRoberts Darren C · Zionsville, INBuilt 1966 · S/N 28-22298N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388N84227Jernigan Alex E · Warrensburg, MOBuilt 1981 · S/N 28-8190298N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389N8422HDeevers Howard A · Tucson, AZBuilt 1981 · S/N 28-8116292N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622N8422NCenter Flying Inc · Lancaster, CABuilt 1981 · S/N 28-8190296N8422RTascarella William M · Quakertown, PABuilt 1966 · S/N 28-22299N8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXBuilt 1965 · S/N 28-2649N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390N8423DKearney Rick G · Amity, PABuilt 1957 · S/N 22-5678N8423LYoung James A · Toledo, WAS/N 17256623N8423WGillanders Kenneth William · Carson City, NVBuilt 1965 · S/N 28-2650N8424Huston Charles D · Austin, TXBuilt 1974 · S/N AGE-150N84243Sjoberg Donald E · Poteau, OKBuilt 1969 · S/N 17258393N8424LMcgreen John R · Albany, NYBuilt 1968 · S/N 17256624N84250Wick James R · Canon City, COBuilt 1969 · S/N 17258395N84256Registered aircraftBuilt 1969 · S/N 17258396N8425FSons Aviation LLC · Moody, ALBuilt 1976 · S/N 28-7715259N8425WBenner James R · Goshen, INBuilt 1965 · S/N 28-2652N84265West Gerald Lee · Two Harbors, MNBuilt 1969 · S/N 17258399N84267Shields Debra M · York, SCBuilt 1969 · S/N 17258400N8426POta Paul T · Grayslake, ILBuilt 1964 · S/N 24-3674N8426RBryant Bryce E · Evans City, PABuilt 1966 · S/N 28-22303N84271Anderson Operations LLC · Fallon, NVBuilt 1969 · S/N 17258402N84275Rodriguez Norberto R · Inwood, NYBuilt 1969 · S/N 17258404N84278Ap Air LLC · Wilmington, NCBuilt 1969 · S/N 17258405N8427DEastin Toby M · Jefferson City, MOS/N 22-5682N8427GWarrior II Ltd · Des Plaines, ILBuilt 1981 · S/N 28-8116297N8427KInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116299N8427RLopez Trinidad V · El Cajon, CAS/N 28-22305N8427TPierce Rex G · Shorewood, ILBuilt 1981 · S/N 28-8190302N8427WKsiezyk Donald G · Wadsworth, OHBuilt 1981 · S/N 28-8290030N84289Angelov Ruslan P · Mount Prospect, ILS/N 17258410N8428BHiggins James · Oxford, NCBuilt 1981 · S/N 28-8190304N8428DMullen Samuel J · Fairbanks, AKBuilt 1957 · S/N 22-5683N8428HWilson Jessica D · Gallipolis Ferry, WVBuilt 1981 · S/N 28-8190305N8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1981 · S/N 28-8190307N8428WAces High Aviation LLC · Casper, WYBuilt 1965 · S/N 28-2656N84293Nwa Flyers LLC · Missoula, MTBuilt 1969 · S/N 17258411N84299Phoenix Aviation Holdings LLC · Crystal Beach, FLS/N 17258413N8429DDickson Wayne K · Luthersville, GABuilt 1957 · S/N 22-5684N8429WCleveland Tommy E · Mountain View, ARBuilt 1965 · S/N 28-2659N842BJMaster Trade LLC · Detroit, MIBuilt 1977 · S/N 28-7716252N842LBBlair Lynward E · Headland, ALBuilt 1976 · S/N 252-76N842PTTemple Peter L · Harrisville, NHBuilt 2022 · S/N 67PN842RBLowcountry Flight LLC · Johns Island, SCBuilt 1969 · S/N 17258377
Back to AD 79-10-03 R2