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.

N8954CTeamco Aviation LLC · Saint Petersburg, FLS/N 32R-7680146N8954PKramer Kartie K · Mckinney, TXBuilt 1966 · S/N 24-4411N8955C4k Endeavors LLC · Wadsworth, OHBuilt 1976 · S/N 34-7670158N8955PPropwash LLC · Princeville, ILBuilt 1966 · S/N 24-4412N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8957PCreedon John · Mc Cormick, SCBuilt 1966 · S/N 24-4414N8958PVan Dyke David M · Portland, ORBuilt 1966 · S/N 24-4415N8959PMosel Properties LLC · Marrero, LABuilt 1966 · S/N 24-4416N8961PRegistered aircraftBuilt 1966 · S/N 24-4418N8962PDunning John · Stow, MABuilt 1966 · S/N 24-4419N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N8964PPerkins Michael W · Warren, MIBuilt 1966 · S/N 24-4421N8965PChancellor Richard · Palmer Lake, COBuilt 1966 · S/N 24-4422N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N8966PLautensack Peter · Oswego, NYBuilt 1966 · S/N 24-4423N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427N8971PDerrel Luce Pc · Waco, TXBuilt 1966 · S/N 24-4428N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430N8973YAire Ryder LLC · Roseville, MNS/N 39-139N8974P4papa LLC · Gig Harbor, WABuilt 1966 · S/N 24-4432N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435N8979PShortridge Mary E · Bennet, NEBuilt 1966 · S/N 24-4438N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439N8980YTomu Fly LLC · Vero Beach, FLS/N 39-146N8981YGrey Enterprises Holdings LLC · Kalispell, MTBuilt 1972 · S/N 39-138N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441N8982YCovington James P · Poplar Grove, ILBuilt 1972 · S/N 39-147N8983PBlum Kenneth J · Truckee, CABuilt 1966 · S/N 24-4442N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443N8985CCornelius James Sean · Hamilton, MOBuilt 1976 · S/N 32R-7680147N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445N8986PNielsen James R · Carson City, NVS/N 24-4446N8986YN8986y LLC · Orlando, FLBuilt 1972 · S/N 39-151N8987CDouble M Charters LLC · Lakeland, FLBuilt 1976 · S/N 32R-7680148N898DSBeretta James P · Indian Springs, ALBuilt 1977 · S/N 32R-7780358N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451N8991PCendejas Agustin · Chino, CABuilt 1966 · S/N 24-4452N8992EDmd Air Ventures LLC · Waycross, GABuilt 1976 · S/N 32R-7680187N8992PL And L Aviation Inc · Mount Airy, MDBuilt 1966 · S/N 24-4453N8993PPitcher Benjamin Alan · Fishers, INBuilt 1966 · S/N 24-4454N8997PF2 Management LLC · Canoga Park, CAS/N 24-4458
Back to AD 97-01-01 R1