N920VV, cancelled Aug 22, 1998
Service difficulty reports · 34
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N920VV' AND deregistration_id = 'N920VV-1998-08-22' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N920VV' AND deregistration_id = 'N920VV-1998-08-22' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR DU4R9600050Support · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 996.0 RBL-28 VERTICAL SUPPORT ON AFT SIDE OF WEB CORRODED BOTTOM END.SDR DU4R9600049Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND CABIN SEAT TRACK INBOARD LT SIDE BS 397.0 CORRODED BEYOND LIMITS.SDR DU4R9600048Frame · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 917.0 BETWEEN LONGEONS 29R AND 29L FRAME IS CORRODED FORWARD AFT, UPPER AND LOWER SURFACES.SDR DU4R9600047Frame · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 996.0 LONGERONS 21L - 21R AFT CARGO PIT AREA FRAME AND AFT WALL CORRODED ALONG FLOOR PANEL SUPPORTS AND RT AFT WALL.SDR DU4R9600046Support · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 200.0 TO 237.0 LBL 20.0 FLOOR BEAM SUPPORT CORRODED BEYOND LIMITS.SDR DU4R9600045Longeron · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 965.0 TO 980 APPROX AFT CARGO PIT LONGERON 28R CORRODED.SDR DU4R9600044Doubler · non approvedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 965.0 BETWEEN LONGERONS 30 - 20L AREA HAS A NON-APPROVED REPAIR.SDR DU4R9600043Support · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 945.0 TO 996.0 LONGERON 23R FLOOR SUPPORT CORRODED.SDR DU4R9600042Floor Beam · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 980.0 RBL 28 WL 208.0 AT CARGO PIT FLOOR BEAM SUPPORT CORRODED.SDR DU4R9600041Angle · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 996.0 AT CARGO PIT FRAME HAS 8 EACH VERTICAL STIFFENERS ON AFT SIDE OF WEB CORRODED.SDR DU4R9600039End Caps · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 996.0 LONGERONS 29R, 30, 29L, 28L, 27L, 26L, 25L AND 24L LONGERON END CAPS CORRODED.SDR DU4R9600038Longeron · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 945.10 TO 996.0 LONGERON 21R IN AFT CARGO PIT IS CORRODED.SDR DU4R9600037Longeron · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 945.0 TO 996.0 LONGERON 22R CORRODED.SDR DU4R9600036Doubler · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 945.0 LONGERON 29R AREA HAS EXISTING REPAIR CORRODED.SDR DU4R9600035Doubler · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 965.0 RBL 40 ABOVE LONGEORN 23R FORMED DOUBLER ATTACHING VERTICAL STRUT TO FRAME AT BS 965 IS CORRODED.SDR DU4R9600034Frame · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 980.0 LONGERONS 22L - 20R FRAME IS CORRODED.SDR DU4R9600033Frame · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 945.0 LONGERON 28R AFT CARGO PIT FRAME IS CORRODED.SDR DU4R9600032Bulkhead · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 996.0 LONGERONS 26L - 24R AFT PRESSURE BULKHEAD HAS SEVERAL AREAS OF CORROSION AT BOTTOM END.SDR DU4R9600031Frame · crackedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 965.0 FLOOR BEAM IS CRACKED.SDR DU4R9600030Angle · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 996.0 ABOVE LONGERON 23R VERTICAL STIFFENER IS CORRODED.SDR DU4R9600029Fitting · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 945.0 TO 996.0 LONGERON 20R. LONGERON IS CORRODED; ALSO, END FITTING IS CORRODED.SDR DU4R9600028Angle · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 996.0 LBL 39.0 AFT CARGO PIT VERTICAL STIFFENER CORRODED AT BOTTOM.SDR DU4R9600027Fitting · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 794.0 LONGERON 30 END FITTING CORRODED AT AT END UNDER SPLICE.SDR DU4R9600026Skin · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT AREA BS 803.0 TO 860.0 LONGERON 30 SKIN UNDER LONGERON 30 IS CORRODED.SDR DU4R9600025Door Jamb · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT DOOR JAMB AREA HAS SEVERAL AREAS OF CORROSION.SDR DU4R9600024Stiffener · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 996.0 LBL 28.0 VERTICAL STIFFENER (HAT SECTION) CORRODED.SDR DU4R9600023Frame · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 870.0 LONGERON 30 FRAME IS CORRODED.SDR DU4R9600022Frame · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 870.0 LONGERON 29R TO 29L FRAME IS CORRODED.SDR DU4R9600021Longeron · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT BS 889.0 TO 965.0 LONGERON 30 IS CORRODED.SDR DU4R9600020Doubler · crackedDURING REPETITIVE INSPECTION AT AERO CORP IN LAKE CITY, FL, OF AD 90-18-03, SB 5798 R8, FOUND THE RADIUS BETWEEN STR 13 AND 14R HAS CORROSION AND A CRACK INDICATION NOTED AT BOTTOM OF RADIUS. ALSO, CORROSION AND CRACKS NOTED BETWEEN STR 16 AND 17R.SDR DU4R9600019Support · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND AFT CARGO PIT, BS 996.0 APPROXIMATELY 10 INCHES BELOW FLOOR LEVEL ON AFT SIDE OF WEB TEE EXTRUSION, HORIZONTAL SUPPORT IS CRACKED.SDR 96ZZZX5197Tee Cap · corrodedDURING ACCOMPLISHMENT OF AD 90-18-03, REF DC-9, SB 57-98, REV 8, FOLLOWING DISCREPANCIES: RT WING LOWER TEE CAP AT STA XCW 58.00 BTWN STR'S 11-17 EXFOLIATON CORROSION EXISTS. REMD CORROSION BTWN STR'S 11-12, .100 INCH MATERIAL LOSS; STR'S 12-13, .067 MATL LOSDR 96ZZZX5196Tee Cap · corrodedDURING ACCOMPLISHMENT OF AD 90-18-03, REF DC-9 SB 57-98, REV 8, FOLLOWING DISCREPANCIES: RT WING LOWER TEE CAP AT STA XCW 58.00 BETWEEN STR'S 11-17, EXFOLIATION CORROSION EXISTS. REMOVED CORROSION BTWN STR'S 11-12, .100 INCH MATL LOSS; STR'S 12-13, .067 INCHSDR 96ZZZM1059Generator · trippedON FLT 510 - ATL-BNA - AIR RETURN, AT 20,000 FEET THE LEFT GENERATOR TRIPPED WITH A/C X-TIE LOCK OUT, RESET GENERATOR, VOLTS AND FREQS NORMAL, BUT TRIPPED AGAIN WHEN PUT ON LINE. CHECKED LEFT ENGINE GENERATOR CABLE FROM GENERATOR TO RELAY, CHECKS OK. RAN ENG
Back to N920VV, cancelled Aug 22, 1998