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.

N4908JHolm R Stan · College Place, WABuilt 1968 · S/N 28R-30626N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N4910JGyure Ronald J · Fort Worth, TXBuilt 1968 · S/N 28R-30629N4912JWallace William R · Fredericksburg, TXFirst renewal noticeS/N 28R-30631N4915JFox Richard A · Boynton Beach, FLBuilt 1968 · S/N 28R-30634N4916JRegistration Pending · Townsend, GARegistration pendingBuilt 1968 · S/N 28R-30635N4917JTendall Timothy A · Sudbury, MABuilt 1968 · S/N 28R-30637N4918JWoolley Charles K · Clarksville, TNBuilt 1968 · S/N 28R-30638N4921JHerdrich Sean D · Manchester, IABuilt 1968 · S/N 28R-30642N4922JOpat Randall J · Port Saint Lucie, FLS/N 28R-30643N4922TShamseldin Nathan · Buckley, WABuilt 1972 · S/N 28R-7235159N4924FStolee Aviation LLC · Bristol, PAS/N 28R-7635442N4924JCarper Clyde S · New Port Richey, FLBuilt 1968 · S/N 28R-30645N4927FRegistered aircraftBuilt 1976 · S/N 32R-7680489N4929JBurnett Robert E · San Leandro, CABuilt 1968 · S/N 28R-30650N4932JDunlap Aviation Inc · Dunlap, ILBuilt 1968 · S/N 28R-30653N4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1968 · S/N 28R-30654N4940FJackson Christopher M · Clearwater, FLBuilt 1976 · S/N 28R-7635445N4942FBarton Investment LLC · Salt Lake City, UTBuilt 1976 · S/N 32R-7680490N4945JAsher Academy · Cameron, TXS/N 28R-30692N4947FKpw Enterprises Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680492N4947JElite Fleet LLC · Spofford, NHBuilt 1968 · S/N 28R-30694N4949FGregory Scott · Quincy, MABuilt 1976 · S/N 28R-7703002N4949YPearce Richard Henry · Moses Lake, WAS/N 30-648N494NJT And B Flying Adventures LLC · Middletown, DES/N 30-494N4951TVolaero Aviation LLC · Valdosta, GAS/N 28R-7235161N4953JLent Kevin C · Glenwood, MNBuilt 1968 · S/N 28R-30699N4958JWinfrey Justin R · San Francisco, CAS/N 28R-30706N4959JTaylor James O · Marengo, ILS/N 28R-30708N495DSDelaware State University · Dover, DEBuilt 1997 · S/N 2844012N4960250 Inc · Washington, DCS/N 24-4025N4961JJones Charles W · La Follette, TNBuilt 1968 · S/N 28R-30710N4962JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30711N4964JShteyn Vladlmir · Huntingdon Valley, PABuilt 1968 · S/N 28R-30714N4966FDj&A Enterprises LLC · Sevierville, TNBuilt 1976 · S/N 32R-7680494N4967JB F D Inc · Newington, CTBuilt 1968 · S/N 28R-30718N4967SLambert Enterprises Inc · Minneapolis, MNS/N 28R-35687N4967TN4967t LLC · Evansville, INBuilt 1972 · S/N 28R-7235164N4968JOperation Stinky Weasel LLC · South Lyon, MIBuilt 1968 · S/N 28R-30719N4970SMapoles Aviation · Pace, FLS/N 28R-35690N4971JCreasy Frank Edward III · Suffolk, VABuilt 1968 · S/N 28R-30722N4973JTroftgruben Gregory G · Buxton, NDS/N 28R-30724N4975JP&N Corp · Marion, IABuilt 1968 · S/N 28R-30727N4976SLogsdon David · Carmel, INBuilt 1970 · S/N 28R-35692N4977JJad Corp · Saint Cloud, MNBuilt 1968 · S/N 28R-30730N4977SMatheaus Michael · Sequin, TXBuilt 1970 · S/N 28R-35696N4979SDunn James J · San Ramon, CABuilt 1970 · S/N 28R-35698N4980SGrenie Arles A · Richland Center, WIBuilt 1970 · S/N 28R-35699N4981SLacallle Darren M · Dover, TNBuilt 1970 · S/N 28R-35701N4984JBluewater Airmotive Corp · Wilmington, DEBuilt 1968 · S/N 28R-30738
Back to AD 97-01-01 R1