N680BR, cancelled Mar 10, 2022
Service difficulty reports · 74
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 = 'N680BR' AND deregistration_id = 'N680BR-2022-03-10' 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 = 'N680BR' AND deregistration_id = 'N680BR-2022-03-10' 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 ASOA2013051503547Lamp · burned outOVERHEAD EMERGENCY LIGHT AT ROW 1 IN INOPERATIVE. REPLACED LAMP THE OVERHEAD EMERGENCY LIGHT AT ROW 1 IAW AMM 33-51-16, OPS CHECKED GOOD.SDR ASOA2012092702309Floorbeam · corrodedFLOORBEAM CAP FS 589 BL 0 HAS MINOR CORROSION. REMOVED CAP IAW SRM 51-42-06. LOCATED AND DRILLED UP NEW CAP PN IAW SRM 51-40-11.SDR ASOA2012092702308Isolator · brokenFS 621.00 PRESSURE BULKHEAD FWD FACE HAS THREE BROKEN ISOLATORS. REMOVED DAMAGE ISOLATORS AND INSTALLED IAW SRM 51-42-06.SDR ASOA2012092702307Floorbeam · crackedCABIN COMPARTMENT FLOORBEAM BS 484 CRACKED AT RBL 36 AND LBL 36. REPAIRED IAW REO 601R-53-41-059 AND NDTM PT1 51-20-06.SDR ASOA2012092702306Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED APPROX 1.5 INCHES LONG. R & R THE PAX DOOR AFT DRAG ANGLE IAW SRM 51-42-06 & SRM 51-42-13.SDR ASOA201201647Bulkhead · crackedAFT PRESSURE BULKHEAD CRACKED AT RBL 27.50. CUT AWAY DAMAGE IAW REO 601R-53-61-1285. COMPLIED WITH NDT EDDY CURRENT INSPECTION OF CUT LINE IAW NDTM 51-20-06, PART 1 AND REO 601R-53-61-1285, REV D. NO DEFECTS NOTED. FABRICATED REPAIR DOUBLER AND FILLERS. SDR ASOA201201645Bulkhead · crackedAFT PRESSURE BULKHEAD CRACKED AT RBL 36.20. CUT AWAY DAMAGE IAW REO 601R-53-61-1285. COMPLIED WITH NDT EDDY CURRENT INSPECTION OF CUT LINE IAW NDTM 51-20-06, PART 1 AND IAW REO 601R-53-61-1285, REV D. NO DEFECTS NOTED. FABRICATED REPAIR DOUBLER AND FILLER.SDR ASOA201201462Switch · unserviceableLEFT ENGINE BOTTLE NOT ARMING DURING FIRST FLIGHT OF DAY FIRE WARNING TEST PUSH TO DISCHARGE LIGHT DOESN'T LIGHT UP. CLEANED PBA FOR PUSH LIGHT LT AND RT PUSH TO DISCHARGE SWITCH, INSTALLED A NEW SWITCH ASSY IAW ESPM 20-24-00. OPS CHECK GOOD. (SDR CLOSED)SDR ASOA201201413Relay · failedOVERBOARD COOL CAUTION MESSAGE. ACFT RETURNED TO DEPARTURE, EMERGENCY DECLARED. OVERBOARD EXHAUST SHUTOFF VALVE (AVIONICS COOLING) INOPERATIVE OPEN. R & R WOW RELAY (K8HK) AND DOOR LOCKED RELAY (K9HK) IAW ESPM 20-22-00. SYS CHECKED GOOD IAW AMM 21-24-34.SDR ASOA201101388Flap System · failedFLAPS FAILED ON APPROACH AT 11. EMERGENCY DECLARED AS A PRECAUTION. COMPLIED WITH EC/TC AD 2009-06-12 , ACFT OK FOR SERVICE MCOL 767097 CLEARED .SDR ASOA201101385Control Unit · failedFLAPS FAILED AT 0 DURING APPROACH. EMERGENCY DECLARED AS A PRECAUTION. R & R FECU IAW AMM 27-51-05. OPS CHECKED GOOD. ACFT OK FOR CONTINUED SERVICE. (CLOSED)SDR ASOA201001076Computer · failedABNORMAL INCREASE OF FUEL IN CTR TANK. FUEL IMBALANCE MESSAGE. (ENROUTE, ACFT DIVERTED DUE TO MX -- EMERGENCY DECLARED) R & R FUEL COMPUTER AND REFUEL/DEFUEL PANEL IAW AMM 28-41-16, OPS CHECK GOOD AND 28-25-16 OPS CHECK GOOD. (CLOSED)SDR ASOA201001029Lamp · burned outRT FUSELAGE AFT MOST EXTERIOR EMERGENCY LIGHT IS INOP. R & R BULB IAW SRM 51-42-06 AND 51-42-21.SDR ASOA201000341Floor Support · corrodedCARGO FLOORBEAM FITTING AT FS 605.00 - 621.00 LBL 27.00 IS CORRODED AROUND NUTPLATES. REMOVED CARGO FLOORBEAM FITTING IAW SRM 51-42-06, 51-42-21 AND 51-41-02. NEW FITTIGN NEEDS INSTALLED. LOCATED, DRILLED, DEBURRED NEW FITTING IAW SRM 51-40-11. C/W EC/TC RESDR ASOA201000339Floorbeam · corrodedCARGO FLOORBEAM CAP FROM FS 574.00 - 605.00 LBL 27.00 IS CORRODED AROUND NUTPLATE HOLES. REMOVED CARGO FLOORBEAM CAP FROM STA 574-605 LBL 27.00 IAW SRM 51-42-06 AND 51-42-21. LOCATED, DRILLED, COUNTERSUNK AND DEBURRED NEW CARGO FLOORBEAM CAP IAW SRM 51-40-11.SDR ASOA201000322Angle · crackedUPON INSTALLATION OF CARGO DOOR SILL PLATE, FOUND ANGLE AT FS 589.00 TO BE CRACKED. REMOVED CRACKED ANGLE IAW SRM 51-42-21. INSTALLED NEW SERVICEABLE ANGLE IAW SRM 51-42-21.SDR ASOA201000268Isolator · brokenFS 621 ISOLATOR AT RBL9 IS BROKEN. REMOVED AND INSTALLED NEW ISOLATOR ON FS 621 RBL 9 IAW SRM 51-42-13.SDR ASOA201000256Post · crackedFS 409+128 BL 0.00 VERT POST FAILS NDT WITH AN INDICATION IN AFT RT "C" CHANNEL. (GREATER THAN 50 PERCENT SCREEN HEIGHT). REMOVED POST IAW SRM 51-42-06. POST LOCATED & DRILLED INBD & OTBD POST HOLES IAW SRM 51-40-11. INSTALLED INBD & OTBD POST HOLES TOGETHERSDR ASOA201000255Post · crackedFS 409+128 RBL 18.0 VENT POST FAILS NDT WITN AN INDICATION IN AFT LT "C" CHANNEL. (GREATER THAN 50 PERCENT SCREEN HEIGHT). REMOVED VERT POST IAW SRM 51-42-06. LOCATED & DRILLED IAW SRM 51-40-11 & ASSEMBLED 2 HALVES IAW SRM 51-42-06. INSTALLED VERTICAL POSTSDR ASOA201000254Isolator · crackedFOUND REAR PRESSURE BULKHEAD ISOLATOR IS CRACKED LBL9.0, APPROX WL 90. REMOVED AND REPLACED CRACKED ISOLATOR IAW SRM 51-42-10 FIG 4 AND 51-42-13 STEP 8.SDR ASOA201000253Bulkhead · crackedFOUND REAR PRESSURE BULKHEAD WEB THAT SURROUNDS THE LINTEL ATTACHMENT FITTING HAS INDICATION NOTED APPROX .2" IN LENGTH 90 PERCENT FSH FAILED NDT INSPECTION. REPAIR IAW EC/TC REO 601R-53-61-1230 HAS BEEN COMPLETE & THE REPAIR C/W THE REQUIREMENTS OF EC/TC & SDR ASOA201000252Bulkhead · crackedFOUND FS 559 BULKHEAD WEB RT SIDE HAS INDICATIONS NOTED OTBD OF RBL 9.0 WL 58.70 APPROX .2" IN LENGTH 55 FS AND INBD OF RBL 18.0 WL54.0 APPROX .3" IN LENGTH 60 PERCENT FSH FAILED NDT INSPECTION. REPAIRED FS 559 BULKHEAD AND CAP ANGLES FROM LBL 27 TO RBL 27 IASDR ASOA201000251Angle · corrodedFWD "J" ANGLE AT FS 280 BETWEEN LBL 9 AND RBL 9 IS CORRODED. REMOVED FWD "J" ANGLE IAW SRM 51-42-06. LOCATED AND INSTALLED FWD "J" ANGLE IAW SRM 51-42-06.SDR ASOA201000250Sill · corrodedFLOOR SUPPORT SILL ON RT SIDE APPROX RBL 49 FROM FS 574 TO 621 HAS CORROSION AROUND NUTPLATE LOCATION. REMOVED NUTPLATES (10) FROM FLOOR SUPPORT IAW CRJ SRM 51-42-10 FIGURE 4. BLENDED AREA REMOVING CORROSION IAW CRJ SRM 51-21-06 STEP 6A. PRIMED AND PAINTED SDR ASOA201000249Cargo Track · corrodedCARGO SEAT TRACK SEGMENT AT RBL 27 FOR LAV ATTACHMENT IS CORRODED. REMOVED & REPLACED SEAT TRACK SEGMENT FOR LAV ATTACHMENT IAW AMM 53-01-11-000-802 AND SRM 51-40-11.SDR ASOA201000248Seat Track · corrodedCARGO SEAT TRACK SEGMENTS FROM FS 559+80 TO FS 621 ARE CORRODED, QTY 2 SEGMENTS, RBL 9. REMOVED & REPLACED SEAT TRACK SEGMENTS IAW AMM 53-01-11-000-802 AND SRM 51-40-11.SDR ASOA201000247Seat Track · corrodedSEAT TRACK SEGMENTS FROM FS 559+80 TO FS 621 AT LBL 9 (QTY 3) ARE CORRODED. REMOVED AND REPLACED SEAT TRACK SEGMENTS IAW AMM 53-01-11-000-802 AND SRM 51-40-11.SDR ASOA201000246Floorbeam · crackedRT FS621 FLOOR SUPPORT ANGLE PREVIOUS REPAIR IS CRACKED. REPAIR OF THE DAMAGED PORTIONS OF ANGLE 601R35031-239 IS COMPLETED IAW REO 601R-53-61-117 & MEETS WITH ALL ITS REQUIREMENTS.SDR ASOA201000245Floor Support · crackedLT FS621 FLOOR SUPPORT ANGLE PREVIOUS REPAIR IS CRACKED. REPAIR OF THE DAMAGED PORTIONS OF ANGLE 601R35031-239 IS COMPLETED IAW REO 601R-53-61-117 & MEETS ALL ITS REQUIREMENTS.SDR ASOA201000218Plate · corrodedCORROSION ON FS 310 AT SERVICE DOOR ON SPLICE PLATE. REMOVED SILL PLATE JUST FWD OF SERVICE DOOR CUTOUT IAW SRM 51-42-06, TO ACCESS SPLICE PLATE. LOCATED & DRILLED NEW SPLICE PLATE IAW SRM 51-40-11 & INSTALLED IAW SRM 51-42-21. SILL PLATE REQUIRES INSTALLEDSDR ASOA201000217Floorbeam · crackedFLOORBEAM AT FS 280 & LBL9 HAS A 2" CRACK.SDR ASOA201000216Placard · wornFLT DECK EMERGENCY EXIT (831) EXTERIOR MARKINGS ARE WORN.SDR ASOA201000215Intercostal · crackedFS 484 INTERCOSTAL RBL27 AND RBL36 CLIPS ARE CRACKED. REPAIR TO THE INTERCOSTALS AT FS 484 BETWEEN BL 27.00 AND BL 36.00 IS COMPLETED IAW REO 601R-53-41-059 AND MEETS WITH ALL THEIR REQUIREMENTS.SDR ASOA201000214Intercostal · crackedFS 484 INTERCOSTAL, LBL 27 CLIP IS CRACKED. REPAIR TO THE INTERCOSTALS AT FS 484 BETWEEN BL 27.00 AND BL 36.00 IS COMPLETED IAW REO 601R-53-41-059 AND MEETS WITH ALL THEIR REQUIREMENTS.SDR ASOA201000267Drag Angle · crackedJOB 8767911, OPS 183, PAX DOOR AFT DRAG ANGLE CRACKED. REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO'S 601R-52-11-513 AND 601R-52-11-751 & ASA ECTC REO 601R-52-11-513.SDR ASOA201000211Placard · deterioratedCREW ESCAPE HATCH (831) EMERGENCY PLACARD IS DETERIORATED. APPLIED NEW SILKSCREENS ON HATCH (831) IAW MM 11-10-03-400-801.SDR ASOA201000210Angle · crackedRT 621 TO 625 OBLIQUE ANGLE IS CRACKED. REMOVED FS 625 OBLIQUE ANGLE AND REPLACED W/A SERVICEABLE ONE ON RBL 27 IAW SRM 51-42-06 ST 1, 9 AND 11.SDR ASOA201000362Sign · brokenJOB 8767911 OPERATION 46 / LT WINDSCREEN EXIT SIGN ASSY IS BROKEN. REMOVED LT WINDSCREEN EXIT SIGN ASSY IAW AMM 33-51-13-000-801. INSTALLED NEW SERVICEABLE SIGN IAW 33-51-13-400-801. OPS TEST REQUIRED. COMPLIED WITH OPS CHECK ON THE LT WINDSCREEN IAW AMM 33-5SDR ASOA200900207Warning System · activatedTHE "FLAPS FAIL" MSG IN CRUISE FLIGHT DESCENDING THROUGH 19,000FT AT 290 KIAS WITH LIGHT TO MODERATE TURBULENCE.SDR ASOA200900197Flap System · malfunctionedEN ROUTE TO ATL RECEIVED "FLAPS FAIL" CAUTION MESSAGE WITH FLAPS INDICATING 0 ON FLT/CTL SYNOPTIC PAGE. EMERGENCY DECLARED.SDR ASOA200801667Flap · failedFLAP FAIL AT 0 DEGREES AT 200 KIAS. EMERGENCY DECLARED.SDR ASOA200801652Flap System · failedFLAP FAIL AT 0 DEGREES WHEN LANDING IN GRR, RAN QRH, DECLARED AN EMERGENCY AND A 0 FLAP LANDING UNEVENTFUL. EMERGENCY DECLARED. FLT 5599. FOUND MOISTURE IN TORQUE TUBE. DRIED, LUBED, OP CHECKED IAW AMM 27-54-01.SDR ASOA200801584Flap · failedFLAPS FAIL MSG ON EICAS AT 200 KAS FLAPS INDICATING 0. EN ROUTE TO CID A/C DIVERTED TO MLI DUE TO MTC, EMERGENCY DECLARED.SDR ASOA200801531Flap System · failedFLT 5575 - FLAPS FAIL MESSAGE ON DESCENT, WHEN SELECTING 8 DEGREES. FAILED AT ZERO. EMERGENCY VEHICLES ROLLED AS A PRECAUTION.SDR TRAX200800677Bpsu · malfunctionedFLAPS FAIL AT ZERO WHEN SELECTING 8 DEGREES. FLT 4349 CX EMERGENCY DECLARED. REMOVED AND REPLACED BPSU LT SIDE IAW CRJ200 AMM 27-50-01. OPS CHECK GOOD NO DEFECTS NOTED AT THIS TIME. [SDR CLOSED](B)SDR TRAX200800618Transducer · malfunctionedOIL PRESSURE INDICATING 156 PSI IN ALL PHASES FROM CLIMB TO SHUTDOWN AT GATE. AIRCRAFT RETURNED TO ATL AFTER T/O---EMERGENCY DECLARED. FLT 4531 DEL 156 MINS REMOVED AND REPLACED RT ENG OIL PRESSURE TRANSDUCER IAW AMM 79-31-03, LEAK AND OPS CHECK GOOD. (B)SDR TRAX200800244Placard · wornAAR - PAX DOOR STEP "EXIT" PLACARD WORN.
SDR TRAX200800234Structure · crackedAAR - CRACK ON PAX DOOR LOWER FWD CORNER UNDER HINGE STEP.
SDR TRAX200800228Attach Angle · crackedFS 280.00 RBL 9.00 INBD ATTACH ANGLE CRACKED.SDR TRAX200800227Handle · crackedAAR - 8010 - PAX DOOR OUTER HANDLE IS CRACKED.
Back to N680BR, cancelled Mar 10, 2022