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.

N72BWChapman Oliver J · Wingo, KYBuilt 1950 · S/N 18-159N72BZParker Bruce C · Boise, IDBuilt 2010 · S/N 21N72CCCaterfull Inc · Miami Beach, FLBuilt 1975 · S/N 17266347N72CDG Brinkman Aviation Inc · Naperville, ILBuilt 1971 · S/N 28-7205013N72CVMccullough Wayne L · Greenfield, INBuilt 1958 · S/N 22-6115N72DEBaschwit Janie · Mooresville, INBuilt 1990 · S/N 001N72EBVector Airmotive LLC · Frisco, TXS/N 1211-95N72ERMaierhoffer Henry F Jr · Sylvania, GABuilt 1977 · S/N 17269501N72FYStrongpoint Real Estate Group LLC · Danville, PABuilt 1966 · S/N 3425N72HYTwedt Dennis · Baker, MTBuilt 2004 · S/N 2279N72JCBores Scott J · Huron, OHS/N 3324N72JNTroy I Mounts Md Inc · San Juis Obispo, CABuilt 1974 · S/N 17263882N72LFLarrabee Joey S Trustee · Holyoke, COBuilt 2005 · S/N 1388-2005N72LMCoonan Paul M · Huntsville, MOS/N AA5-0217N72MVBeck Douglas J · Lincoln, NEBuilt 2001 · S/N 80842BN72NEr Flight LLC · Reedsville, PABuilt 1971 · S/N 28-7205125N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PGFox William Casey Trustee · Pipe Creek, TXBuilt 1998 · S/N 631N72QTRegistered aircraftBuilt 1972 · S/N 365-72N72RMSparks Brian E · Monmouth, ORBuilt 1981 · S/N 8020CN72SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17272017N72STSierra Tango Air LLC · Senoia, GAS/N 17269433N72TGuazzerotti Fred · Mooresville, NCBuilt 1979 · S/N AA5B1086N72WLSingleton Colin · Walkerton, INBuilt 1994 · S/N 21063N72WRFratzke Nathan A · Sterling, AKS/N 18-8982N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N7300DClendaniel Randon · Desert Hot Springs, CAS/N 22-5087N7300LBarlow Tyrone J · St George, UTBuilt 1972 · S/N AA5-0230N7300WTaylor Robert P · Bothell, WABuilt 1963 · S/N 28-1064N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301DGrant Cary · Cave Creek, AZBuilt 1957 · S/N 22-5088N7301FMcpherson Alan · Big Bend Ntl Park, TXBuilt 1968 · S/N 28-25213N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301JJach Joshua Spenser · Grand Prairie, TXBuilt 1968 · S/N 28-24596N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7303FAyrey Elias · Bellingham, WABuilt 1968 · S/N 28-25215N7303JButtleman Robert L · Traverse City, MIBuilt 1968 · S/N 28-24588N73040Goulding Brian K · Roswell, GABuilt 1976 · S/N 17267247N73041Max Air Aviation LLC · Carrollton, GABuilt 1976 · S/N 17267248N73043Six Ten Ventures LLC · Cedar Hill, TXBuilt 1976 · S/N 17267250N7304FReid Brian S · Merced, CAS/N 28-25216N7304GChapman David C · Summersville, WVBuilt 1970 · S/N 17259004N7304JAdk Flying Club Inc · Ballston Spa, NYBuilt 1968 · S/N 28-24648N73054Blue Wings LLC · Spokane, WABuilt 1976 · S/N 17267253N7305JMallozzi Anthony M · Norwalk, CTBuilt 1968 · S/N 28-24636N73063Oregon State Flying Club · Corvallis, ORBuilt 1976 · S/N 17267256N73068Christensen Gary D · Alliance, NEFirst renewal noticeBuilt 1976 · S/N 17267259
Back to AD 79-10-03 R2