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 RAAA98B2046Battery Pack · dischargedAFT EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2045Trunnion · corrodedDURING SCHEDULED RIGHT MAIN LANDING GEAR CHANGE CPCP TASK C32-135-01 VISUAL AND HFEC INSPECTION FOUND WS 224.5 AFT REAR SPAR LANDING GEAR TRUNNION SUPPORT CORRODED IN AND AROUND BEARING RETAINER BUSHINGS AND FLANGE SURFACES. CHANGED AFT REAR SPAR LANDING GEARSDR RAAA98B2044Trunnion · corrodedDURING SCHEDULED LEFT MAIN LANDING GEAR CHANGE CPCP TASK C32-135-01 VISUAL AND HFEC INSPECTION FOUND WS 224.5 AFT REAR SPAR LANDING GEAR TRUNNION SUPPORT CORRODED IN AND AROUND BEARING RETAINER BUSHINGS AND FLANGE SURFACES. CHANGED AFT REAR SPAR LANDING GEAR SDR RAAA98B2043Battery Pack · dischargedLT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2042Battery Pack · dischargedPAX ROW 17 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2041Light · illuminatedPAX ROW 2 FLOOR PROXIMITY EGRESS LIGHT WOULD NOT EXTINGUISH AT GATE. RESET EMERGENCY LIGHTS AND CHECKED OK.SDR RAAA98B2040Actuator · failedDURING CLIMBOUT, LE FLAP STATUS DISAGREEMENT LIGHT ON AFTER FLAPS RETRACTED. RETURNED TO UUS AND LANDED WITHOUT INCIDENT. FOUND NR 5 LE FLAP WOULD NOT RETRACT. CHANGED NR 5 LE FLAP ACTUATOR AND SHUTTLE VALVE DUE ACTUATOR FAILED IN EXTENDED POSITION.SDR RAAA98B2039Sign · failedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED EGRESS IDENTIFIER ASSY DUE FAILED.SDR RAAA98B2038Battery Pack · dischargedLT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2037Battery Pack · dischargedPAX ROW 10 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2036Web · crackedDURING SCHEDULED S5 INSPECTION PER CARD S5 34103, FOUND RT LOWER TORQUE BOX VERTICAL WEB CRACKED AT LIGHTING HOLE, BS 1223, RBL 21. REPAIRED PER SRM 53-10-2 AND 51-40-2, M-54 NR 354.SDR RAAA98B2035Shear Tie · corrodedDURING SCHEDULED S5 INSPECTION PER CARD S6 54104, FOUND BS 1130 FRAME SHEAR TIE CORRODED AT STR 28R TO 29R. REPLACED SHEAR TIE PER SRM 51-10-1 AND 51-30-2, M-54 NR 307.SDR RAAA98B2034Frame · corrodedDURING SCHEDULED S5 INSPECTION PER CARD S6 54104, FOUND BS 1130 FRAME FWD FACE AND SHEAR TIE CORRODED AT STR 29L TO 29R. REPAIRED PER SRM 53-10-4, FIG 15, SHEET 3, 51-10-6 AND 51-30-2, M-54 NR 305.SDR RAAA98B2033Angle · crackedDURING SCHEDULED S5 INSPECTION PER CARD S5 33103, FOUND ACCESS PANEL NR 5222 ATTACH ANGLE CRACKED AT BS 1408. REPAIRED PER SRM 51-30-2 AND 51-40-3, M-54 NR 277.SDR RAAA98B2032Floorbeam · misdrilledDURING SCHEDULED S5 INSPECTION PER CARD S6 54104, FOUND BS 1166 FLOORBEAM WITH 2 DRILL HOLES IN UPPER CHORD. REPAIRED PER BAC MSG RVV-SEA-98-0010RR AND SRM 53-10-8, FIG 3 M-54 NR 261.SDR RAAA98B2031Shear Tie · corrodedDURING SCHEDULED S5 INSPECTION PER CARD S6 54104, FOUND BS 1166 FRAME SHEAR TIE CORRODED AT STR 28R TO 30. REPLACED SHEAR TIE PER SRM 51-30-2, 51-10-6, 51-20-04 AND 51-10-1, M-54 NR 260.SDR RAAA98B2030Bulkhead Chord · damagedDURING SCHEDULED B3 CHECK PER CARD B146001, FOUND BS 950 BULKHEAD UPPER CHORD TOOL DAMAGED AT RBL 42. REPAIRED PER SRM 51-40-3, M-54 NR 208.SDR RAAA98B2029Battery Pack · dischargedFWD RT EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2028Battery Pack · dischargedPAX ROW 22 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2027Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2026Light · brokenPAX ROW 17 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK DUE BROKEN LAMP ASSY. CHANGED PROXIMITY LIGHT ASSY.SDR RAAA98B2025Battery Pack · dischargedFWD LT AND AFT LT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA98B2024Light · brokenPAX ROW 2 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK DUE BROKEN LAMP ASSY. CHANGED PROXIMITY LIGHT ASSY.SDR RAAA98B2023Battery Pack · dischargedPAX ROW 10 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2022Battery Pack · dischargedMID CABIN DOOR EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2021Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2020Battery Pack · dischargedPAX ROW 17 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2019Light · failedPAX ROW 14 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED LIGHT ASSY DUE FAILED.SDR RAAA98B2018Sign · failedFWD LT EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED LIGHT ASSY DUE FAILED.SDR RAAA98B2017Battery Pack · dischargedPAX ROW 2 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2016Rib · crackedDURING SCHEDULED AD 94-07-08 INSPECTION PER S/B 727-57-127, FOUND LEFT WS 601.5 RIB UPPPER CHORD CRACKED APPROX 1.0 IN AT S-14 ATTACH. REPAIRED PER SRM 57-10-5, FIG 1 M-54 NR 1.SDR RAAA98B2015Rib · crackedDURING SCHEDULED AD 94-07-08 INSPECTION PER S/B 727-57-127 FOUND LEFT WS 601.5 RIB LOWER CHORD CRACKED APPROX 1.5 INCHES AT S-6 ATTACH. REPAIRED PER SRM 57-10-5, FIG 1 M-54 NR 2.SDR RAAA98B2014Battery Pack. · dischargedPAX ROW 12 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2013Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2012Battery Pack · dischargedRT FWD AND RT AFT EXTERNAL OVERWING EMERGENCY LIGHTS FAILED SERVICE CHECK. CHANGED BATTERY PACKS DUE DISCHARGED.SDR RAAA98B2011Fitting · crackedDURING SCHEDULED NLG CHANGE AND ACCOMPLISHMENT OF CPCP TASK CARD C32-131-01 FOUND 2.1 INCH CRACK THROUGH DRAG BRACE SUPPORT FITTING INTERCOSTAL RADIUS. CHANGED DRAG BRACE SUPPORT FITTING PER S/B 727 53-69, REV 2 M-54 NR 1.SDR RAAA98B2010Battery Pack · dischargedAFT EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2009Emergency Light · inoperativeMID CABIN DOOR EMERGENCY EXIT LIGHT FLASHES ON AND OFF. CHANGED LIGHT ASSY DUE FAILED.SDR RAAA98B2008Battery Pack · dischargedRT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2007Battery Pack · dischargedPAX ROW 22 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2006Battery Pack · dischargedPAX ROW 17 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2005Battery Pack · dischargedPAX ROW 22 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2004Battery Pack · dischargedPAX ROW 17 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2003Battery Pack · dischargedAFT RT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2002Battery Pack · dischargedPAX ROW 2 FLOOR PROXIMITY EGRESS LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA98B2001Keel Beam Web · crackedDURING SCHEDULED 2B CHECK, FOUND KEEL BEAM WEB CRACKED APPROX 1.2 INCH AT BS 940 RBL 7 WL 148. REPAIRED PER SRM 51-40-2 FIG 1. M-54 NR 17.SDR RAAA97B2051Battery Pack · dischargedFWD CABIN DOOR EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2050Battery Pack · dischargedLT FWD OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2049Battery Pack · dischargedLT AFT OVERWING EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.SDR RAAA97B2048Battery Pack · dischargedAFT EMERGENCY EXIT EGRESS IDENTIFIER LIGHT FAILED SERVICE CHECK. CHANGED BATTERY PACK DUE DISCHARGED.
Back to N832RV, cancelled Jun 13, 2001