N625CA
Service difficulty reports · 160
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 = 'N625CA' AND registry_match = 'registration' 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 = 'N625CA' AND registry_match = 'registration' 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 SWIA201743551Stringer Splice · corrodedAVIONIC BAY STRINGER SPLICE 25L HAS SIGNS OF CORROSION BETWEEN BS 319 AND 333. REMOVED AND REPLACED WITH NEW STRINGER SPLICE IAW SRM.SDR SWIA201743554Hinge · nickedPAX DOOR PIANO HINGE (DOOR SIDE) WITH DOOR IN OPEN POSITION, FOUND "LUGS" 1,8,10,15,21,27 HAVE "ROUND" STONE NICKS. REMOVED AND REPLACED PAX DOOR PIANO HINGE (DOOR SIDE), IAW SRM.SDR SWIA201743553Access Panel · chafedRIGHT WING ACCESS PANEL 622DB HAS CHAFING ALONG LEADING EDGE. INSTALLED A NEW ACCESS PANEL IAW SRM.SDR SWIA201541174Stringer · corrodedCORROSION FOUND ON STR 27 AT FS 311.5 BL 0. COMPLIED WITH PERMANENT REPAIR TO STR 27 AT FS 311.50, BL 0, REF EA. PRESSURIZATION CHECKED GOOD. COMPLIED WITH ST 51-900-1002.SDR SWIA201541168Frame · chafedFRAME UNDER AFT CARGO BAY DOOR PULL HAS CHAFING DAMAGE FROM CABLE. REPAIRED AFT BAGGAGE BAY DOOR PULL FRAME IAW EA. COMPLIED WITH ST 51-900-1002.SDR SWIA201541159Stringer · unknownSTRINGER 25R SPLICE AT BS 333 REQUIRES REPLACEMENT. REPLACED STRINGER 25R SPLICE AT FS 333.00 REF AMM AND STS EA.SDR SWIA201541170Frame · damagedFRAME AT FS 319 BETWEEN STR 26L AND STR 26R REQUIRES REPAIR DUE TO DAMAGE BEING OUT OF LIMITS. COMPLIED WITH PERMANENT REPAIR IAW REO.SDR SWIA201541163Intercostal · corrodedINTERCOSTAL AT STR 26L AT BS 364 IS CORRODED. R & R INTERCOSTAL AT STR 26R AT FS 364.00, REF SRM. COMPLIED WITH ST 51-900-1002.SDR SWIA201541162Stringer · corrodedSTRINGER 25R BETWEEN BS 295 AND 333 REQUIRES REPAIR DUE TO CORROSION DAMAGE BEING OUT OF LIMITS. R & R STR 25R FROM FS 280.00 TO FS 333.00, REF SRM PRESSURIZATION CHECKED GOOD AT THIS TIME. COMPLIED WITH ST 51-900-1002 .SDR SWIA201541161Stringer · unknownSTRINGER 26L BETWEEN FS 333 AND 349 REQUIRES REPAIR DUE TO DAMAGE BEING OUT OF LIMITS. CAMP NR 12104643, JOB 71011341, OP 149 FOR DETAILS. REPLACED STRINGER 26L BETWEEN FS 333 TO FS 364, REF: DWG AND SRM, COMPLETED M337. COMPLIED WITH ST PRESSURIZATION CHESDR SWIA201541171Frame · damagedFRAME AT BS 295 BETWEEN STR 26L AND STR 26R REQUIRES REPAIR DUE TO DAMAGE BEING OUT OF LIMITS. COMPLIED WITH PERMANENT REPAIR IAW REO.SDR SWIA201541169Frame · damagedFRAME AT BS 310 BETWEEN STR 26L AND STR 26R REQUIRES REPAIR DUE TO DAMAGE BEING OUT OF LIMITS. COMPLIED WITH PERMANENT REPAIR IAW REO.SDR SWIA201541167Intercostal · corrodedINTERCOSTAL AT LBL 1.5 FROM FS349 TO FS364 CORRODED. REMOVED CORRODED AND INSTALLED SERVICABLE INTERCOSTAL AT LBL 1.5 FROM FS349 TO FS364 REF SRM, COMPLETED SWA FORM M-337.SDR SWIA201541166Intercostal · corrodedINTERCOSTAL AT RBL 1.5 FROM FS349 TO FS364 CORRODED. REMOVED CORRODED AND INSTALLED SERVICABLE INTERCOSTAL AT RBL 1.5 FROM FS349 TO FS364 REF SRM.SDR SWIA201541165Stringer · corrodedSTR 26L CORRODED BETWEEN FS333 AND FS349. BLENDED OUT CORROSION FROM STRINGER REF SRM FOUND STR 26L TO HAVE SEVERE PITTING DURING BLEND OUT AND REMOVED APPROX 50 PERCENT OF MATERIAL THICKNESS, THERE IS NO ALLOWABLE DAMAGE IN THIS AREA. DAMAGE IS OUT OF LIMITSDR SWIA201541164Stringer · corrodedSTR 25R HAS SEVERAL SPOTS OF CORROSION BETWEEN FS295 AND FS333. REMOVED CORROSION FROM STRINGER REF SRM. FOUND STR 25R BETWEEN FS 295.00 AND FS 333.00 TO HAVE SEVERE PITTING THROUGH, DAMAGE IS OUT OF LIMITS DUE TO A NO DAMAGE AREA SRM.SDR SWIA201541160Frame · corrodedFRAME AT BS 333 CORRODED BETWEEN STR 26L AND STR 26R. REPAIRED FRAME AT FS333 BETWEEN STR 26L & STR 26R, REF: STS EA.SDR SWIA201541173Floorbeam · corrodedFS 280, CROSSBEAM IS CORRODED AND CRACKED AT LBL 11 ALSO CORRODED AT RBL 11. R & R FS 280 CROSSBEAM IAW REO.SDR SWIA201541172Skin · dentedLEFT HORIZONTAL STABILIZER L/E SKIN PANEL, DWG AV670-23190 REF, HAS A DENT FROM BIRDSTRIKE LOCATED BELOW CENTER-LINE OTBD OF RIB NR 5, PN AV670-23189-001, SN C6-263654. REPAIRED IAW REO PERMANENT REPAIR DUE IN 12000 FH. DUE BY TAT 34834.5. COMPLIED WITH PERMSDR SWIA201541176Skin · dentedRIGHT OTBD FLAP UPPER SKIN HAS 29 DENTS, SKIN PANEL. REPAIRED RT OTBD FLAP UPPER SKIN IAW EA.SDR SWIA201541175Skin · dentedLEFT OTBD FLAP HAS 19 DENTS, ON TOP SKIN. REPAIRED LT OTBD FLAP UPPER SKIN IAW EA.SDR SWIA201437301Sign · brokenEMERGENCY EXIT SIGN OVER SERVICE DOOR BROKEN. R & R EMERGENCY EXIT SIGN OVER SERVICE DOOR IAW AMM.SDR SWIA201335824Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 4540 RELAMPED.SDR SWIA201335538Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 4444 RELAMPED.SDR SWIA201334760Light · inoperativeAFT EMERGENCY LIGHT POD FAILED. FLT#4794 RELAMPED.SDR SWIA201334409Light · inoperativeEMERGENCY POD LIGHT IN THE CABIN BURNED OUT. FLT#4495 RELAMPED. PN 1317SDR SWIA201334110Axle · corrodedCORROSION FOUND ON LT MLG NR 1 AXLE THRUST FACE. C-CHECK PERFORMED REPAIR ON LT MLG NR 1 AXLE IAW REO.SDR SWIA201334109Axle · corrodedCORROSION FOUND ON LT MLG NR 2 AXLE THRUST FACE. C-CHECK PERFORMED REPAIR ON THE LT MLG NR 2 AXLE IAW REO.SDR SWIA201334108Axle · corrodedCORROSION FOUND ON RT MLG NR 3 AXLE THRUST FACE. C-CHECK PERFORMED REPAIR ON THE RT MLG NR 3 AXLE IAW REO.SDR SWIA201334107Axle · corrodedCORROSION FOUND ON RT MLG NR 4 AXLE THRUST FACE. C-CHECK PERFORMED REPAIR ON THE RT MLG NR 4 AXLE IAW REO.SDR SWIA201334112Fairing · chafedFOUND TWO CHAFING MARKS UNDER BELLY FAIRING FS973.0 & STRINGER 27. C-CHECK BLENDED CHAFE MARKS UNDER BELLY FAIRING AT FS973.0 & STRINGER 27.0 IAW REO.SDR SWIA201334111Lever · chafedFWD PAX DOOR PULL IN LEVER HAS CHAFE MARKS. C-CHECK BLENDED & RESTORED FINISH TO FWD PAX DOOR PULL IN LEVER IAW REO.SDR SWIA201334113Aileron · chafedLT AILERON, UPPER LE IS CHAFED IN SEVERAL PLACES. C-CHECK BLENDED OUT CHAFES IN LT AILERON LE IAW REO.SDR SWIA201334114Crossbeam · crackedFS280 CROSSBEAM IS CORRODED & CRACKED AT LBL 11 ALSO CORRODED AT RBL 11. C-CHECK R&R FS280 CROSSBEAM IAW REO.SDR SWIA201333243Fairing · looseFLT 4442. WHEN SELECTING FLAPS 20 DEGREES, AIRFRAME SHOOK AND BUFFETED. ONLY OCCURS ABOVE 195 KTS. SLOWING OR SELECTING FLAPS 30 DEGREES, WILL END THE BUFFETING. SECURED SCREWS ON FWD WING TO FUSELAGE FAIRING AND RESEALED. INSPECTED FLAPS, FLAPS HINGES ASDR SWIA201333113Cowling · dentedA SLIGHT JERK WAS FELT AND SOUNDED LIKE A BIRD STRIKE. N1 ON THE RIGHT SIDE OF THE ENGINE WAS INDICATING 1.3 WHILE THE LEFT WAS AT 0.3 AND A NOTICEABLE AUDIO REVERBERATION. POST FLIGHT GROUND INSPECTION REVEALED A DENT ON THE RT ENGINE COWL. (FLT 4844) REPSDR SWIA201333002Light · burnedFIRST CLASS CLOSET LIGHT FIXTURE IS BURNT WITH BROKEN WIRES. (SERVICE) REMOVED AND REPLACED WARDROBE LIGHTING FIXTURE IAW AMM. P/N: CDEL1006-505SDR SWIA201231980Spring · out of adjustPASSENGER DOOR HARD TO OPEN. (SERVICE) ADJUSTED PASSENGER DOOR GAS SPRINGS IN REFERENCE TO AMM.SDR COMA2011091470044Skin · dentedDENT ON LOWER SIDE OF LEFT INBOARD FLAP APPROX WS 38. CUT OUT DAMAGE ON LOWER SKIN OF LEFT INBOARD FLAP, FABRICATED FILLERS AND DOUBLER, AND INSTALLED PARTS PER REO670-57-52-009.SDR COMA2011090970043Crossbeam · damagedINTERGRANULAR CORROSION FOUND IN SEVERAL AREAS ON THE 280.00 CROSSBEAM FROM LBL 36 TO RBL 36, CRACK ALSO FOUND JUST O/B OF RBL 9. REMOVED DAMAGE 280.00 BEAM AND INSTALLED SERVICEABLE 280.00 CROSSBEAM IAW CRJ SRM 51-42-06.SDR COMA2010032970005Hinge Pin · shearedON T/O FROM ATL NOSE LANDING GEAR DID NOT RETRACT. GEAR WAS LOWERED PER QRH, LOUD NOISE WHEN GEAR LOCKED DOWN. EMERGENCY DECLARED, A/C RETURNED TO ATL LANDED SAFELY. FOUND AFT NLG DOOR RT HINGE PIN SHEARED. REMOVED AND REPLACED HINGE PIN.SDR COMA2009061570020Floorbeam · crackedCRACKS FOUND IN VARIOUS AREAS FROM LBL 14 TO RBL 13 ON FS 280 BEAM. REMOVED AND REPLACED FS 280 CROSS BEAM IAW REO 670-53-11-047.SDR COMA0870020Isolation Valve · faultyFLIGHT 5307 - CABIN PSI ROSE RAPIDLY, AT 10000 FT CABIN PRESSURE ALTITUDE WAS 8800. NO MESSAGES RECEIVED. RETURNED TO ATL, LANDED WITHOUT INCIDENT. PERFORMED BITE CHECK OF ACSC, PASSED. REPLACED ISOLATION VALVE. GROUND PRESSURIZED A/C. NO FURTHER DEFECTSSDR COMA0870019Shutoff Valve · malfunctionedFLIGHT 5249 - LEFT AND RIGHT PRSOV'S AS WELL AS ISOLATED VALVE BEGAN CYCLING OPEN AND CLOSED. RAPID PRESSURIZATION LOSS OCCURRED. DECLARED EMERGENCY, FOLLOWED QRH, ISOLATION FAULT MESSAGE DISPLAYED. LANDED WITHOUT INCIDENT. OPS CHECKED PRSOV'S BOTH SIDES, SDR COMA0770075Control Unit · malfunctionedFLIGHT 4957 - DURING TAXI, RECEIVED FLAP FAIL MESSAGE. RETURNED TO GATE. RESET NR 1 AND NR 2 SFECU. GROUND CHECKS GOOD. NO FURTHER DEFECTS.SDR COMA0770037Shutoff Valve · leakingFLIGHT 5230 - RECEIVED RIGHT BLEED AIR DUCT WARNING. RIGHT AND LEFT PACK SHUT DOWN. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FOUND RIGHT HOT AIR SOV LEAKING FROM REGULATOR. REPLACED RIGHT SOV. NO FURTHER DEFECTS.SDR COMA0770033Clamp · looseFLIGHT 5448 - RECEIVED RIGHT BLEED WARNING INFLIGHT. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FOUND RIGHT INLET HEADER CLAMP LOOSE. SECURED CLAMP. GROUND RAN RIGHT ACM. NO LEAKS NOTED. INSPECTED CROSS BLEED DUCT SENSORS. REPOSITIONED LOOP TO ELIMINASDR COMA0670218Windshield · crackedFLIGHT 5465 - EN ROUTE ORD-JFK THE RIGHT WINDSHIELD CRACKED. REPLACED THE RIGHT WINDSHIELD.SDR COMA0670180Acm · smokeFLIGHT 5522 - DURING TAXI-OUT AT CVG SMOKE WAS DETECTED IN THE CABIN AREA, FLIGHT RETURNED TO THE GATE. DEFERRED THE RIGHT AIR CONDITIONING PACK PER MEL 21-51-01-1.SDR COMA0670158Overheat Loop · out of positionDURING CRUISE FLIGHT RECEIVED A DUCT WARNING, FLIGHT RETURNED TO DEPARTURE. REPOSITIONED HEAT SENSING ELEMENTS MT143 AND MT144.
Back to N625CA