N625BR, cancelled Jun 14, 2017
Service difficulty reports · 39
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 = 'N625BR' AND deregistration_id = 'N625BR-2017-06-14' 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 = 'N625BR' AND deregistration_id = 'N625BR-2017-06-14' 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 VTZA200500090Engine · shutdownRT ENG SHUTDOWN ON TAKEOFF ROLL AT ROTATION.SDR VTZA200500076Floorbeam · corrodedFLOORBEAM AT FS 310 RBL 27 HAS LEVEL 2 CORROSION.SDR VTZA200500078Floorbeam · corrodedFLOORBEAM AT FS 310 LBL 27 HAS LEVEL 2 CORROSION.SDR VTZA200500079Floorbeam · corrodedFLOORBEAM AT FS 310 LBL 9 HAS LEVEL 2 CORROSION.SDR VTZA200500077Floorbeam · corrodedFLOORBEAM AT FS 310 RBL 9 HAS LEVEL 2 CORROSION.SDR VTZA200500075Bulkhead · crackedLEFT SIDE PILOTS BULKHEAD AT FS 280 RBL 9.0 IS CRACKED AT 1.0 INCH IN WEB RADIUS.SDR VTZA200500071Frame · crackedLEFT FS 640 FRAME IS CRACKED IN RADIUS AT 1 INCH IN LENGTH.SDR VTZA200500070Angle · crackedLEFT 624 OBLIQUE ANGLE IS CRACKED AT .750 INCH IN RADIUS.SDR VTZA200500074Link · crackedLEFT AILERON LINK ON THE OUTBOARD PCU IS CRACKED IN HALF.SDR VTZA200500069Rib · crackedLEFT BATT RIB IS CRACKED 1.5 INCH.SDR VTZA200500068Rib · crackedRIGHT BATT RIB IS CRACKED .750 INCH BETWEEN THE ATTACHING FASTENERS.SDR VTZA200500073Door Frame · crackedPAX DOOR FRAME TOP RADIUS CRACKED AT 1 INCH IN LENGTH FORWARD OF DATUM 1 AT FS 320.90.SDR VTZA200500072Door Frame · crackedPAX DOOR FRAME TOP RADIUS CRACKED AT 1 INCH IN LENGTH FORWARD OF DATUM 1 AT FS 338.90.SDR VTZA200500046Pitot Line · obstructedNO STANDBY AIRSPEED INDICATION ON TAKEOFF ROLL. PURGED STANDBY PITOT SYSTEM WITH NITROGEN. REF AMM 34-11-00. PERFORMED OPS CHECK ON STANDBY AIRSPEED, OPS CHECK GOOD. REF AMM 34-12-01.SDR 05052625Landing Gear · malfunctionedGEAR DISAGREE MESSAGE AND NLG WOULD NOT RETRACT. MX PERFORMED GEAR SWINGS SEVERAL TIMES. NO DEFECT NOTED.SDR 04251625Tube · leakingEVENT SUMMARY STATED EMERGENCY DECLARED FOR HYD 2 LOW PSI MSG. A/C LANDED SAFELY AT GATE. REMOVED AND REPLACED RT LOWER FAIRING. REMOVED AND REPLACED RETURN TUBE ASSY, RESERVOIR TUBE ASSY, FILL TUBE ASSY FOR NR 2 HYD. INSTALLED SCREWS ON RT ENGINE PYLON.SDR 03361625Window · crackedDURING CRUISE, CREW REPORTED THE CAPTAINS SIDE WINDOW CRACKED. THE AIRCRAFT WAS FERRIED TO ORD WERE THE WINDOW WAS REPLACED AND A SATISFACTORY PRESSURIZATION CHECK WAS PERFORMED ON THE AIRCRAFT. THE AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 033286257Floorbeam · corrodedDURING HEAVY CHECK INSPECTION THE FLOORBEAM AT FS 335 LBL 9 WAS IDENTIFIED CORRODED. FLOOR BEAM WAS REPAIRED PER SRM AND AIRCRAFT WAS RELEASED FOR SERVICE UPON COMPLETION OF HEAVY CHECK INSPECTION.SDR 033286256Floorbeam · corrodedDURING HEAVY CHECK INSPECTION THE FLOORBEAM AT FS 360 LBL 9 WAS IDENTIFIED AS HAVING HEAVY CORROSION. FLOORBEAM WAS REPAIRED IAW SRM AND AIRCRAFT WAS RELEASED FOR SERVICE UPON COMPLETION OF HEAVY CHECK INSPECTION.SDR 033286255Floorbeam · corrodedDURING HEAVY CHECK INSPECTION THE FLOORBEAM WAS IDENTIFIED WITH CORROSION AT FS 319 LBL 25. FLOORBEAM WAS REPAIRED PER REO AND AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE UPON COMPLETION OF HEAVY CHECK INSPECTION.SDR 033286254Floorbeam · corrodedDURING HEAVY CHECK INSPECTION THE FLOOR BEAM WAS FOUND CORRODED BETWEEN FS 333 AND FS 349, RBL 27. THE FLOORBEAM SECTION THAT WAS CORRODED WAS REPAIRED PER SRM INSTRUCTIONS. AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 033286252Skin · gougedDURING HEAVY CHECK A GOUGE WAS FOUND ON THE FUSELAGE SKIN BETWEEN STRINGERS 21 AND 22. THE GOUGE WAS 5 INCHES LONG BY 2.5 INCHES WIDE, WITH A 4 INCH CREASE IN SKIN AND MEASURED .090 IN DEPTH. THE REPAIR WAS MADE IN ACCORDANCE WITH SRM PROCEDURES AND AIRCRAFTSDR 033286251Light · inoperativeDURING INSPECTION THE CEILING EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE BULB WAS FOUND BURNT OUT AND WAS REPLACED. A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED AND AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 03328625Light · inoperativeDURING INSPECTION THE LT EXTERNAL EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE BULB WAS FOUND TO BE INOPERATIVE AND WAS REPLACED. A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED AND AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 03307625Light · inoperativeDURING INSPECTION THE AFT STRIP OF EMERGENCY ESCAPE PATH LIGHTING WAS FOUND INOPERATIVE.SDR 03297625Bulkhead · damagedDURING INSPECTION A DENT WITH A HOLE WAS DISCOVERED AT FS 621.00 RBL 9.00.SDR 03199625Light · inoperativeDURING MAINTENANCE INSPECTION, THE FWD RT WING EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT LIGHT. AN OPERATIONAL CHECK WAS SATISFACTORY AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR 03155625Lamp · inoperativeDURING MAINTENANCE INSPECTION, THE LT MID OVERWING EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT LIGHT. AN OPERATIONAL CHECK WAS SATISFACTORY AND THE AIRCRAFT WAS RETURNED TO SERVISDR 03069625Light · inoperativeDURING MAINTENANCE/INSPECTION, MAINTENANCE PERSONNEL FOUND LT AFT EXTERNAL EMERGENCY LIGHT INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND RELAMPED LT AFT EXT EMERGENCY LIGHT. OPS CK'D GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 03066625LampDuring overnight maintenance, it was discovered that the l/h aft exterior emergency exit light was inoperative. Maintenance personnel removed and replaced the lamp in the light assy. An operational check was satisfactory and the aircraft was returned to servSDR 03027625Proximity Switch · out of adjustON TAKEOFF, RECEIVED NOSE GEAR DISAGREE AND NOSE DOOR MESSAGE WITH AURAL WARNING. ADJUSTED NOSE GEAR PROX SWITCH. OPS CHECKED OK.SDR VTZA990162Strap · looseRDU/IAD - FLT 7792 - DURING CRUISE, AIRCRAFT DIVERTED TO RIC DUE TO PASSENGER DOOR WARNING ON EICAS. AIRCRAFT WENT TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND RE-SECURED LOOSE BONDING STRAP FROM PROXIMITY SENSOR, OPS CHECK OK. AIRCRAFT RELEASDR VTZA990083Control Module · failedFLT 7763 - IAD-RDU - AIRCRAFT ABORTED TAKEOFF DUE TO AIRCRAFT PULLED HARD RIGHT DURING TAKEOFF ROLL. AIRCRAFT RETURNED TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND REMOVED AND REPLACED NOSE WHEEL STEERING CONTROL MODULE, OPS CHECK OK. AIRCRAFSDR VTZA990036O-Ring · failedFLT 7241 - CMH-IAD - DURING APPROACH, AIRCRAFT NR 3 HYDRAULIC SYSTEM QTY WENT TO ZERO. CREW UTILIZED ABNORMAL PROCEDURE AND LOWERED LANDING GEAR MANUALLY. MAINTENANCE REMOVED AND REPLACED INBOARD SIDE FITTING O-RING OF NR 3 HYDRAULIC SYSTEM ACCUMULATOR, AND SDR VTZA98329Warning System · illuminatedFLT 6636 - ORD-CRW - DURING TAKEOFF, EXPERIENCED A RIGHT AOA PROBE HEAT FAIL AND TAT HEAT FAIL INDICATION ON THE MASTER CAUTION PANEL. AIRCRAFT CONTACTED MAINTENANCE CONTROL AND DISPATCH, DECISION TO RETURN TO ORD WAS MADE. UPON ARRIVAL AT ORD, THE AIRCRAFT SDR VTZA98283Switch · looseFLT 6715 - IAD-ATL - DURING CLIMB, AIRCRAFT MADE AN UNSCHEDULED LANDING DUE TO RT ENGNE 10TH STAGE SOV WOULD NOT OPEN. AIRCRAFT RETURNED TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND RESECURED LOOSE CONNECTOR ON LIGHT SWITCH, OPS CHECK OK. AIRCSDR VTZA98235Handle · lack of lubeIAD/SAV - FLT 6735 - DURING CRUISE AT 2215 HOURS, EXPERIENCED A PASSENGER DOOR WARNING MESSAGE. AIRCRAFT RETURNED TO THE IAD AND NOTIFIED MAINTENANCE CONTROL. MAINTENANCE WAS DISPATCHED TO THE AIRCRAFT AND LUBRICATED THE PASSENGER DOOR OUTER HANDLE. ALL REQSDR VTZA9821DAoa Heat · failedIAD/BNA - FLT 6700 - DURING CRUISE AT 0830 HRS ON 6-5-98, AIRCRAFT MADE AN UNSCHEDULED LANDING DUE TO LT AOA HEAT INOPERABLE. AIRCRAFT RETURNED TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND COULD NOT DUPLICATE PROBLEM, OPS CHECK OK. AIRCRAFT RSDR VTZA98179Coalescer Bags · failedIAD/JAX - FLT 6751 - DURING CLIMB, AT 0750 HRS ON 4-30-98, AIRCRAFT MADE AN UNSCHEDULED LANDING DUE TO LAV SMOKE WARNING LIGHT ILLUMINATED. AIRCRAFT RETURNED TO GATE WITH NO FURTHER PROBLEMS. MAINTENANCE INSPECTED AND REMOVED AND REPLACED BOTH FCS COALESER B
Back to N625BR, cancelled Jun 14, 2017