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.

N6050PNeuman Michael R · Valencia, PABuilt 1959 · S/N 24-1146N6052POn Site Aviation Inc · Hillsboro, NDBuilt 1959 · S/N 24-1148N6054HNatelson Richard M · Salmon, IDBuilt 1977 · S/N 34-7870049N6054PMartinez Juan R · San Bruno, CABuilt 1959 · S/N 24-1150N6056PN6056p LLC · Sonoma, CABuilt 1959 · S/N 24-1152N6057PAerdonlen · Pensacola, FLBuilt 1959 · S/N 24-1153N6059PShearer Jay E · Coshocton, OHBuilt 1959 · S/N 24-1155N605JCHustler Aviation LLC · Huntsville, TXBuilt 1969 · S/N 28R-31088N6062PYoung Tracy K · Newcomerstown, OHS/N 24-1158N6067HMilford Aviation Inc · Hoffman Estates, ILBuilt 1977 · S/N 28R-7837050N6067PRoark William B · Silverdale, WABuilt 1959 · S/N 24-1163N6070PParcell Charles W · La Canada Flt, CABuilt 1959 · S/N 24-1166N6071HArrow71h LLC · Phoenix, AZBuilt 1977 · S/N 28R-7803085N6071PKohler Thomas M · Brant Beach, NJS/N 24-1167N6073PBradshaw James L · Lenoir, NCBuilt 1959 · S/N 24-1169N6074PBerlingen Michael W · Oregon City, ORBuilt 1959 · S/N 24-1170N6075PMoore Leslie D · Raymore, MOBuilt 1959 · S/N 24-1171N6079PColson Carl L · Blunt, SDBuilt 1959 · S/N 24-1177N607JWMid-South Bulk Services Inc · West Memphis, ARBuilt 1976 · S/N 32R-7680137N607KWWalsh Kevin T · Morristown, NJBuilt 1976 · S/N 32R-7680390N6083HAerotyne Aviation LLC · Omaha, NEBuilt 1977 · S/N 28R-7837052N6087PBrandner Paul D · Lake Tapps, WABuilt 1959 · S/N 24-1186N6089HGromer Gerald M · Sebastopol, CABuilt 1977 · S/N 28R-7803088N6089PMichaelsen Richard P · Sanborn, NYBuilt 1959 · S/N 24-1188N6090PBasin Franchising LLC · Vernal, UTBuilt 1959 · S/N 24-1189N6093HAmerican Butchers LLC · Dallas, TXS/N 32R-7880044N6097PGuest Aviation LLC · Crane Hill, ALBuilt 1959 · S/N 24-765N60CSAir Flight Enterprises Inc · South Daytona, FLBuilt 1958 · S/N 24405N60SULuther Frank E · Amanda, OHBuilt 2005 · S/N 2844121N60WFEngels John · Edmond, OKBuilt 1959 · S/N 24-1635N61011Inter American University Of Puerto Rico · Bayamon, PRBuilt 2008 · S/N 2844139N6101PLockett Terrell M Sr · Winter Haven, FLBuilt 1959 · S/N 24-1199N6102PAllen Darren Kerr · Thomasville, GABuilt 1959 · S/N 24-1200N6104PKimsey Thomas W · Warner Robins, GABuilt 1959 · S/N 24-1202N6106PRegistration Pending · Mesa, AZRegistration pendingBuilt 1959 · S/N 24-1204N610LBWinters Jesse · New Braunfels, TXBuilt 1976 · S/N 32R-7680304N6112PBurnett Jennifer · Palmer, AKS/N 24-1212N6114PCompton Mark E · Garfield, KYBuilt 1959 · S/N 24-1214N6116JGlobal Technical Services Inc · Fort Worth, TXBuilt 1976 · S/N 28R-7635299N6118PNovak Mark S · Dawson, NEBuilt 1959 · S/N 24-1218N6119PModisette Jeremy W · Baldwin, GABuilt 1959 · S/N 24-1219N611CMMasters Charles O · Garden Ridge, TXBuilt 1978 · S/N 28R-7837210N611VProtain Jaden · Reno, NVBuilt 1959 · S/N 24-968N6120PDremel Ronald W · North Bend, PABuilt 1959 · S/N 24-1220N6121PSmith Gloria M · New Hampton, NYBuilt 1959 · S/N 24-1221N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255N6126PDallas Jets Group LLC · Canton, TXBuilt 1959 · S/N 24-1226N6130PHiga Bertram · Northridge, CAS/N 24-1230N6134PJ-Tom Inc · Lincoln, NEBuilt 1959 · S/N 24-1234N6136JTennessee Flight Academy LLC · Bristol, TNBuilt 1976 · S/N 28R-7635301
Back to AD 97-01-01 R1