AD 97-01-13

Registered aircraft · 54,837

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:97-01-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
  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.

N3273EAnderson Thomas J · Big Bear City, CABuilt 1978 · S/N 17271486N3273MLindeen Michael · Anchorage, AKBuilt 1967 · S/N 185-1210N3273SHepfer John E DBA · Midland, TXBuilt 1964 · S/N 18255773N3273TSommers Bradley D · Robinson, KSBuilt 1967 · S/N 17700573N3274DMcroberts David M · Washoe, NVBuilt 1955 · S/N 32072N3274EBitzer John · Cologne, MNBuilt 1978 · S/N 17271487N3274JOgrady John Thomas · West Chicago, ILBuilt 1966 · S/N 15065974N3274LHk Ventures LLC · Paynesville, MNS/N 17256174N3274TRinkle Michael G · Sussex, NJBuilt 1967 · S/N 17700574N3275CMoore Hazel Grace · Boise, IDBuilt 1978 · S/N R18200263N3275DCrystoff James J · Kodiak, AKBuilt 1955 · S/N 32073N3275LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 17256175N3276DFarkas Jonathan · Mukwonago, WIBuilt 1955 · S/N 32074N3276SLewinsky Marlon · Carrollton, TXBuilt 1964 · S/N 18255776N3276UNk Innovations LLC · Spokane, WABuilt 1963 · S/N 18254676N3277CSandstrom Mark R · Minot, NDBuilt 1978 · S/N R18200264N3277JBranson William E · Stokesdale, NCBuilt 1966 · S/N 15065977N3277LDeshpande Peter N · Eugene, ORBuilt 1967 · S/N 17256177N3277SBayless Smoky · Coronado, CABuilt 1964 · S/N 18255777N3277YLapinsky Richard G · Los Lunas, NMBuilt 1962 · S/N 18254277N3278JSarrafi Frank H · Tarzana, CABuilt 1966 · S/N 15065978N3278LPeterson Donald A · Ajo, AZBuilt 1967 · S/N 17256178N3278SStrong Brian S · Southport, NCBuilt 1964 · S/N 18255778N3278UCarver Thomas G · St Maries, IDBuilt 1963 · S/N 18254678N3278VMathison John · Vancouver, WABuilt 1974 · S/N 15076448N3279CHunsucker Michael A · Seguin, TXS/N R18200265N3279DDavies James E · Eagle, IDBuilt 1955 · S/N 32077N3279LDomnarski Michael J · Ware, MABuilt 1967 · S/N 17256179N3279MValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 310R1891N3279USchlafmann Jay R · Mercer, NDBuilt 1963 · S/N 18254679N327CTYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700535N327DMMullin Clint · Lambert, MTS/N 18262924N327HRRd Holdings LLC · Las Vegas, NVBuilt 1979 · S/N 18267468N327JKRudolph Rudi · Cordova, TNBuilt 1976 · S/N R1722003N327KMarsh John E · Washington, DCS/N 185 0418N327LSHeermann Philip D · Albuquerque, NMBuilt 1978 · S/N 182-66407N327LWPerini Stephen Dale · Fayetteville, GABuilt 1959 · S/N 52360N327MWW. Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1980 · S/N 414A0531N327TALeblanc Joseph E Jr · Houston, TXBuilt 1984 · S/N 340A1809N327WLSouth Aero Inc · Albuquerque, NMBuilt 1996 · S/N 208B0547N32806Nimsic Thomas L · Carson City, NVBuilt 1976 · S/N 18264943N3280LDobbertin Thomas E · Redlands, CAS/N 17256180N3281DRichardson John David · Willis, TXBuilt 1955 · S/N 32079N3281JRegistration Pending · Oakland, ORRegistration pendingBuilt 1966 · S/N 15065981N3281LWizna LLC · Boca Raton, FLBuilt 1967 · S/N 17256181N3281RNowicki Stanislaw · Cottonwood Heights, UTS/N 15284363N3281SWright Flyers Club · Huber Heights, OHBuilt 1964 · S/N 18255781N3282DLafleur Kerry P · Fort Worth, TXBuilt 1955 · S/N 32080N3282LFranco David F Jr · Santa Rosa, CABuilt 1967 · S/N 17256182N3282SWest Thomas Edward · Watsonville, CABuilt 1964 · S/N 18255782
Back to AD 97-01-13