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.

N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318N3318RPetersen Family 1999 LLC · Anchorage, AKS/N 18502872N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618N3318VArledge Roone Jr · Lakewood Ranch, FLBuilt 1977 · S/N R1722249N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164N331DTTolkach Dennis G · Dunlevy, PAS/N 18504238N331JCCsp Aviation Holdings LLC · Dallas, TXBuilt 1966 · S/N 15064821N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899N331KWHeritage Academy Inc · Monterey, TNBuilt 1963 · S/N 3360026N331LCEblc Aviation LLC · Hollywood, FLS/N U20605254N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028N331RFRandigo LLC · Wilmington, DEBuilt 1999 · S/N 208B0754N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441N331TCOn Trend Homes LLC · Columbia, MOS/N 414-0943N3320DPara Tactics LLC · Shelton, WAS/N 32118N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320N3320JPollman Justin A · Sherwood, NDS/N 15066020N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920N33216Avarts LLC · New Castle, DES/N U20602676N3321DWood Steveno · Morgan, UTS/N 32119N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321N3321JFulton Ricky L · Alex, OKBuilt 1966 · S/N 15066021N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621N3321VRegistered aircraftBuilt 1974 · S/N 15076462N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925N3322DObrien Aviation LLC · Moreno Valley, CABuilt 1955 · S/N 32120N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722N3322YFostair Inc · Ovid, NYS/N 18254322N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930N3323DPrince Christopher E · Anchorage, AKBuilt 1955 · S/N 32121N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323N3323JRichards Amy L · Union City, INBuilt 1966 · S/N 15066023N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623N3323TDeese James K Jr · Charlotte, NCS/N 17700623N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932N3324UHaer Welton · Craig, MOBuilt 1963 · S/N 18254724N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324N3325RDresick Farms Inc · Huron, CABuilt 1968 · S/N 18258625N3325UWeber Donald E · Saint David, AZS/N 18254725N3326FRegistered aircraftBuilt 1966 · S/N 18257326N3326RAnderson Patrick Alan · Ripley, WVS/N 18258626N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626
Back to AD 97-01-13