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 RAAA97B2047Battery Pack · dischargedPAX ROW 14, 17 AND 22 FLOOR PROXIMITY EGRESS LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA97B2046Battery Pack · dischargedFWD CABIN DOOR EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2045Battery Pack · dischargedPAX ROW 11 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2044Battery Pack · dischargedPAX ROW 22 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2043Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2042Battery Pack · dischargedFLIGHT CREW REPORTED FWD LT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FLASHING IN FLIGHT. CHANGED BATTERY PACK DUE DISCHARGED AND PERFORMED FUNCTIONAL TEST.SDR RAAA97B2041Battery Pack · dischargedFLIGHT CREW REPORTED PAX ROW 14 EGRESS FLOOR PROXIMITY LIGHT CAME ON AND WOULD NOT EXTINGUISH IN FLIGHT. CHANGED BATTERY PACK DUE DISCHARGED AND PERFORMED FUNCTIONAL TEST.SDR RAAA97B2040Battery Pack · dischargedPAX ROW 14 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2039Battery Pack · dischargedFWD AND MID CABIN EMERGENCY EXITS EGRESS IDENTIFIER LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA97B2038Battery Pack · dischargedPAX ROW 8 AND 17 FLOOR PROXIMITY EGRESS LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA97B2037Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2036Light · failedLEFT FWD OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT (AFT) FAILED SERVICE CHECK. CHANGED LIGHT ASSY WITH BATTERY PACK.SDR RAAA97B2035Battery Pack · dischargedLEFT FWD OVERWING EMERGENCY EXIT IDENTIFIER LIGHT (FWD) FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2034Battery Pack · dischargedPAX ROW 13 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2033Battery Pack · dischargedRIGHT FWD AND AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA97B2032Battery Pack · dischargedPAX ROW 17 FLOOR PROXIMITY LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2031Battery Pack · dischargedPAX ROW 17 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2030Battery Pack · dischargedLEFT FWD OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2029Battery Pack · dischargedMID CABIN OVERHEAD EMERGENCY EXIT LIGHT FAILED SERVICE CHECK. REPLACED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2028Battery Pack · dischargedROW 2 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2027Rib · damagedDURING SCHEDULED C1 CHECK, FOUND NR 7 LE SLAT, OUTBOARD TRACK, OUTBOARD MOUNT RIB DAMAGED FROM TRACK BOLT REMOVAL AT SLAT STA 330. REPAIRED PER SRM 57-50-2.SDR RAAA97B2026Rib · crackedDURING AD 94-07-08 INSPECTION, FOUND RBL 70.5 WING RIB UPPER CHORD CRACKED VERTICALLY BETWEEN FORWARD HOLES (REF S/B 727-57-0112) AT BS 760.95. REPAIRED PER S/B 727-57-0112, REV 4 SECTION III, PART V.SDR RAAA97B2025Rib · crackedDURING AD 94-07-08 INSPECTION, FOUND LBL 70.5 WING RIB UPPER CHORD CRACKED VERTICALLY BETWEEN FORWARD HOLES (REF S/B 727-57-0112) AT BS 760.95. REPAIRED PER S/B 727-57-0112, REV 4, SECTION III, PART V.SDR RAAA97B2024Stiffener · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND LEFT WING REAR SPAR WEB STIFFENER CORRODED AT WBL 114. REPAIRED PER SRM 51-40-4, FIG 1.SDR RAAA97B2023Rib · crackedDURING SCHEDULED C1 CHECK, FOUND NR 2 LE SLAT RIB CRACKED AT SLAT STA 262. REPAIRED PER SRM 57-50-2.SDR RAAA97B2022Skin · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND CENTER WING UPPER SKIN CORRODED RBL 45 TO RBL 65 AND BS 850 TO BS 870. REPAIRED PER BOEING MSG RVV 97-0009RR.SDR RAAA97B2021Angle · corrodedDURING SCHEDULED C1 CHECK, FOUND RBL 45.5 FLOOR BEAM BUILT UP SECTION ATTACH ANGLE CORRODED AT BS 868, WL 180. REPAIRED PER SRM 51-40-4, FIG 1.SDR RAAA97B2020Splice · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14111, FOUND STR 16L SPLICE CORRODED AT BS 848. REPAIRED PER SRM 53-10-3.SDR RAAA97B2019Spar Chord · corrodedDURING SCHEDULED C1 CHECK, FOUND RIGHT WING FRONT SPAR UPPER CHORD CORRODED AT WS 513. REPAIRED PER BOEING MSG RVV-SEA-97-0004RR.SDR RAAA97B2018Spar Chord · corrodedDURING SCHEDULED C1 CHECK, FOUND RIGHT WING FRONT SPAR UPPER CHORD CORRODED AT WS 524. REPAIRED PER BOEING MSG RVV-SEA-97-0004RR.SDR RAAA97B2017Spar Chord · corrodedDURING SCHEDULED C1 CHECK, FOUND RIGHT WING FRONT SPAR UPPER CHORD CORRODED AT WS 499. REPAIRED PER BOEING MSG RVV-SEA-97-0003RR.SDR RAAA97B2016Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND RIGHT OUTBOARD AFT FLAP SKIN DELAMINATED AT WBL 295. REPAIRED PER SRM 51-40-6.SDR RAAA97B2015Angle · crackedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14111, FOUND FORWARD ENTRY DOOR FRAME LOWER AFT HORIZONTAL ANGLE CRACKED AT BS 348, WL 217. REPLACED ANGLE PER SRM 51-10-1.SDR RAAA97B2014Seat Track · brokenDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND RBL 24.75 SEAT TRACK OUTBOARD FLANGE BROKEN OFF AT BS 870. REPAIRED PER SRM 53-10-5, FIG 9 SHEET 3.SDR RAAA97B2013Seat Track · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND LBL 45.5 SEAT TRACK INBOARD FLANGE CORRODED AT BS 845. REPAIRED PER SRM 53-10-5.SDR RAAA97B2012Floor Link · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND BS 870 SEAT TRACK FLOOR LINK ATTACH POINTS WORN AND UPPER FLANGES CORRODED AT LBL 45.5, LBL 24.75, BL 0, RBL 24.75, AND RBL 45.5. REPLACED FLOOR LINKS, SEAT TRACKS, BUSHINGS AND BOLTS PERSDR RAAA97B2011Floor Link · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND BS 740 SEAT TRACK FLOOR LINK ATTACH POINTS WORN AND UPPER FLANGES CORRODED AT LBL 45.5, BL 0, RBL 24.75 AND RBL 45.5. REPLACED FLOOR LINKS, SEAT TRACKS, BUSHINGS AND BOLTS PER SRM 51-10-1SDR RAAA97B2010Seat Track · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND RBL 45.5 SEAT TRACK INBOARD CHORD LOWER SURFACE CORRODED AT BS 862. REPAIRED PER SRM 51-40-4 FIG 1.SDR RAAA97B2009Spar Chord · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14108, FOUND CENTER WING UPPER REAR SPAR CHORD CORRODED, LBL 50 TO LBL 70 AND RBL 40 AT BS 870. REPLACED CENTER WING UPPER REAR SPAR CHORD PER BOEING MSG 9710012RR AND 970010TR.SDR RAAA97B2008Angle · damagedDURING SCHEDULED C1 CHECK, FOUND AFT CARGO COMPARTMENT FLOOR SUPPORT RBL 24 Z-ANGLE HOLED AT BS 1130 AND CORROSION BLENDOUT BEYOND LIMITS AT BS 1050. REPLACED Z-ANGLE FROM BS 1044 TO 1140 PER SRM 51-40-4 FIG 1, SHEET 5.SDR RAAA97B2007Stiffener · crackedDURING SCHEDULED C1 CHECK, FOUND NR 3 SPOILER OUTBOARD MOUNT STIFFENER ON REAR SPAR CRACKED AT WS 519. REPLACED STIFFENER PER SRM 51-30-02.SDR RAAA97B2006Frame · corrodedDURING AD 94-02-04 INSPECTION, FOUND LT BS 783.95 FRAME WEB CORRODED AT WL 200. REPAIRED PER S/B 727-53-197.SDR RAAA97B2005Fitting · corrodedDURING SCHEDULED C1 CHECK, FOUND LEFT AFT CENTER WING TERMINAL PIN FITTING CORRODED BETWEEN PREVIOUS REPAIR PLATES ON INBOARD FLANGE AT BS 870. REPAIRED PER S/B 727-53-27, DWG 65-82247 AND 65-78694.SDR RAAA97B2004Casting · crackedDURING SCHEDULED C1 CHECK, FOUND LMLG UPLOCK ASSEMBLY ATTACH CASTING CRACKED AT FORWARD LUG, BS 910. REPLACED CASTING PER S/B 727-53-103.SDR RAAA97B2003Link Assembly · crackedDURING SCHEDULED C1 CHECK, FOUND LMLG UPLOCK MOUNT ASSEMBLY OUTBOARD FORWARD LINK ASSY CRACKED AT BS 910. REPLACED PER SRM 51-10-1.SDR RAAA97B2002Seat Track · corrodedDURING SCHEDULED S4 STRUCTURAL/CPCP INSPECTION PER CARD S4 14106, FOUND BL 0 SEAT TRACK CORRODED FROM BS 1130 TO 1176. REPLACED AND SPLICED CENTER SEAT TRACK PER SRM 53-10-5.SDR RAAA97B2001Chord · crackedDURING AD 94-07-08 INSPECTION, FOUND RT LOWER TORQUE BOX UPPER CHORD CRACKED AT BS 1263. REPAIRED PER S/B 727-53-129 AND DWG NR 65-C-27136.SDR RAAA96B2048Battery Pack · dischargedLT AFT OVERWING EMERGENCY EXIT EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE LOW CHARGE.SDR RAAA96B2047Battery Pack · dischargedLT FWD OVERWING EMERGENCY EXIT EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE LOW CHARGE.SDR RAAA96B2046Pbe · failedFLIGHT ATTENDANT REPORTED ROW 22 PBE RED INDICATOR PIN PROTRUDING. CHANGED PBE DUE SEAL FAILURE.
Back to N832RV, cancelled Jun 13, 2001