N832RV, cancelled Jun 13, 2001
Service difficulty reports · 295
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 = 'N832RV' AND deregistration_id = 'N832RV-2001-06-13' 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 = 'N832RV' AND deregistration_id = 'N832RV-2001-06-13' 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 RAAA99B2044Battery Pack · dischargedPAX ROW 22 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA99B2043Light · brokenDURING DAILY SERVICE CHECK, FOUND FORWARD RIGHT HAND OVER WING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT TO HAVE A BROKEN SCREW AND CASE. REPLACED LIGHT ASSEMBLY.SDR RAAA99B2042Web · corrodedDURING SCHEDULED C-CHECK, FOUND VERTICAL STABILIZER CLOSURE WEB CORRODED INSIDE LOWER END AT ATTACH ANGLE INSIDE AND AFT NR 2 PYLON ACCESS PANEL AND AT LOWER END FASTENERS ABOVE NR 2 ENGINE MOUNT. REPAIRED IAW RAA ECO 99-4 REFERENCE DWG 65-22913 65-17551 M5SDR RAAA99B2041Mount · corrodedDURING SCHEDULED C-CHECK, FOUND NR 2 ENGINE AFT MOUNT ATTACH FITTING AND T CHORDS RUSTY AND PITTED. REMOVED AND REPLACED AFT ENG MOUNT FITTING IAW SRM 54-40-01 AND SRM 51-10-01.SDR RAAA99B2040Skin · corrodedDURING SCHEDULED INSPECTION PER CARD S1 14101, FOUND FUSELAGE SKIN CORRODED STR 3R TO STR 4R BS 1135 TO 1183 AND STR 4L BS 1130 TO 1148. REPLACED FUSELAGE SKIN PER BOEING MSG RVV-SEA-99-0004RR STR 1 TO STR 5R AND BS 1080 TO 1183.SDR RAAA99B2039Bulkhead Fitting · crackedDURING SCHEDULED C-CHECK, FOUND S-3AL STRINGER BULKHEAD FITTING CRACKED IN INBOARD FITTING BS 1183 BULKHEAD. REMOVED AND REPLACED STRINGER BULKHEAD FITTING S-3AL IAW SRM 51-10-01. REPLACED AND TORQUED BOLTS AQS PER SB 727-53-0178.SDR RAAA99B2038Bulkhead Fitting · crackedDURING SCHEDULED C-CHECK, FOUND S-3AR STRINGER BULKHEAD FITTING CRACKED IN INBOARD FITTING BS 1183 BULKHEAD. REMOVED AND REPLACED BULKHEAD FITTING STRINGER S-3A IAW SRM 51-10-01. INSTALLED AND TORQUED NEW BOLTS IAW SB 727-53-0178.SDR RAAA99B2037Stringer · corrodedDURING SCHEDULED INSPECTION IAW AD 99 04 22, FOUND STR 21L CORRODED AT BS 450. REPAIRED IAW 53-10-3 FIG 1 DETAIL 2.SDR RAAA99B2036Skin · gougedDURING SCHEDULED C-CHECK, FOUND SEVERAL AREAS OF GOUGED SKIN BS 338-372 BELOW AND AFT FWD ENTRANCE DOOR. REPAIRED GOUGE IAW SRM 53-30-3 FIG 13. OTHER GOUGES ALLOWABLE LIMITS IAW 53-30-01 FIG 1. ALODINED AND PRIMED IAW 51-10-02.SDR RAAA99B2035Fitting · crackedDURING SCHEDULED INSPECTION IAW AD91-24-11 OF BS 870 FITTING FOUND CRACK INDICATION TOP SIDE OF HOLE IN ROW NR 3, BOTTOM HOLE IN SPLICE PLATE AND FITTING BELOW STR 9R. NO CRACK DETECTED AFTER REAMING. INSTALLED EXTERNAL DOUBLER IAW SB 727-53-0194 DWG 65C2527SDR RAAA99B2034Seat Track · corrodedDURING SCHEDULED C-CHECK, FOUND SEAT TRACK AT BS 740 AND RBL 28 CORRODED OUT OF LIMITS. CUT OUT DAMAGED SECTION OF SEAT TRACK FROM BS 700-740 LBL 25 PER SRM 53-10-5-MATERIAL ID FOR REPAIR SECTION IS BAC1520-1264 PER SRM 53-10-02-FABRICATED REPAIR SECTION PER SDR RAAA99B2033Channel · corrodedDURING SCHEDULED C-CHECK, FOUND FLOOR SUPPORT CHANNEL CRACKED AT FORWARD ATTACH HOLE AND FLOORBEAM ATTACH HOLE ELONGATED AT BS 328 RBL 44. REMOVED FLOOR SUPPORT CHANNEL, FABRICATED NEW CHANNEL 7075T6 .094 IAW 51-10-02. TREATED AND PRIMED IAW 51-10-06. INSTASDR RAAA99B2032Floorbeam · corrodedDURING SCHEDULED C-CHECK, FOUND BS 312 FLOORBEAM UPPER CHORD CORRODED AT LBL 3 THRU LBL 30. REMOVED UPPER CHORD, FABRICATED NEW UPPER CHORD 7075T6 .094 AND REPAIRED SPLICE IAW SRM 53-10-08 FIG 9. TREATED, PRIMED, PAINTED IAW SRM 51-10-06. INSTALLED UPPER CHSDR RAAA99B2031Floorbeam · corrodedDURING SCHEDULED C-CHECK, FOUND BS 344 FLOORBEAM UPPER CHORD AT LBL 25 THRU LBL 60 CORRODED. REPLACED FLOORBEAM UPPER CHORD BS 344 LBL 25 THRU LBL 68 IAW SRM 53-10-08 PG 9.SDR RAAA99B2030Seat Track · corrodedDURING SCHEDULED C CHECK, FOUND SEAT TRACK CORRODED FROM BS340 TO 360 RT. INSTALLED NEW SEAT TRACK IAW SRM 51-10-01.SDR RAAA99B2029Floor · corrodedDURING SCHEDULED C CHECK, FOUND CORROSION ON FLOOR PLATE AROUND FWD LAV DUMP PIPE TOP AND BOTTOM SURFACES BS 303 TO 344. REMOVED CORROSION IAW SRM 51-10-06. TREATED AND PRIMED IAW SRM 51-10-06. REMOVED SUPPORT ANGLES AND FABRICATED NEW ANGLES OF 7075T6 .094SDR RAAA99B2028Floor · corrodedDURING SCHEDULED C CHECK, FOUND CORROSION ON FORWARD LAV FLOORBOARD ATTACH HOLES AND CAP SECTION OF CHANNEL BS320 TO 340 7 RBL14 TO RBL16. REMOVED CORROSION ON FLOORBOARD AND CAP SECTION AND TREATED AND PRIMED IAW SRM 51-10-06. REMOVED CHANNEL AND FABRICATEDSDR RAAA99B2027Channel · corrodedDURING SCHEDULED C CHECK, FOUND FORWARD LAV AFT BULKHEAD FLOORBEAM CHANNEL CORRODED AT BS 340 AND RBL 20 T0 RBL 26. REMOVED FLOORBEAM CHANNEL, FABRICATED NEW CHANNEL IAW SRM 51-10-02-TREATED AND PRIMED IAW SRM 51-10-06. INSTALLED CHANNEL IAW SRM 51-30-02, SDR RAAA99B2026Angle · corrodedDURING SCHEDULED C-CHECK, FOUND CORROSION ON FLOORBEAM SUPPORT STRUCTURE AROUND FORWARD LAV DUMP PIPE BS 303 TO 315 RT. REMOVED SUPPORT ANGLES, FABRICATED SUPPORT ANGLES 7075T6 .094 IAW SRM 51-10-2. TREATED AND PRIMED IAW SRM 51-10-06. INSTALLED ANGLES IAW SDR RAAA99B2025Floorbeam · corrodedDURING SCHEDULED C-CHECK, FOUND BS 344 FLOORBEAM FORWARD FLANGE CORRODED AT RBL 44 THRU 64. REPLACED BEAM UPPER CHORD BETWEEN RBL 68 AND LBL 33 IAW SRM 53-10-8 FIG 9 M54 NR 368.SDR RAAA99B2024Skin · corrodedDURING SCHEDULED C-CHECK, FOUND SKIN BULGED AT STR 19R BS 480 TO 500. REMOVED CORROSION FROM SKIN LAP, FOUND OUT OF LIMITS IAW SRM 53-30-01. INSTALLED FILLER AND DOUBLER IAW SRM 53-30-3 M54 NR 363.SDR RAAA99B2023Frame · crackedDURING SCHEDULED C-CHECK, FOUND CRACK IN PREVIOUS REPAIR DOUBLER AT BS 580 FRAME WL 209 RT. REPLACED CRACKED DOUBLER IAW SRM 53-10-4 F 1 M54 NR 345.SDR RAAA99B2022Fitting · gougedDURING SCHEDULED INSPECTION PER AD 80-08-10, FOUND MCD NO 8 LATCH SUPPORT FITTING GOUGED UPPER FLANGE LOWER SURFACE. BLENDED LATCH SUPPORT FITTING IAW SRM 53-10-01 M54 NO 328.SDR RAAA99B2021Floorbeam · gougedDURING SCHEDULED C CHECK, FOUND FLOORBEAM UPPER CHORD FORWARD FLANGE LOWER SURFACE GOUGED AT BS 600 AND LBL 2. BLENDED FLOORBEAM UPPER CHORD FWD FLANGE LOWER SURFACE IAW SRM 53-10-01.SDR RAAA99B2020Fitting · crackedDURING SCHEDULED INSPECTION PER AD 80-08-10, FOUND BS 500 MCD LATCH SUPPORT FITTING UPPER FLANGE CRACKED 3 IN. REMOVED AND REPLACED FITTING IAW BOEING SB 727-53A0177 M54-320.SDR RAAA99B2019Floorbeam · corrodedDURING SCHEDULED C CHECK, FOUND FLOORBEAM UPPER CHORD FORWARD FLANGE LOWER SURFACE CORRODED AT BS 500 AND LBL 55. INSTALLED REPAIR IAW SRM 53-10-08 M54-306.SDR RAAA99B2018Seat Track · corrodedDURING SCHEDULED C-CHECK PER CARD B1-14010, FOUND SEAT TRACK AT BS 480 TO 640 AT LBL 45 CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-10-01. M54 NR 300.SDR RAAA99B2017Seat Track · wornDURING SCHEDULED C-CHECK INSPECTION PER CARD B1 -114010, FOUND SEAT TRACK LUG WORN BEYOND LIMITS AT BS 916 AND LBL 25. REMOVED AND REPLACED DAMAGED SEAT TRACK SECTION FROM BS 870 TO 940 AT LBL 25. M54 NR 298A.SDR RAAA99B2016Seat Track · wornDURING SCHEDULED C-CHECK PER CARD B1-14010, FOUND SEAT TRACK LUG WORN BEYOND LIMITS AT BS 783 AND LBL 45. REMOVED AND REPLACED SEAT TRACK SECTION FROM BS 760 TO 850 IAW SRM 53-10-2 FIG 7. M54 NR 297.SDR RAAA99B2015Seat Track · corrodedDURING SCHEDULED C-CHECK, FOUND RT SEAT TRACK IN AFT PIT CORRODED FROM BS 1096 TO 1136. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-20-9. M54 NR 294.SDR RAAA99B2014Seat Track · corrodedDURING SCHEDULED INSPECTION PER CARD B1 14010, FOUND RT OUTBOARD SEAT TRACK CORRODED BS 480, 500, 540, 560 AND 580. REPLACED SEAT TRACK FROM BS 380 T0 600 IAW SRM 53-10-05 FIG 7. M54 NR 291.SDR RAAA99B2013Skin · gougedDURING SCHEDULED C-CHECK, FOUND DEEP GOUGE WORN IN EXTERIOR SKIN BS 1060 AT STR 18R. REMOVED DAMAGED AREA, INSTALLED REPAIR DOUBLER IAW SRM 53-30-03 FIG 5. M54 NR 284.SDR RAAA99B2012Seat Track · brokenDURING SCHEDULED C-CHECK, FOUND BROKEN LUG IN SEAT TRACK AT BS 580 AND BL 0. REPLACED SEAT TRACK SPLICE BS 540 T0 600 AT BL 0 IAW SRM 53-10-05. M54 NR 233.SDR RAAA99B2011Seat Track · corrodedDURING SCHEDULED C-CHECK, FOUND BULGE IN SEAT TRACK OUTER FLANGE BS 520 AT LBL 45. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-10-01. M54 NR 230.SDR RAAA99B2010Seat Track · corrodedDURING SCHEDULED C-CHECK, FOUND SEAT TRACK CORRODED AT LBL 45 FROM BS 560 TO 580. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-10-01, M54 NR 229.SDR RAAA99B2009Seat Track · corrodedDURING SCHEDULED INSPECTION PER CARD S354102, FOUND RT SEAT TRACK CORRODED IN THE UPPER SURFACE BS 1030 TO 1096. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-10-01, M54 NR 219.SDR RAAA99B2008Skin · gougedDURING SCHEDULED CHECK PER CARD C53002, FOUND GROVE WORN IN FUS SKIN AT BS 690 AND STR 25R. INSTALLED REPAIR IAW SRM 53-30-3 FIG 1. M54 NR 36.SDR RAAA99B2007Sill · corrodedDURING SCHEDULED S6 INSPECTION PER CARD S6 52103, FOUND LOWER FWD CARGO DOOR SILL VERTICAL WEB AT STR 26R AND BS 520 THRU 570 CORRODED. FABRICATED REPLACEMENT WEB IAW SRM 51-20-1 FIG 7 FROM 063 7075T6 IAW SRM 53-10-2 FIG 3 AND INSTALLED IAW 51-30-2.SDR RAAA99B2006Skin · gougedDURING SCHEDULED C-CHECK, FOUND DEEP GOUGE IN SKIN BS 660 AT STR 25R. INSTALLED REPAIR IAW SRM 53-30-3 FIG 1.SDR RAAA99B2005Skin · gougedDURING SCHEDULED C-CHECK, FOUND SKIN GOUGED BETWEEN STR 27R TO 28R AT BS 1095. INSTALLED REPAIR DOUBLER IAW SRM 5330.SDR RAAA99B2004Skin · dentedDURING SCHEDULED C-CHECK, FOUND SKIN DENTED BETWEEN STR 26R TO 29R AT BS 1132. REMOVED DAMAGE, INSTALLED REPAIR DOUBLER IAW SRM 53-30-3.SDR RAAA99B2003Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA99B2002Light · damagedFLIGHT CREW REPORTED PAX ROW 22 FLOOR PROXIMITY EGRESS LIGHT LENS BROKEN AND BULB MISSING. CHANGED LIGHT ASSY DUE DAMAGED.SDR RAAA99B2001Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2052Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT AND AFT EMERGENCY EXIT EGRESS IDENTIFIER LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA98B2051Switch · shortedFLIGHT CREW REPORTED ON CLIMBOUT DURING GEAR RETRACTION, ALL GEAR INTRANSIT LIGHTS (RED) WENT OUT MOMENTARILY THEN CAME BACK ON AND STAYED ON (GEAR HANDLE IN UP POSITION). LDG SELECTOR TO OFF, NO CHANGE. LDG SELECTED DOWN, 3 GREEN LIGHTS PLUS NLG INTRANSIT LSDR RAAA98B2050Light · inopRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED LIGHT ASSY DUE FAILED.SDR RAAA98B2049Battery Pack · dischargedPAX ROW 12 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2048Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2047Battery Pack · dischargedCREW REPORTS NEED TO CHECK BATTERIES FOR PAX ROW 12 FLOOR PROXIMITY EGRESS LIGHT. CHANGED BATTERY PACK DUE DISCHARGED.
Back to N832RV, cancelled Jun 13, 2001