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.

N3081QInternational Air Services Inc Trustee · Carson City, NVS/N 28R-7737046N3084QHibbard Paul A · Mountain Home, IDBuilt 1977 · S/N 28R-7703089N3087RCrest Aviation LLC · Palmer, AKS/N 28R-35646N3088GRox Air LLC · Montgomery, OHBuilt 1963 · S/N 30-88N3089RFly Bms LLC · Elkton, SDBuilt 1969 · S/N 28R-35649N308BEAlge Aviation Inc · Middletown, DES/N 32R-7780110N3090QLarsen Wayne C · Tremonton, UTBuilt 1977 · S/N 28R-7703090N3090RCasper Clarence Jr · Groton, CTBuilt 1969 · S/N 28R-35648N3091TSutton Aircraft Salvalge LLC · Palmer, AKBuilt 1972 · S/N 28R-7235312N3092TTango LLC · Quaker Hill, CTBuilt 1972 · S/N 28R-7235313N3097TD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1972 · S/N 34-7250343N3099RMesserschmidt Brent L · Gainesville, GABuilt 1969 · S/N 28R-35668N309WPMcmahon Peter · Brookfield, CTBuilt 1961 · S/N 24-2955N30BMagill Terry K · Beach City, TXBuilt 1966 · S/N 30-1381N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203N30JNDls Holdings Inc · Lewes, DEBuilt 1957 · S/N 30-1423N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018N30NWCenterline Aerospace Inc · Clermont, FLBuilt 1964 · S/N 30-312N30SHMedic Choppers LLC · Springdale, ARBuilt 1966 · S/N 30-1262N30TJFiskars Equipment Co · Saint Joseph, MIBuilt 1965 · S/N 30-762N30XTBurnette Ric A · Sebastian, FLBuilt 1967 · S/N 30-1644N3100QFly By Nite Aviation LLC · Great Falls, MTS/N 28R-7703091N3109PSoft Works Systems Inc · Jamesville, NYBuilt 1969 · S/N 28R-31109N311SRed Rock Construction Inc · Hydro, OKBuilt 1964 · S/N 30-328N312ABSmith Kenneth R · Senoia, GABuilt 1978 · S/N 28R-7803120N312CADunn Jonathan · Murfreesboro, TNBuilt 1968 · S/N 28R-30590N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115N3131TSilver Express Co Db · Miami, FLBuilt 2004 · S/N 2844107N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117N31386S&L Aircraft LLC · Port Trevorton, PABuilt 1978 · S/N 28R-7837233N313ASStephen Air LLC · Woodsfield, OHBuilt 1980 · S/N 34-8070331N313EMKjta LLC · Renfrew, PABuilt 1977 · S/N 28R-7703275N313MWClover George S · Catheys Valley, CABuilt 1959 · S/N 24-1637N313PKCampbell James D · Palo Alto, CABuilt 1976 · S/N 32R-7780037N31401Fox Flying Club Inc · Wheaton, ILBuilt 1978 · S/N 28R-7837234N314DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1975 · S/N 34-7570285N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031N31530Wheeler Auctions & Real Estate LLC · Paris, MOBuilt 1978 · S/N 34-7870238N31595Highlander Air LLC · Kalispell, MTBuilt 1978 · S/N 34-7870243N315EBBaas Holdings LLC · Lewes, DEBuilt 1978 · S/N 34-7870357N31604Sun Mountain Flying LLC · Cody, WYBuilt 1978 · S/N 28R-7803288N3161TKoester Carsten · San Jose, CAS/N 28R-7235144N31629Wolff Aviation LLC · Cumberland, MDS/N 34-7870246N3163QLakefield Lance Ltd · Coldwater, OHBuilt 1977 · S/N 32R-7780295N31649Runway Hero LLC · Wayland, MABuilt 1978 · S/N 28R-7837241N31662Star Air Service LLC · Jacksonville, FLS/N 34-7870249
Back to AD 97-01-01 R1