OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,397

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.

N140BCN504fl LLC · Killeen, TXBuilt 1971 · S/N 28-7125313N140BKFrauenhoffer Kenneth E · Woodruff, WIBuilt 1975 · S/N 28-7525314N140BWWeselmann Brian David · Edgewater, FLBuilt 2001 · S/N 2908N140CKRegistered aircraftFirst renewal noticeBuilt 1969 · S/N 28-26210N140DDBe Right Back Aviation LLC · Billings, MTBuilt 1971 · S/N 28-7125145N140ERDaly John F Jr · Simpsonville, SCS/N 1529N140FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290175N140FLYocum Stuart J · Kingman, AZBuilt 1971 · S/N 28-7125111N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539N140HACarros Dale A · Cape Charles, VABuilt 1968 · S/N 28-25354N140HCMurphy David B · Germantown, MDBuilt 1969 · S/N 28-25436N140JFMeriden Aviation Center LLC · Meriden, CTBuilt 1973 · S/N 28-7325416N140JNMfd Aviation Inc · Middletown, DEBuilt 1973 · S/N 28-7325244N140KW47 North Aviation LLC DBA · Wenatchee, WAS/N 28-7625121N140LRutten Paul J · Pine Island, MNBuilt 1967 · S/N 28-23057N140MDDesotel Mark · Fairfax, IABuilt 1973 · S/N 28-7425149N140NCRamirez Jesus Nicolas · Miami, FLBuilt 1975 · S/N 28-7525137N140NDCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841206N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241N140PLBennett Daniel C · Atlantic Beach, FLBuilt 1973 · S/N 28-7325663N140SBSkyfusion II LLC · Atlanta, GABuilt 1969 · S/N 28-25681N140SHThomas Raymond · Daytona Beach, FLBuilt 1967 · S/N 28-22668N140SMGarrett Mike · Okla City, OKBuilt 1990 · S/N 20353N140SNRomey Shelley · Newnan, GABuilt 1965 · S/N 28-21153N140WMBlue Wings LLC · Rossville, TNBuilt 1972 · S/N 28-7305052N140WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276201N140ZGitomirski Michael L · Moseley, VABuilt 1965 · S/N 28-20617N1411Grubb Logan · Faulkton, SDBuilt 1963 · S/N 1111N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080N1414VMoeller Rita L · Rescue, CABuilt 1974 · S/N 17263559N1415USale Reported · Miami, FLSale reportedBuilt 1976 · S/N 17267083N14167Davis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18-7409097N1416ESalem Pilots Association · Salem, ORBuilt 1978 · S/N 17270989N1416TRegistered aircraftS/N 28-7225507N1416UEddy Elizabeth H · Tunbridge, VTBuilt 1976 · S/N 17267084N1417TWood Andrew Calvin · Tallahassee, FLBuilt 1972 · S/N 28-7225508N1417UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267085N1417VSkyhawk Aviation LLC · Rutherfordton, NCS/N 17263562N1418TZucchi Steven · Ephrata, PABuilt 1972 · S/N 28-7205295N1418VBeverly Flight Center LLC · Middleton, MABuilt 1974 · S/N 17263563N141ACGann Steve W · Southaven, MSS/N AA5-0743N141AREpp Robert Jackson · New Kent, VAS/N 8060CN141AVMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490107N141CHRegistered aircraftBuilt 1979 · S/N 324-79N141DFNaumann Reuben D · Blackwell, MOS/N 19011CN141ERStein Richard M · Sierra Vista, AZS/N 1335N141FQCross Daniel · Windham, NHS/N 28-8290176N141JStocks Judy K Trustee · Lubbock, TXBuilt 1999 · S/N 23376N141JSGeurin Ronnie C · Murray, KYBuilt 1979 · S/N 383-79N141KRScanlon John (Jack) · Palos Heights, ILBuilt 1972 · S/N 28-7225206
Back to AD 79-10-03 R2