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.

N2844RBower Robert W · Scottsdale, AZBuilt 1969 · S/N 28R-35306N2845ASchwartzkopf Gregory · Saint Johns, FLS/N 34-7970279N28482Cecchi Jeanne · Oroville, CABuilt 1979 · S/N 34-7970211N2848MPumarol Rafael · Homestead, FLBuilt 1977 · S/N 28R-7837103N2849PN91934 LLC · Evergreen, COBuilt 1979 · S/N 34-7970280N2849SWestex Towers Inc · Abilene, TXS/N 34-7970281N2849TBlue Raven Aviation · Shady Cove, ORS/N 28R-7235145N2850TKolu Pilots Flying Club LLC · Columbus, NEBuilt 1972 · S/N 28R-7235146N2855MCutler Jeffrey R · Columbus, INBuilt 1977 · S/N 28R-7803149N2855UTexas Southern University · Houston, TXS/N 34-7970294N285AAGoldrock Aviation LLC · Princeton, NJBuilt 1974 · S/N 28R-7435156N285MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2844167N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147N2862TReed Thomas F · Maize, KSS/N 28R-7235148N2865RCarmel Aviation Inc · Boise, IDBuilt 1969 · S/N 28R-35308N2866RCw Arborists Ltd · Sagaponack, NYBuilt 1969 · S/N 28R-35309N2869TBoone Susan J · Bastrop, TXBuilt 1972 · S/N 28R-7235149N286BWCalifornia Falcon Aviation Inc · Anaheim, CABuilt 1979 · S/N 34-7970182N286HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 2844041N286NDMorris Randall Sanford Hartnett · Fort Worth, TXBuilt 2000 · S/N 2844035N2871LN2871l LLC · New Orleans, LAS/N 34-7970300N2871TCloud Dancer Aviation Inc · Deland, FLBuilt 1972 · S/N 34-7250178N2872THenley Brett · Manchester, TNBuilt 1979 · S/N 34-7970316N2873RMitchell Daniel E · Lubbock, TXBuilt 1969 · S/N 28R-35312N2875RLyons Corey · Vinton, OHS/N 28R-35315N2876RTorley Air Service LLC · Colorado Springs, COBuilt 1969 · S/N 28R-35316N2878MCamous Alain E · Sunrise, FLBuilt 1977 · S/N 28R-7803152N2878YBright Sky Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 28R-7931235N287GE7ge Aviation LLC · Southfield, MIBuilt 1964 · S/N 30-522N287NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2844036N2880TVuppala Kavya · Springtown, TXBuilt 1972 · S/N 28R-7235151N2881MJones James N · Missoula, MTBuilt 1977 · S/N 28R-7803153N2882RPostlewait Logging Co · Port Allegany, PABuilt 1969 · S/N 28R-35317N2882TParis Air Inc · Vero Beach, FLBuilt 1972 · S/N 34-7250180N2883NPeters Mark E · Newport News, VAS/N 34-7970325N2883YNimmo Philip · Bishop, CAS/N 34-7970327N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154N288AWilson Daniel T · Bandon, ORBuilt 1976 · S/N 32R-7680345N288ABSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1962 · S/N 24-3033N2895TSr Patel LLC · Meadville, PABuilt 1972 · S/N 28R-7235156N2896RHuseman Adam · Clarinda, IABuilt 1969 · S/N 28R-35322N289NDLoyd Fred Wayne · Rossville, GABuilt 2000 · S/N 2844039N289PAGenn Tx LLC · Farmersville, TXBuilt 2002 · S/N 2844065N289WWVision Aircraft II LLC · Scottsdale, AZBuilt 1971 · S/N 39-84N289ZZAero Mobil Inc · Wilmington, DEBuilt 1969 · S/N 39-88N28BMUS Flight Academy Intl Inc DBA · Post, TXBuilt 1973 · S/N 34-7350149N28LEGlenn Scott A · Overland Park, KSBuilt 1976 · S/N 28R-7635253N28NCHurley Thomas W · Plymouth, MABuilt 1968 · S/N 28R-30357
Back to AD 97-01-01 R1