OpenAirDocs.org
AD 97-05-06

Registered aircraft · 134

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-05-06')
    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-05-06')
  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.

N1020QMike Rinker Aircraft LLC · Union City, TNS/N 115-0426N1020STactical Turtle LLC · Sheridan, WYBuilt 1966 · S/N 26-0467N1020TSchroth Charles D · Gustavus, AKBuilt 1966 · S/N 56-0554N1020ZBowar Gary R · Miranda, SDBuilt 1966 · S/N 66-0601N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376N1038NSome Beech LLC · Bolivar, MOS/N 85-0360N105CMLewis Donn C · Millington, MIBuilt 1966 · S/N 66-0587N106KTDetgen Ernest J · Carmen, OKBuilt 1966 · S/N 46-0516N110ESAirdale Helicopters LLC · Shawnee, OKS/N 58-0860N115ACRuhlman Dan C · Youngsville, PABuilt 1968 · S/N 580367N153GHHealey David A · Hammondsport, NYBuilt 1966 · S/N 660602N202SLConstantine Frank L · Flemington, NJBuilt 1969 · S/N 67-16975N2196SHernandez Christopher A · Phoenix, AZBuilt 1968 · S/N 180753N22730Reynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 790436N267RWKoelzer Galen G · Othello, WABuilt 1964 · S/N 0047N269AReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 1050403N269HHCaprock Technical Services Inc · Kempner, TXS/N 12-0041N269MDCactus Air Force LLC · Carson City, NVBuilt 1963 · S/N 33-0175N269SRRaper David A · Mesa, AZS/N 16-0445N269STSalina Tree Inc · Salina, KSBuilt 1965 · S/N 85-0363N3075UEvans Ronald G · Imlay City, MIBuilt 1966 · S/N 125-0427N37750Bacon Gregory · Prairie Home, MOBuilt 1968 · S/N 680883(6716776)N380MCVeturis David L · Lake Forest, CAS/N 128-1054N38ABJerry Lay Aviation LLC · Minonk, ILS/N 46-0503N3TFHelicopter Accessory Service East · Pensacola, FLS/N 34-0042N4276REchols Mark R · Diana, TXBuilt 1967 · S/N 1181032N444EDunker Quinn E · Morse Bluff, NEBuilt 1963 · S/N 0217N451JRFathom Aviation LLC · Burley, WAS/N 65-0212N47SDWampler William C · Canton, TXS/N 108-0989N48155Classic Rotors Museum · Ramona, CABuilt 1964 · S/N 160433N49WGGarlock Walter G · Oconomowoc, WIS/N 760616N5001FReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 95-0385N50045Drive A Tank Inc · Kasota, MNBuilt 1966 · S/N 76-0610N525GHLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 87N5594YWdw Aviation Leasing Inc · Knoxville, TNBuilt 1964 · S/N 1140329N62269Ashcraft Matthew · Abbott, TXS/N 160449N62273Mundell Terry Trustee · Rosston, OKBuilt 1969 · S/N 291096N62293Bilsky William E · Titusville, FLS/N 88-0939N6258BA&A Conveyor And Equipement Inc · Pennington Gap, VAS/N 67-16812N653CHKelley Aviation Consultants LLC · S Williamsport, PABuilt 1965 · S/N 96-0653N691RRAnderson Stuart R Jr · Sahuarita, AZS/N 124-0143N7032ZJones James William III · Lebanon, VAS/N 1040325N7050DFoster David S · Justin, TXS/N 56-0551N7057LTri County Rentals And Sales Inc · Chiefland, FLBuilt 1967 · S/N 1281052N711CHYoung Vernon P · Metter, GAS/N 560531N7233USuttle Joseph S · Moody, ALBuilt 1964 · S/N 16-0447N72LTReynolds Cindy L · Wills Point, TXBuilt 1968 · S/N 580863N74LTDevor Aviation Support Services LLC · Chambersburg, PABuilt 1968 · S/N 1270740N801CPMoore Bradley J · Logsden, ORBuilt 1968 · S/N 980965N801SLZadow Ryszard Jerzy · Waller, TXBuilt 1968 · S/N 880954
Back to AD 97-05-06