OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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-01-R1')
    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-01-R1')
  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.

N3231RAll2fly LLC · Atlanta, GABuilt 1969 · S/N 28R-31000N32344Cunningham James L · Oshkosh, WIBuilt 1974 · S/N 28R-7535046N32357Malone Bernard G · Frenchtown, NJBuilt 1974 · S/N 28R-7535047N32379Erkert Jason A · Phoenix, AZBuilt 1974 · S/N 28R-7535049N32393Mcnamee James R · Cocoa, FLBuilt 1974 · S/N 28R-7535050N323BGElectric Cowboy Aviation LLC · Okeechobee, FLS/N 28R-7435210N323CCBarrett James P · North Little Rock, ARBuilt 1978 · S/N 28R-7803206N323MGRstv Inc · Dubuque, IABuilt 1976 · S/N 28R-7635256N323TMElliott Properties-Series 4 LLC · Washoe Valley, NVS/N 28R-7703117N3241RJohnson Edward Wayne · Bloxom, VABuilt 1969 · S/N 28R-31023N32427Mcfadden Robert K · Port Orange, FLBuilt 1974 · S/N 28R-7535054N32444Jtz Aviation LLC · Wilmington, DEBuilt 1974 · S/N 28R-7535057N32456Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 34-7570023N3245RA & W Cattle Co · Flippin, ARBuilt 1969 · S/N 28R-31019N32469Dufresne Justin Barth · Temple City, CABuilt 1974 · S/N 28R-7535059N3247RArrowood Bradley W · Winston Salem, NCBuilt 1970 · S/N 28R-31111N32481Flyboy Fantasy Inc · South Lake Tahoe, CABuilt 1974 · S/N 28R-7535061N32483Showah Jason M · Brentwood, TNBuilt 1974 · S/N 28R-7535062N32492Doyle Dylan D · Cerrillos, NMBuilt 1974 · S/N 28R-7535063N32521Proflite Of Alaska LLC · Fairbanks, AKS/N 28R-7535065N32524Barth Tom L · Manhattan, KSBuilt 1974 · S/N 28R-7535067N32552Garys Fork Auto Service LLC · Hydes, MDBuilt 1974 · S/N 28R-7535068N32555Harvest Aviation · Wauchula, FLBuilt 1974 · S/N 34-7570032N3256QManzella Aviation LLC · Brandon, FLBuilt 1977 · S/N 28R-7703098N325CVajdos Nicholas · Karnes City, TXS/N 24-1082N32613Gray Matthew C · Enterprise, ALBuilt 1974 · S/N 28R-7535072N32622Region Flyers LLC · Valparaiso, INBuilt 1974 · S/N 28R-7535073N32624Rio Aviation LLC · Wilmington, DES/N 34-7570038N32665White Richard L Trustee · Los Altos, CABuilt 1974 · S/N 28R-7535076N32680Neumann Peter G · Cape Coral, FLBuilt 1974 · S/N 28R-7535077N32693Oconner Brian E · Santa Cruz, CAS/N 28R-7535078N32727Denton Christopher G · Youngsville, NCS/N 28R-7535082N32747Aaof Investments LLC · Fort Mc Coy, FLBuilt 1974 · S/N 28R-7535084N32749Ryszka Aviation LLC · Heber City, UTBuilt 1974 · S/N 28R-7535085N3274RBurton Re Holdings LLC · Mustang, OKBuilt 1970 · S/N 28R-31258N32755Illinois Air Inc · Naperville, ILBuilt 1975 · S/N 34-7570049N32773Dalba Andrew Naim · Anaheim, CABuilt 1974 · S/N 28R-7535088N32776Hutchison Ross C · Olathe, COBuilt 1975 · S/N 34-7570052N32783Frederick Michael A · Cleves, OHBuilt 1974 · S/N 28R-7535089N32784Denicola Frank J · Visalia, CABuilt 1974 · S/N 28R-7535090N327CABurbano Oscar Sebastian · Greensboro, NCBuilt 1979 · S/N 7970276N327JCPottier Michael · Dover, NHBuilt 1978 · S/N 28R-7803266N3280RAmson Technology Lc · Des Moines, IABuilt 1969 · S/N 28R-31260N32812Rottinghaus Kelly A · Dundee, MSS/N 34-7570056N32820Turner Douglas A · Sacramento, CABuilt 1974 · S/N 28R-7535093N32831Jochen Nathan D · Sevierville, TNBuilt 1974 · S/N 28R-7535094N3284REsser Jill · Mason, MIBuilt 1970 · S/N 28R-31261N32861New Hope Equipment Sales Inc · Ardmore, OKBuilt 1974 · S/N 28R-7535096N32863International Air Services Inc Trustee · Carson City, NVS/N 34-7570062N32870Pineland Flying LLC · Valdosta, GABuilt 1974 · S/N 28R-7535097
Back to AD 97-01-01 R1