N681BR, cancelled Nov 2, 2022
Service difficulty reports · 72
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 = 'N681BR' AND deregistration_id = 'N681BR-2022-11-02' 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 = 'N681BR' AND deregistration_id = 'N681BR-2022-11-02' 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 ASOA2013082808912Lamp · burned outCABIN AFT MOST CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP IAW AMM 33-51-16, OPS CHECKED GOOD.SDR ASOA2013072908792Light · inoperativeTWO LT WING AFT EMERGENCY LIGHT INOPERATIVE.SDR ASOA2013041603382Battery · dischargedF/A FLASHLIGHT INOPERATIVE. REPLACED F/A FLASHIGHT BATTERY IAW AMM 25-60-00. OPS CHECKED GOOD NO OTHER DEFECT NOTED AT THIS TIME.SDR ASOA2012092502284Light · misinstalledEMERGENCY LIGHT AT SEAT 8CD IN WRONG POSITION, SHOULD HAVE SQUARES NOT ARROWS. RELOCATED RT TRACK IN THE RT CORRECT POSITION IAW 33-51-0101.SDR ASOA2012092502283Connector · disconnectedEMERGENCY LIGHT INOPERATIVE, WIRE PULLED OUT OF CONNECTOR. REPAIRED LIGHT IAW ECSPM 20-17-00. OPS CHECKED IAW AMM 33-51-00-710-801. NO DEFECTS NOTED.SDR ASOA2012092502282Sill · corrodedFOUND CORROSION ON SERVICE DOOR SILL. CORROSION ON SILL ANGLE WAS FOUND TO BE OUT OF ALLOWABLE LIMITS OF SRM TR 53-27. LOCATED AND DRILLED FASTENER HOLES IN SERVICEABLE SERVICE DOOR SILL ANGLE IAW SRM 51-40-11. REMOVED SERVICE DOOR SILL ANGLE IAW SRM 51-42SDR ASOA2012092502281Angle · crackedANGLE CRACKED AT RBL 36, FS 484. REPAIRED IAW REO 601R-53-41-059.SDR ASOA2012092502280Angle · crackedANGLE CRACKED AT FS 484.00 AT LBL 27. R & R CRACKED ANGLE AT FS 484.00 NR LBL 27 IAW SRM 51-42-21.SDR ASOA2012092502279Post · crackedFOUND FS 409.00+128 VERTICAL POST LBL 18 OTBD SIDE HAS INDICATION NOTED AT AFT FLANGE RADIUS WL 69.0 APPROX .3" IN LENGTH 50 PERCENT FSH. FAILED NDT INSPECTION. REMOVED VERTICAL POST ASSY COMMON TO FS 409.00+128, LBL 18 IAW SRM 51-42-06. INSTALLED NEW SERVICSDR ASOA2012092502278Post · crackedFOUND FS 409.00+128 VERTICAL POST RBL 18 INBD SIDE HAS INDICATION NOTED AT AFT FLANGE RADIUS WL 69.0 APPROX .3" IN LENGTH 50 PERCENT FSH. FAILED NDT INSPECTION. REMOVED VERTICAL POST IAW SRM 51-42-06-00. INSTALLED NEW SERVICEABLE NEW POST IAW REO 601R-53-41SDR ASOA2012092502277Intercostal · corrodedANGLE CRACKED AT RBL 27, FS 484.00 AND AT LBL 36, FS 484.00. REPAIRED INTERCOSTALS COMPLETED IAW REO 601R-53-41-059.SDR ASOA201201615Cover · missingEMERGENCY EXIT SIGN COVER AT SERVICE DOOR IS MISSING. REPLACED COVER IAW AMM 33-51-13.SDR ASOA201201476Door · bindingCABIN PASSENGER DOOR DIFICCULT TO OPEN. COMPLIED WITH SERVICING OF PASSENGER DOOR IAW AMM 52-11-00 COULD NOT DUPLICATE FAULT AT THIS TIME.SDR ASOA201201317Placard · deterioratedPAX DOOR EXIT PLACARD DETERIORATED. R & R PAX DOOR EXIT PLACARD IAW AMM 11-30-00.SDR ASOA201200974Bulkhead · crackedCRACK INDICATION NOTED AT FS 621 REAR PRESSURE BULKHEAD WEB FWD FACE AT LBL 27.50 WL 129 AT THE TOP OF THE CARGO DOOR AFT TRACK APPROX .10 IN LENGTH 50 PERCENT FULL SCREEN HEIGHT. FAILED NDT.SDR ASOA201200972Bulkhead · crackedCRACK INDICATION NOTED AT FS 621 REAR PREASSURE BULKHEAD WEB FWD FACE AT LBL 27.50 WL 129 AT THE TOP OF THE CARGO DORO AFT TRACK APPROX .10" LENGTH 50 PERCENT FULL SCREEN HEIGHT. FAILED NDT.SDR ASOA201200970Bulkhead · crackedCRACK INDICATIONS NOTED AT THE FS 559 BULKHEAD AT RBL 9, WL 54.10 APPROX .200" L, 55 PERCENT FSH AND RBL 18 WL 59.10 APPROX .200" L 50 PERCENT FULL SCREEN HEIGHT. FAILED NDT. REPAIRED IAW REO 601R-53-41-260 & REO 601R-53-41-260 REV E.SDR ASOA201200521Lamp · burned outAFT MOST CABIN CEILING EMERGENCY LIGHT INOPERATIVE. RELAMPED AFT MOST CABIN CEILING EMERGENCY LIGHT IAW AMM 33-51-16.SDR ASOA201200054Selector Valve · leakingHYDRAUICS 3 LOW PRESSURE ILLUMINATED ON FINAL, COMPLIED WITH QRH & AN EMERGENCY DECLARED. R & R NLG DOOR SELECTOR VALVE IAW AMM 32-22-20 AND IPC 32-22-20 ITEM 5B.SDR ASOA201102172Light · damagedFOUND BASE OF EMERGENCY LIGHT ASSY FLOOR LEVEL AT FWD ENTRY DAMAGED. R & R EMERGENCY EXIT ASSY FLOOR LEVEL AT FWD ENTRY FLOOD LIGHT IAW AMM 33-51-10.SDR ASOA201101608Door · bindingMAIN CABIN DOOR WILL NOT OPEN FROM INSIDE CABIN. OPS CHECKED DOOR. NO DEFECT FOUND. OK FOR SERVICE IAW AMM 52-10-00.SDR ASOA201101597Door · bindingMAIN CABIN DOOR IS DIFFICULT TO OPEN AFTER PARKING. PERFORMED OPS TEST OF PAX DOOR IAW AMM 52-11-00, DOOR OPERATED NORMALLY.SDR ASOA201101514Handle · bindingMAIN CABIN DOOR HANDLE STICKS WHEN TRYING TO CLOSE OR OPEN DOOR HARD TO CLOSE AND HARD TO OPEN DOOR. OPS CHECK GOOD IAW CRJ-200-AMM 52-11-00. (CLOSED)SDR ASOA201101392Door · bindingF/A REPORTS MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. HANDLE IS STICKEY AND DIFFICULT TO OPERATE. COMPLIED WITH INSP AND OPS CHECK OF PAX DOOR NO DEFECTS NOTED DOOR OPERATE NORMAL INOPEN/CLOSED IAW AMM52-11-00.SDR ASOA201101367Door · bindingF/A REPORT MAIN CABIN DOOR AS DIFFICULT TO CLOSE HANDLE DOWN. ALSO HARD TO OPEN. LUBRICATED LOCK PINS & GUIDES. OPENED & CLOSED DOOR SEVERAL TIMES. OPS CHECKED GOOD IAW AMM 52-11-00.SDR ASOA201101290Latch · bindingCABIN ENTRY DOOR DIFFICULT TO OPEN. LATCH MECHINISM APPEARS OUT OF ADJUSTMENT. OPS CHECK PAX DOOR. (CLOSED)SDR ASOA201101216Door · lack of lubePAX DOOR HARD TO OPEN. LUBED PAX DOOR IAW AMM 12-20-52. OPS CHECKED GOOD IAW AMM 52-11-00.SDR ASOA201101186Pushrod · out of adjustPASSENGER DOOR IS DIFFICULT TO OPEN OR CLOSE. ADJUSTED THE PUSH ROD ASSY BETWEEN THE UPPER PIVOT LEVER AND THE PIVOT LEVER ON THE TORQUE TUBE ASSEMBLY TO ALIGN THE RIGGING MARKS. OPS AND FUNCTIONAL CHECKS GOOD IAW AMM 52-11-25.SDR ASOA201101093Door · bindingF/A CANNOT OPEN PASSENGER DOOR. CLEANED AND LUBED AIRSTAIR DOOR LINKAGE. OPS CKD GOOD IAW AMM 52-11-00.SDR ASOA201100532Cam · lack of lubeF/A REPORTS PASSENGER DOOR HANDLE LOCK. UNLOCK BINDING. LUB CAMS ON TOP OF DOOR (CLOSED) IAW AMM 52-11-25. OPS CHECK GOOD, ACFT OK FOR SERVICE. (CLOSED)SDR ASOA201100522Lock · lack of lubeF/A REPORTS PASSENGER DOOR HANDLE LOCK/UNLOCK BINDING. ACCOMPLISHED LUBE OF PAX DOOR LOCKING MECHANISM, OPS CHECK GOOD AMM 52-11-43. (CLOSED)SDR ASOA201000984Bulb · inoperativeRT OVERWING EMERGENCY LIGHT INOP. R & R EMERGENCY LIGHT BULB IAW AMM 33-51-21 OP CK GOOD. ITEM: 1, R & R EMERGENCY LIGHT BULB IAW AMM 33-51-21. OPS CK GOOD.SDR ASOA201000493Priority Valve · failedAFTER TAKEOFF, RECEIVED A GEAR DISAGREE MSG ALONG WITH VIOLENT SHAKING IN COCKPIT THAT FELT LIKE WAKE TURBULENCE. COMPLIED W/ QRH, DECLARED AN EMERGENCY AND LANDED W/O INCIDENT.SDR ASOA201000415Bulkhead · corrodedFS 621.00, PRESSURE BULKHEAD WEB FWD FACE HAS A 90 PERCENT FSH HFEC INDICATION NOTED APPROX 0.2" LONG AT THE BOTTOM INBD CORNER OF THE LINTEL FITTING. FAILS NDT AT THIS TIME. REPAIR PER EC/TC REO 601R-53-61-1230 HAS BEEN COMPLETE AND THE REPAIR C/W THE REQUSDR ASOA201000416Intercostal · crackedUPON DISASSEMBLY OF PREVIOUSLY REWORKED EXTERNAL POWER RECEPTACLE SUPPORT MEMBER, FOUND AFT INTERCOSTAL PN 600-33283-35 TO BE CRACKED INBD TOP FASTENER HOLE. DRILLED OFF, REMOVED OLD EXTERNAL POWER RECEPTACLE SUPPORT MEMBER AFT INTERCOSTAL PART NR 600-33283-SDR ASOA201000414Bulkhead · crackedBS 202.75 PRESSURE BULKHEAD CRACKED AT BRAKE CABLE FEED THROUGH HOLE. C/W EC/TC REO 601R-53-11-563 AND REO 601R-53-11-563 REV.SDR ASOA201000404Floor Support · corrodedFLOORBEAM CAP AT LBL 27 FROM FS 621 TO FS 574 IS CORRODED. FLOORBEAM CAP AT LBL 27, STA 574-621. REMOVED FOR REPLACEMENT. REMOVED CAP LBL 27, FS 574 - FS 621 IAW SRM 51-42-06 STEP 11. LOCATED AND DRILLED FLOORBEAM AND LBL 27 FS 569-621. INSTALLED FLOORBEAM SDR ASOA201000403Floor Support · crackedFLOOR SUPPORT STRUCTURE FS 621.0 LT SIDE IS CRACKED. REPAIR OF THE DAMAGE PORTIONS OF ANGLE 601R35031-239 IS COMPLETED IAW REO 601R-53-61-117 AND MEETS WITH ALL ITS REQUIREMENTS.SDR ASOA201000402Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. COMPLIED WITH EC/TC REO 601R-52-11-1788, REO 601R-52-11-1788.SDR ASOA201000400AController · uncontrollableR & R NR 2 CABIN PRESS CONTROLLER IAW AMM 21-31-16. (CLOSED)SDR ASOA201000409Wire · brokenFLOOR LEVEL FLOOD LIGHT (EMERGENCY LIGHT) ON WARDROBE HAS BROKEN WIRE AT CONNECTOR. INSTALLED NEW SERVICEABLE CONNECTOR ON EMERGENCY FLOOR LEVER FLOODLIGHT ON WARDROBE IAW ESPM 20-17-10. OPS TEST OF EMERGENCY LIGHTS DUE. OPS TEST OF THE EMERGENCY EXIT LIGHTSDR ASOA201000401Angle · crackedAFT EQUIPMENT BAY 621-625 OBLIQUE ANGLE CRACKED ON RT SIDE. R & R RT SIDE FS 621-625 OBLIQUE ANGLE IAW SRM 51-42-06.SDR ASOA201000400Angle · crackedAFT EQUIPMENT BAY, FS 621-625 OBLIQUE ANGLE CRACKED ON LT SIDE.SDR ASOA201000399Placard · deterioratedCREW ESCAPE HATCH EXTEROR SILK SCREENS DETERIORATED/ MISSING. REMOVED DAMAGED SILKSCREENS ON CREW ESCAPE HATCH IAW AMM TASK 11-10-03-000-801 AND APPLIED NEW SILKSCREENS FOR DAMAGED/MISSING ONES IAW AMM TASK 11-10-03-400-801.SDR ASOA200901367Light · inoperative2 RT FUSELAGE EMERGENCY LIGHTS INOP.SDR ASOA200900636Door · stuckPAX DOOR WILL NOT OPEN / (PASSENGER DOOR POWER ASSIST SYSTEM).SDR ASOA200900615Door · bindingMAIN ENTRANCE DOOR HARD TO OPEN AND GET GREEN INDICATION WHEN CLOSED. FLT 5356 DEL 96 MINS.SDR ASOA200900601Door · inoperativePASSENGER DOOR WILL NOT LATCH CLOSED. FLT 4980 DEL 112 MINS.SDR ASOA200900500Anchor Fitting · crackedPAX DOOR AFT ANCHOR FITTING CRACKED.SDR ASOA200801569Battery · unknownCAPTAINS FLASHLIGHT NEEDS BATTERIES.
Back to N681BR, cancelled Nov 2, 2022