N676CA
Service difficulty reports · 269
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 = 'N676CA' 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 = 'N676CA' 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 ASOA2014111711675Seat Track · corrodedSEAT TRACK CORRODED BS 743 - 763. FOUND TO BE OUT OF LIMITS IAW GREO 670-53-00-013. REMOVED AND REPLACED THE SEAT TRACK IAW AMM TASK 53-00-49-000-801, SRM 51-40-11-001-001-A01 AND GREO 670-53-00-343, REV G.SDR ASOA2014111711674Seat Track · corrodedSEAT TRACK CORRODED BS 784 - 847. FOUND TO BE OUT OF LIMITS IAW GREO 670-53-00-013. R & R THE SEAL TRACK IAW AMM 53-00-49-000-801.SDR ASOA2014111711673Seat Track · corrodedSEAT TRACK CORRODED AT MULTIPLE AREAS FROM BS 672 - 722. FOUND TO BE OUT OF LIMITS IAW GREO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND 53-00-49-400-801 A07.SDR ASOA2014111711672Seat Track · corrodedSEAT TRACK CORRODED AT MULTIPLE AREAS FROM BS 926- 977. . FOUND TO BE OUT OF LIMITS IAW GREO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND 53-00-49-400801 A07.SDR ASOA2014111411671Seat Track · corrodedSEAT TRACK CORRODED BS 784 - 847, FOUND TO BE OUT OF LIMITS IAW GREO 670-53-00-013. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-000-801-A07, SRM 51-40-11-001-001-A01 AND GREO 670-53-00-343.SDR ASOA2014111411670Seat Track · corrodedSEAT TRACK CORRODED BS 743 - 763. FOUND TO BE OUT OF LIMITS IAW GREO 53-00-013. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-000-801-A07, SRM 51-40-11-001-001-A01 AND GREO 670-53-00-343, REV G.SDR ASOA2014111411669Seat Track · corrodedSEAT TRACK CORRODED BS 672 - 722. FOUND TO BE OUT OF LIMITS IAW GREO 670-53-00-013. REMOVED AND INSTALLED NEW SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND 53-00-49-400-801-A07.SDR ASOA2014111411668Floor Support · corrodedCORROSION FLOOR SUPPORT BS 1000 - 1047 LBL 45. REPAIRED IAW GREO 670-53-61-913 IAW REO 670-53-61-913.SDR ASOA2014111411667Floor Support · crackedFLOOR SUPPORT ANGLE CRACKED BETWEEN BS 260 - 280 LBL 9.0. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-44-06-001-001-A01, 51-42-06-001-001-A01, 51-40-11-001-001-A01 AND SRM 51-21-16-001-001-A01.SDR ASOA2014111411666Floor Support · crackedFLOOR SUPPORT ANGLE CRACKED BETWEEN BS 260 - 280 RBL 9. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-46-06-001-001-A01. AND REO 690-53-11-710, REV A.SDR ASOA2014111411665Bulkhead Web · corrodedRT FS 280.00 LOWER WEB CORRODED. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. CORROSION ON RT FS 280.00 LOWER WEB EXCEEDS THE ALLOWABLE LIMITS OF SRM 53-11-10-201-003-A01, FIG 53-11-10-991-804. COMPLIED WITH EC/TC REO 670-53-11-594 01 AND GREO SDR ASOA2014111411664Bulkhead Web · corrodedLEFT BS 280 LOWER WEB CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 11-10-201-003-A01, FIG 53-11-10-99 804. REPAIRED IAW REO 670-53-11-594 AND GREO 670-53-11-594, REV.SDR ASOA2014111411663Floorbeam · crackedCOCKPIT FLOORBEAM IS CRACKED. FABRICATED REPAIR ANGLES IAW REO 690-53-11-710, REPAIRED IAW REO 690-53-11-710.SDR ASOA2014111411662Angle · crackedBS 280 BULKHEAD ANGLE IS CRACKED ON RT SIDE BL 26.00. REMOVED AND OBTAINED NEW ANGLE LOCATED, DRILL HOLES AS REQUIRED, DEBUR HOLES IAW SRM 51-40-11-001-001-A01 51-42-06-001-001-A01 AND DWG CC670-34010. INSTALLED RT SIDE ANGLE AT BL26.00, FS280 BULKHEAD IAW SSDR ASOA2014111411661Hand Rail · chafedPAX DOOR AFT HAND RAIL CHAFED BY WHEEL STRUT. BLENDED SMOOTH IAW SRM 51-12-00-001-001-A01. COMPLIED WITH STS EA37-2014-050, SECTION 1, PERMANENT REPAIR STEPS 1A THROUGH 1D.SDR ASOA2014111411660Hinge · gougedPAX DOOR FUSELAGE HINGE AFT LUG LANDING GROOVED BY RETAINING PIN. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. BLENDED DAMAGE IAW SRM 53-21-23-101-001-A01, SRM CTJ900 51-12-00-001-001-A01, TEMP REV 51-0050. COMPLIED WITH GREO 670-53-21-582, REPSDR ASOA2014111411659Skin · chafedPAX DOOR FWD UPPER CORNER EXTERNAL SKIN CHAFED. BLENDED AREA IAW SRM 51-12-00-001-001-A01. PERFORMED THICKNESS INSPECTION OF OUTER SKIN IAW BSC NDT PROGRAM MANUAL SEC 4.3 MIN REMAINING THICKNESS IS .103", ORIGINAL IS .108", REMOVED IS .005" NO DAMAGE ALLOWEDSDR ASOA2014111411658Skin · chafedCHAFE ON FUSELAGE AT BS 935, BL 0 LONGITUDINAL CHAFE. BLENDED CHAFED AREA IAW SRM 51-12-00-001-001-A01. REPAIRED DAMAGED AREA IAW REO 670-53-00-290, REV C.SDR ASOA2014111411657Seat Track · corrodedSEAT TRACK AT RBL 9, BS 364 - 485 CORRODED. R & R SEAT TRACK IAW AMM 53-00-49-00-801-A01 AND 53-00-49-400-801-A04.SDR ASOA2014111411656Seat Track · corrodedSEAT TRACK AT LBL 9, BS 374 - 485 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-000-801 AND AMM 53-00-49-400-801.SDR ASOA2014111411655Seat Track · corrodedSEAT TRACK AT LBL 27, BS 364 - 485 CORRODED. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND 53-00-49-400-801-A07.SDR ASOA2014111411654Floor Support · corrodedRT SIDE FLOOR SUPPORT AT FS285 CORRODED. BLENDED CORROSION AND FOUND BEYOND LIMITS IAW SRM 53-00-00-101-001-A01. REPAIRED IAW SRM 53-21-43-201-002-A01. MAJOR REPAIR.SDR ASOA2014111411653Intercostal · corrodedINTERCOSTAL BS 349-364, STR 27R HAS CORROSION DAMAGE. CORROSION DAMAGE ON RT INTERCOSTAL FS 349.0 - 364.0 STR27 EXCEEDS THE ALLOWABLE DAMAGE LIMITS OF SRM 53-21-23-101-003-A01, FIG 53-21-23-99-808. R & R INTERCOSTAL REF SRM 51-42-06-001-001-A01, SRM 51-42-21SDR ASOA2014111411652Intercostal · corrodedINTERCOSTAL BS 349-364, STR 27L HAS CORROSION DAMAMGE. CORROSION DAMAGE ON LT INTERCOSTAL FS 349.0-FS 364.0, STR27 EXCEEDS THE ALLOWABLE DAMAGE LIMITS OF SRM 53-21-23-101-003-A01, FIG 53-21-23-991-808. R & R INTERCOSTAL REF SRM 51-42-06-001-001-A01, SRM 51-4SDR ASOA2014111411650Frame · corrodedCORROSION DAMAGE ON BS 333, FRAME AFT SIDE, STR 26L-26R. BLENDED CORROSION IAW SRM 51-12-00-001-001-A01. PERFORMED UT THICKNESS INSPECTION OF FS 333, FRAME IAW BSC NDT PROGRAM MANUAL SEC. 4.3. MIN, REMAINING THICKNESS IS .049", ORIGINAL IS .050", REMOVED IS SDR ASOA2014111411649Stringer · corrodedCORROSION ON STRINGER 25RT, FS 319.70-FS 338.0. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. BLENDED CORROSION FS 319.70-FS 333 REF SRM 51-21-06-001-001-A01. REMOVED SPLICE AT FS 333, STR 25R DUE TO PREVIOUSLY BLENDED OUT OF LIMITS REF SRM 51-4SDR ASOA2014111411648Frame · corrodedCORROSION DAMAGE ON FS 295.00 FRAME AFT SIDE, STR 26L-26R. BLENDED CORROSION IAW SRM 51-12-00-001-001-A01. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. AFTER FURTHER EVALUATION SEVERE CORROSION WAS FOUND WITH 100 PERCENT MATERIAL LOSS FRAME REPSDR ASOA2014111411647Strap · corrodedCORROSION DAMAGE ON FS 280 BUTT STRAP, STR 25LT-25RT. NO DAMAGE ALLOWED IAW SRM 53-21-01-101-002-A02. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REMOVED RIVETS AT FS 280 BUTT STAP FROM STR 26LT-25RT & BLENDED CORROSION AS REQUIRED REF SRM 51SDR ASOA2014111411646Angle · corrodedALL 4 ANGLE CLIPS ON THE PROTECTOR CORRODED AT SERVICE DOOR. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REMOVED 4 WEB FLOOR PROTECTORS IAW SRM 51-42-06-001-001-A01 UPON REMOVAL, FOUND CORRODED AND DETERMINED OUT OF LIMIT IAW SRM 53-21-23-101-0SDR ASOA2014111311644Striker · corrodedSERVICE DOOR LOWER SEAL STRIKER CORRODED AT FWD AND AFT SCREW HOLES. BLENDED DAMAGE IAW SRM 51-12-00-001-001-A01, SP 162207. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-00-101-001-A01. REMOVED STRIKER FROM LOWER SERVICE DOOR IAW SRM 51-42-06-001-001-A01. THIS SDR ASOA2014111311643Angle · corrodedSERVICE DOOR ANGLE MOUNT CORRODED. REMOVED MOUNTING ANGLE AND LOWER SILL ANGLE IAW SRM 51-42-06-001-001-A01. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. ASSEMBLED NEW MOUNTING ANGLE AND EXISTING LOWER SILL ANGLE IAW SRM 51-42-06-001-001-A01 ANSDR ASOA2014111311642Angle · corrodedPAX DOOR MID CAP ANGLE CORRODED. REMOVED CAP ANGLE IAW 51-41-02-001-001-A01. LOCATED & DRILLED NEW PART IAW SRM 51-42-06-001-001-A01, 51-42-15-001-001-A01, & 51-45-00-001-001-A01. INSTALLED MID CAP ANGLE IAW SRM TASK 51-41-02-001-001-A01.SDR ASOA2014111011630Angle · corrodedPAX DOOR ANGLE KICKPLATE CORRODED. REMOVED KICKPLATE ANGLE IAW SRM 51-42-06-001-001-A01. LOCATED DRILLED DEBURRED FASTENER HOLES IAW SRM 51-42-06-001-001-A01. INSTALLED NUTPLATES ON PAX DOOR ANGLE KICKPLATE IN REF TO SRM 51-45-00-001-001-A01. COMPLETED KISDR ASOA2014111311640Skin · gougedINNER FUSELAGE SKIN GOUGED BS 1144-1162, STR 6-7R. BLENDED DAMAGE IAW SRM TR 51-0050. AREA IS OUT OF ALLOWABLE LIMITS IAW SRM 53-61-01-101-001-A02. REPAIRED IAW EA 12-2014-268 P1. MAJOR REPAIR.SDR ASOA2014111011629Crossbeam · corrodedCROSSBEAM CORRODED. REPLACED THE CROSSBEAM IAW SB670BA-53-041.SDR ASOA2014111011628Stringer · crackedSTRINGER 7R CRACKED BETWEEN BS 1144 - 1162. PERFORMED EDDY CURRENT INSPECTION OF STR 7R CUTOUT IAW NDTM PT. 1, 51-20-006-250-A01 NO INDICATIONS NOTED AT THIS TIME. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. COMPLIED WITH GREO 670-53-61-292, RSDR ASOA2014111011627Handle · lack of lubeLT FWD EMERGENCY EXIT DOOR HANDLE DOES NOT OPERATE FREELY. LUBRICATED THE HANDLE IAW AMM 12-20-52-640-815, A01, HANDLE OPERATES FREELY.SDR ASOA2014111011626Handle · lack of lubeLEFT AFT EMERGENCY EXIT DOOR HANDLE DOES NOT OPERATE FREELY. VISUAL INSPECTED HARDWARE NO DEFECTS. LUBED LT AFT EMERGENCY EXIT DOOR OPEN HANDLE IAW AMM 12-20-52-640-816, A01. HANDLE OPERATIONS FREELY.SDR ASOA2014111711688Link · out of toleranceFOUND LT REAR SPAR LINK TILTED AND TOUCHING FUSELAGE FRAME AND WING FITTING. COMPLIED WITH SB 670BA-57-016 01, PART "B" REMOVED AND INSTALLED NEW SERVICEABLE LEFT SIDE REAR LINK ASSEMBLY IAW SB 670BA-57-016 01. THIS REPAIR IS CLASSIFED AS A MAJOR REPAIR IAW SDR ASOA2014070210795Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED AT MOTOR ASSIST CABLE PULLEY BRACKET. R & R DRAG ANGLE IAW SRM 52-11-04.SDR ASOA2014070110779Drag Angle · crackedDRAG ANGLE ON AFT SIDE OF PAX DOOR IS CRACKED THROUGH VERTICAL LEG. R & R PREVIOUS REPAIR SECTION OF PAX DOOR AFT DRAG ANGLE AT PULLEY ASSIST BRACKET IAW SRM 52-11-04.SDR ASOA2014012109780Light · inoperativeLEFT EXTERIOR EMERGENCY AFT MIDDLE LIGHT INOPERATIVE. R & R LT OVERWING EXIT LIGHT ASSY IAW AMM 33-51-15. OPS CHECKED GOOD, ACFT OK FOR RETURN TO SERVICE.SDR ASOA2013112109447Battery · inoperativeRT FWD EXT EMERGENCY LIGHT OUT AFT SERVICE DOOR. R & R EMERGENCY BATTERY POS NR 2 IAW 33-51-17 AND IPC 33-51-17, FIG 1, ITEM 6. OPS CHECKED GOOD.SDR ASOA2013102909269Bracket · crackedPAX DOOR AFT ANGLE BRACKET CRACKED MID WAY DOWN.SDR ASOA2013102909268Bracket · crackedPAX DOOR AFT ANGLE BRACKET CRACKED MID WAY DOWN.SDR ASOA2013102909267Retainer · damagedFWD CARGO DOOR SEAL RETAINER ON LOWER SIDE DENTED AND CHAFED. REPAIRED IAW REO 670-52-35-127, REV B. MAJOR REPAIR IAW GMM 5-3.SDR ASOA2013102909266Bracket · crackedPAX DOOR AFT ANGLE BRACKET CRACKED MID WAY DOWN. REPAIRED IAW REO 670-52-11-287.SDR ASOA2013102909265Retainer · damagedMID CARGO DOOR SEAL RETAINER ON LOWER CORNERS CHAFED AND DENTED. REPAIRED IAW REO 670-52-35-127, REV B. MAJOR REPAIR IAW GMM 5-3.SDR ASOA2013092709104Bulkhead · damagedFS 169, BULKHEAD DAMAGED. REMOVED BULKHEAD IAW SRM 51-42-06 AND SRM 51-42-13, AND SRM 51-42-21. INSTALLED NEW BULKHEAD IAW SRM 51-42-06 AND IAW DWG CC670-34090 AND DWG CC670-34204, CC670-33001 ,CC670-33030, CC670-33040, CC670-33045, CC670-34090.SDR ASOA2013082808921Floorbeam · crackedCOCKPIT FLOORBEAM, BL 12L CRACKED. REPAIRED IAW REO 690-53-11-561 AND SRM 51-21-11,51-25-16,51-42-06,51-42-21 AND ISE STR-12-004, REV NC.
Back to N676CA