OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,915

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.

N4455MClear Prop LLC · Roswell, GABuilt 1976 · S/N 28R-7635217N4456XFly By Knight Corp · Shoreview, MNBuilt 1975 · S/N 28R-7635050N44572Hornet Aviation Inc · Tallahassee, FLBuilt 1974 · S/N 28R-7435314N4458XBabichix Inc · Hiram, GAS/N 34-7670049N4461TRobinson Joseph B · Washington, DCBuilt 1972 · S/N 28R-7235058N4461XHaggerty James D · Scott Depot, WVBuilt 1975 · S/N 28R-7635051N44649Wofford Walter R · Auburn, CABuilt 1974 · S/N 28R-7435319N4464TNelson Richard C · Euless, TXBuilt 1972 · S/N 28R-7235022N4465TSky-High Aviation LLC · Martinsburg, WVBuilt 1972 · S/N 28R-7235063N4466XAlexander Michael P · Clute, TXBuilt 1975 · S/N 28R-7635052N446ASFreeman Tim B · Haymarket, VAFirst renewal noticeBuilt 1977 · S/N 32R-7780464N446DWAnnes Wings LLC · Boulder, COBuilt 1978 · S/N 34-7870051N446TTC5 Aviation LLC · Sheridan, WYBuilt 1974 · S/N 28R-7435317N4474XToledo City School District · Swanton, OHS/N 28R-7635054N44754Greenville Pickens Roundtrac LLC · Easley, SCBuilt 1974 · S/N 28R-7535003N4475TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250106N44790Spence William M · Naples, FLBuilt 1974 · S/N 28R-7535007N4479FDurosinmi Lateef · North Las Vegas, NVS/N 34-7670338N4479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1972 · S/N 28R-7235033N44802Page Aviation Services LLC · Fort Myers, FLS/N 28R-7535009N4480TSell Justin L · Lucerne, INBuilt 1972 · S/N 28R-7235067N4481TValdes Eusebio · Miami, FLS/N 34-7250108N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257N44844Morland Robert L · Bowman, NDBuilt 1977 · S/N 28R-7703330N44845N44845 LLC · Ozark, MOBuilt 1977 · S/N 28R-7703331N4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLBuilt 1975 · S/N 28R-7635056N44859Tarcelo Francis Antonio G · Sun City, CABuilt 1977 · S/N 28R-7703333N44862Red Arrow III LLC · Carson City, NVBuilt 1977 · S/N 28R-7703335N44863Jg Aviation LLC · Indianapolis, INBuilt 1977 · S/N 32R-7780544N4486FRegistration Pending · Hague, VARegistration pendingBuilt 1976 · S/N 28R-7635411N44887Gabriel Robert A · Lancaster, PABuilt 1977 · S/N 28R-7737149N44889Gray Bradley D · Killeen, TXBuilt 1977 · S/N 28R-7703336N4488TN4488t LLC · Newport Beach, CABuilt 1972 · S/N 28R-7235035N44891Rci Asset Management Inc · San Diego, CABuilt 1977 · S/N 28R-7703339N448JGPritzker Stephen L · Scottsdale, AZFirst renewal noticeS/N 34-7770379N448PValiair Limited Company · Casper, WYS/N 28R7703058N44903Treehouse Aviation LLC · Tuscaloosa, ALBuilt 1977 · S/N 28R-7703341N44941Herboldsheimer Dixon · Westminster, COBuilt 1977 · S/N 28R-7703344N44945Valiair Lc Trustee · Casper, WYBuilt 1977 · S/N 34-7770378N44962Johnson Bud W · Cedar City, UTBuilt 1977 · S/N 28R-7703350N44966Gillette Scott A · Lancaster, CABuilt 1977 · S/N 28R-7703351N44968Mil2atp Inc · Pikeville, NCBuilt 1977 · S/N 34-7770380N4497FMurray David J · Waymart, PABuilt 1976 · S/N 28R-7635412N4497TArrow97t Llp · Feeding Hills, MABuilt 1972 · S/N 28R-7235042N4498FSapit Corp · Los Banos, CABuilt 1976 · S/N 32R-7680453N4498TCunniff Jack S · Weymouth, MAFirst renewal noticeBuilt 1972 · S/N 28R-7235045N44995Fenton Flyers LLC · Ellisville, MSS/N 28R-7703352N4499XCitrus Flight LLC · Lecanto, FLBuilt 1975 · S/N 32R-7680021N449DWWalt David L · Clarkston, MIFirst renewal noticeBuilt 1977 · S/N 28R-7703349N449DYRanjit Pearlinda · Apex, NCBuilt 1972 · S/N 28R7235200
Back to AD 97-01-01 R1