N629BR, cancelled Feb 17, 2023
Service difficulty reports · 154
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 = 'N629BR' AND deregistration_id = 'N629BR-2023-02-17' 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 = 'N629BR' AND deregistration_id = 'N629BR-2023-02-17' 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 SWIA2019111846767Warning Message · illuminatedGEAR DISAGREE & NOSE DOOR OPEN RED WARNING MESSAGE AFTER CALL FOR GEAR UP. 3 SECONDS LATER, MESSAGE EXTINGUISHED WITH NO FURTHER INCIDENT. FLIGHT 4223 CLOSED DEFERRED LANDING GEAR RETRACTION SYSTEM. MX ACTION COMPLIED WITH AND PLACARDS INSTALLED. CAT 2 NOSDR SWIA2019010745410Warning System · false activationWHILE ON THE GROUND, APU FIRE AND ASSOCIATED FIREX BOTTLE DISCHARGED. APU FAULT MESSAGE INITIALLY BUT NOW EXTINGUISHED ON SUBSEQUENT POWER UP. APU BTL LO CAUTION MESSAGE WITH ASSOCIATED DISCHARGE. (FLT 4830) CLOSED INSPECTED AFT EQUIPMENT BAY AND ENCLOSURE FORSDR SWIA2018110645245Warning System · activatedA/SKID OTBD CAUTION MSG. EMERGENCY DECLARED. DIVERTED. (FLT 7439) CLOSED DEFERRED A/SKID OUTBOARD CHANNEL PER MEL.SDR SWIA2018082345007Shutoff Valve · failedAFTER TAKEOFF, SWAPPED BLEEDS FROM THE APU TO THE ENGINES AND THE NR 2 PACK SHUTOFF. THEN GOT A NR 1 PACK HIGH PRESSURE. LEVELED THE PLANE AT 10000, AND THE CABIN ALTITUDE BEGAN TO CLIMB. DECLARED THE EMERGENCY AND RAN THE QRH. A NORMAL LANDING WAS ACCOMPLISSDR SWIA2018062244805Connector · unsecureWOW INPUT CAUTION MESSAGE DURING FINAL, WITH GEAR DOWN, FLAPS 30. COMPLIED WITH QRH. ABORTED APPROACH. LANDED WITHOUT INCIDENT. SECURED THE SAFETY CONNECTOR PLUG ON THE LT MAIN LANDING GEAR S10 IAW AMM. PERFORMED AN EXTENSIVE OPS CHECK OF THE SYSTEM, WISDR SWIA2018051544663Floor Support · corrodedFLOOR SUPPORT, BS 559 TO 559+16 CORRODED. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM.SDR SWIA2018051544664Floor Panel · corrodedRIGHT SIDE PRESSURE FLOOR PANEL HAS CORROSION BS 499 TO 559. BLENDED IAW REO.SDR SWIA2018051544662Strap · corrodedBS 559 FLOORBEAM STRAP HAS CORROSION, BETWEEN RBL 27 AND RBL 42. REMOVED AND REPLACED THE STRAP IAW REO.SDR SWIA2018051544661Floor Support · corrodedFLOOR SUPPORT LEFT SIDE, BS 424 TO 409.128 CORRODED. REPAIRED IAW REO.SDR SWIA2018051544660Skin · corrodedEXTERIOR LOWER SKIN, BS 599+112, STRINGER 27 CORRODED RT AND LT SIDES. REPAIRED THE SKIN IAW REO.SDR SWIA2018051544675Floor Support · corrodedFLOOR SUPPORT CORRODED AT LBL 43, BS 559+96 - 563. REMOVED AND REPLACED THE FLOOR SUPPORT IAW REO.SDR SWIA2018051544674Frame · corrodedFRAME AT BS 605 WAS FOUND CORRODED BETWEEN STRINGERS 25L & 26R. REMOVED AND REPLACED THE FRAME IAW SRM.SDR SWIA2018051544659Door Sill · corrodedCARGO DOOR SILL CORRODED AT LBL 43, BETWEEN BS 563 & 620. REPLACED THE DOOR SILL IAW REO.SDR SWIA2018051544658Frame · corrodedFRAME AT BS 574 WAS FOUND CORRODED BETWEEN STRINGERS 26L & 26R. REPAIRED THE FRAME IAW REO.SDR SWIA2018051544673Floor Support · corrodedCARGO FLOOR SUPPORT CORRODED AT LBL 27, BS 569 - 619. REPLACED THE FLOOR SUPPORT IAW SRM AND REO.SDR SWIA2018051544672Bulkhead · gougedFWD SIDE OF THE AFT PRESSURE BULKHEAD WAS GOUGED. REPAIRED THE BS 621 BULKHEAD, RBL 27.5, RBL 18, LBL 18, AND LBL 27.5 IAW REO.SDR SWIA2018051544671Skin · corrodedAFT FUSELAGE, LOWER SKIN AROUND THE CARGO DOOR HAD CORROSION. REMOVED THE CORROSION TO A SMOOTH CONTOUR IAW SRM.SDR SWIA2018051544670Skin · dentedEXTERNAL LEFT, AFT LOWER FUSELAGE SKIN BETWEEN BS 682 AND 700 HAD TWO INWARD DENTS AND TWO PROTRUDING DENTS. REPAIRED THE SKIN IAW REO.SDR SWIA2018051544669Skin · dentedEXTERIOR RIGHT LOWER FUSELAGE SKIN BETWEEN BS 630 AND 700 HAD 11 PROTRUDING DENTS. REPAIRED THE SKIN IAW REOSDR SWIA2018051544668Skin · gougedPAX DOOR EXTERNAL SKIN WAS FOUND GOUGED ON THE FWD SIDE OF THE EXTERNAL HANDLE. REPAIRED THE DOOR SKIN IAW REO.SDR SWIA2018051544667Skin · dentedTWO DENTS ON THE RT LOWER FUSELAGE SKIN AFT OF BS 605 AND BETWEEN STRINGERS 24R - 25R AND FWD OF BS 621, BETWEEN STRINGERS 23R - 24R. REPAIRED IAW REO.SDR SWIA2018051544666Skin · dentedONE DENT WAS FOUND ON THE LT LOWER FUSELAGE SKIN BETWEEN BS 605 - 621, STRINGERS 22L - 23L. REPAIRED THE SKIN IAW REO.SDR SWIA2018051544665Skin · dentedA DENT WAS FOUND APPROXIMATELY 18 INCHES FORWARD OF BS 280 ON THE LOWER LEFT FUSELAGE SKIN. REPAIRED IAW REO.SDR SWIA201642185Frame · corrodedFRAME AT BS 319 CORRODED BETWEEN STRINGERS 26 AND 27L. COMPLIED WITH EA. PERFORMED PRESSURIZATION LEAK CHECK IAW AMM. CHECKED GOOD, NO LEAKS NOTED.SDR SWIA201642184Angle · corrodedANGLE CORRODED FWD SIDE OF FRAME AT FS 394 BETWEEN STR 25L AND 25R. COMPLIED WITH EA.SDR SWIA201642183Vane · chafedCHAFE DAMAGE FOUND ON LT INBD FLAP VANE, ON OTBD L/E SKIN. REPLACED NEW, IAW SRM.SDR SWIA201642182Door Sill · corrodedPASSENGER DOOR LOWER SILL, VERTICAL FACE AND CAP ANGLE HAS CORROSION. R & R PAX DOOR LOWER SILL VERTICAL ANGLE, PN: 601R31527-219 AND CAP ANGLE PN: 601R51527-205 IAW SRM.SDR SWIA201642181Access Panel · chafedPANEL 599BB IS CHAFED. REPLACED PANEL 599BB WITH FACTORY NEW PART IAW SRM.SDR SWIA201642180Access Panel · corrodedPAX DOOR PANEL 832ER HAS CORROSION. REPLACED PANEL 832ER IAW SRM.SDR SWIA201642179Access Panel · corrodedPAX DOOR PANEL 832EL HAS CORROSION. REPLACED PANEL 832EL IAW SRM.SDR SWIA201642178Access Panel · corrodedPAX DOOR PANEL 832BL HAS CORROSION. INSTALLED PANEL 832BL IAW SRM.SDR SWIA201642177Access Panel · corrodedPAX DOOR PANEL 832BR HAS CORROSION. PAX DOOR ACCESS PANEL 832BR REPLACED WITH A NEW PANEL, IAW SRM.SDR SWIA201541321Floorbeam · crackedFS 280 FLOORBEAM HAS LOWER FLANGE CRACKED LBL 12 - 13.5 AND OTBD, LBL 9. REPAIRED THE FLOORBEAM IAW EA.SDR SWIA201541327Floorboard · delaminatedFLOORBOARD 232BRF DELAMINATED. REPAIRED IAW EA.SDR SWIA201541326Plate · corrodedFOUND CORROSION ON RT FWD EMERGENCY EXIT DOOR LOWER SILL COVER PLATE ASSY, REPLACED COVER PLATE ASSY IAW SRM.SDR SWIA201541325Floorbeam · crackedFS 280 TO RBL 9, FLOORBEAM ANGLE WAS FOUND CRACKED. R & R THE ANGLE IAW SRM.SDR SWIA201541324Seat Track · corrodedSEAT TRACK AT RBL 9 FROM BS 364 - 400 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM.SDR SWIA201541323Seat Track · gougedSEAT TRACK LBL 9 FROM BS 364-400 GOUGED. REMOVED DAMAGED SEAT TRACK AND INSTALLED A NEW SEAT TRACK IAW AMM.SDR SWIA201541322Floorbeam · corrodedFS 280, FWD FLOORBEAM ANGLE IS CORRODED FROM RBL 9 TO LBL 9. R & R THE FLOORBEAM ANGLE IAW SRM.SDR SWIA201541320Door Sill · corrodedPASSENGER DOOR BOTTOM PLATE SILL CORRODED. REMOVED BLISTERED AND FLAKING PAINT FROM PASSENGER DOOR BOTTOM PLATE SILL IAW SRM, NO DAMAGE NOTED.SDR SWIA201439518Warning Light · false activationRETURNED TO DEPARTURE FOR PRESSURIZATION ISSUES AND SERVICE DOOR CAUTION. INSPECTED ALL DOOR SEALS-NO ISSUES. PERFORMED OPS CHECK OF THE PRESSURIZATION SYSTEM. NO FAULTS FOUND.SDR SWIA201439262Battery Pack · inoperativeEMERGENCY LIGHT OUT IN THE CABIN. CHANGED ALL FOUR BATTERY PACKS.SDR SWIA201439105Battery Pack · inoperativeF/O EMERGENCY FLASHLIGHT INOPERATIVE. R & R BATTERY PACK FOR THE F/O EMEGENCY FLASHLIGHT IAW AMM.SDR SWIA201438869Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT.SDR SWIA201438303Lamp · inoperativeRT SIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWIA2014061338165Battery Pack · inoperativeEXIT LIGHT ROW 8A IS INOPERATIVE. R & R NR 2 EMERGENCY LIGHTING BATTERY PACK IAW AMM, PN ON: 2013-1A, PN OFF: AD-2013-1A, SN ON: 112163, SN OFF: 69898. (2014NM060066)SDR SWIA201437765Light · inoperativeNR 7 EMERGENCY LIGHT ON THE EXTERIOR LT SIDE OF THE FUSELAGE INOPERATIVE. R & R NR 7 EMERGENCY LIGHT IAW AMM.SDR SWIA201437599Light · inoperativeLEFT WING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT IAW AMM.SDR SWIA201437460Panel · chafedPANEL 599BB CHAFED . C-CHECK, BLENDED CHAFE ON PANEL 599BB IAW REO.SDR SWIA201437482Skin · corrodedFUEL ACCESS PANEL ON LT LOWER WING PLANK UNDER PANEL 550GB HAS CORROSION. C-CHECK, REMOVED CORROSION UNDER PANEL 550GB ON WING PLANK IAW REO.
Back to N629BR, cancelled Feb 17, 2023