OpenAirDocs.org
AD 97-01-13

Registered aircraft · 54,837

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-13')
    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-13')
  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.

N1385QRegister Trenton D · Wilmington, NCBuilt 1971 · S/N 15072685N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266N1385YCaracci Sam V Jr · Galesburg, ILS/N 17249085N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176N1386MJohnson Shannon L · Granite Falls, MNBuilt 1971 · S/N 18260826N1386QRegistration Pending · Wasilla, AKRegistration pendingBuilt 1971 · S/N 15072686N1386SLangel Joseph J · Lakeville, MNBuilt 1976 · S/N 18264947N13874Missionair LLC · Livingston, NYBuilt 1974 · S/N 17263026N1387FEllis Jerald K · Fort Myers, FLBuilt 1966 · S/N 17254882N1387MJ&D Aero LLC · Wilmington, DEBuilt 1975 · S/N 18264308N1387QHendricks Adam · Plano, TXBuilt 1971 · S/N 15072687N1387SGalaz Nick Anthony · Lake Havasu City, AZBuilt 1976 · S/N 18264948N1387UCp Aircraft Leasing LLC · Danville, CABuilt 1976 · S/N 17267058N1387YBi-County Ambulance Service Inc · Yuba City, CABuilt 1961 · S/N 17249087N13884Triple F Aviation LLC · Scott City, KSS/N 17263028N13887Jkg LLC · Murfreesboro, TNBuilt 1974 · S/N 17263029N13889Carver Brian J · Rockwell City, IABuilt 1974 · S/N 17263030N1388SCowboy Taxi LLC · Payson, AZBuilt 1976 · S/N 18264949N1388UBeining Grant P · Fullerton, CABuilt 1976 · S/N 17267059N13890Registration Pending · Commerce, GARegistration pendingBuilt 1974 · S/N 17263031N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475N1389FBedford Aero Club Inc · Bedford, INS/N 17254884N138FRAyotte Matthew A · South Haven, MIBuilt 1986 · S/N 17276545N138JGCloud Cruisers LLC · Falls Of Rough, KYBuilt 1975 · S/N 421B0952N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036N1390LGreen Rose LLC · Swartz Creek, MIBuilt 1978 · S/N 33701882N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691N1391SWysong Charles J · Hickory, NCFirst renewal noticeBuilt 1976 · S/N 18264952N1391UArctic Winds Inc · King Salmon, AKS/N 17267062N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039N1392QRegistered aircraftBuilt 1971 · S/N 15072692N1392SAbc Flying Club Inc · West Mifflin, PABuilt 1976 · S/N 18264953N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045N13943Tell Christopher A · Colville, WAS/N 17263046N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048
Back to AD 97-01-13