N691CA
Service difficulty reports · 242
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 = 'N691CA' 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 = 'N691CA' 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 ASOA2015101213928Seat Track · corrodedLT SIDE SEAT RAIL FS 677-FS 720.85 IS CORRODED IN MULTIPLE AREAS. CORROSION ON SEAT RAIL AT 677-720.85IS BEYOND ALLOWABLE LIMITS IAW SRM SUPPLEMENT 53-41-49. R & R LT SIDE SEAT RAIL FS 677-FS720.85 IAW AMM 53-00-49-000-801-A07/ 53-00-49-400-801-A07. COMPLIEDSDR ASOA2015101213927Seat Track · corrodedLT SIDE SEAT RAIL FS 581-661 IS CORRODED IN MULTIPLE AREAS. CORROSION ON SEAT RAIL AT 661-677 IS BEYOND ALLOWABLE LIMITS IAW SRM SUPPLEMENT XJET 53-41-49. REMOVED SEAT RAIL ON LT SIDE AT FS 661-FS 677 IAW AMM 53-00-49-000-801-A07. COMPLIED WITH EC/TC REO ANDSDR ASOA2015101213926Seat Track · corrodedLT SIDE SEAT RAIL FS 581-661 IS CORRODED IN MULTIPLE AREAS. CORROSION ON SEAT RAIL AT 581-661 IS BEYOND ALLOWABLE LIMITS IAW SRM SUP 53-31-49. R & R SIDE SEAT RAIL AT FS 581-FS 661 IAW AMM 53-00-49-000-801-A07. COMPLIED WITH EC/TC REO 670-53-00-343 AND GREOSDR ASOA2015101213925Seat Track · corrodedLT SIDE SEAT RAIL FS 379-485 IS CORRODED IN MULTIPLE AREAS. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM SUPPLEMENT. R & R SEAT RAIL IAW AMM 53-00-49-000-801-A07 53-00-49-400-801-A07.SDR ASOA2015101213924Seat Track · corrodedLBL9 SEAT RAIL SEGMENT 847.62-977 CORRODED SEVERAL AREAS. REMOVED CORROSION FROM SEAT RAIL AT LBL9, FS 847.62-977 IAW SRM 51-21-06-001-001 A01, FOUND TO BE OUT OF LIMITS IAW SUPPLEMENT 53-41-49 & REO 670-53-00-013. REMOVED SEAT RAIL AT FS 847.62-977 AT LBL 9SDR ASOA2015101213923Seat Track · corrodedRBL 9, SEAT TRACK SEGMENT BS 847.62 - 977 CORRODED SEVERAL AREAS. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED THE SEAT TRACK IAW AMM 53-00-49-000-801 A07. FABRICATED A NEW SEAT TRACK IAW REO 670-53-00-343. INSTALLED THE NEWSDR ASOA2015101213922Seat Track · corrodedLBL9 SEAT TRACK SEGMENT BS 836.40 - 847.62 CORRODED AT SEVERAL AREAS. CORROSION BEYOND ALLOWABLE LIMITS OF SRM SUPPLEMENT 53-41-49. R & R SEAT TRACK IAW AMM 53-00-49-000-801 AND 53-00-49-400-801.SDR ASOA2015101213921Seat Track · corrodedRBL9 SEAT RAIL SEGMENT 836.40-847.62 CORRODED SEVERAL AREAS. CORROSION OF RBL9, SEAT RAIL AT 836-847.62 IS BEYOND ALLOWABLE LIMITS OF SRM SUP: 53-41-49. REMOVED RBL9 SEAT RAIL FS 836.40-847.62 IAW AMM 53-00-49-000-801 A07 FABRICATED NEW SEAT RAIL AT RBL FS 8SDR ASOA2015101213920Seat Track · corrodedLBL 9 SEAT RAIL SEGMENT 683-836,40 CORRODED SEVERAL AREAS. REMOVED CORROSION FROM SEAT RAIL AT LBL9, FS 683-836.40 IAW SRM 51-21-06-001-001 A01 FOUND TO BE OUT OF LIMITS IAW SRM SUP: 53-41-49 & REO 670-53-00-013. REMOVED SEAT TRACK FROM ACFT AT LBL9, FROM FSSDR ASOA2015101213919Seat Track · corrodedLBL9 SEAT RAIL SEGMENT 661+16 -683 CORRODED SEVERAL AREAS. CORROSION OF LBL9 SEAT RAIL AT 661+16-683 IS BEYOND ALLOWABLE LIMITS OF SRM SUPPLEMENT 53-41-49. R & R SEAT RAIL AT FS 661.00+16-683.00 IAW AMM 53-00-49-400-801 AND 53-00-49-040-801. COMPLIED WITH ESDR ASOA2015101213918Seat Track · corrodedRBL9, SEAT RAIL SEGMENT 661+16-683 CORRODED SEVERAL AREAS. CORROSION OF RBL 9 SEAT RAIL AT 661+16-683 IS BEYOND ALLOWABLE LIMITS OF SRM SUP: 53-41-49. R & R SET RAIL AT 661.00+16-683.00 IAW AMM 53-00-49-000-801 AND 53-00-49-400-801. COMPLIED WITH EC/TC REO SDR ASOA2015101213917Seat Track · corrodedRBL 9 SEAT RAIL SEGMENT FS 581-661+16 CORRODED SEVERAL AREAS. CORROSION OF RBL 9 SEAT RAIL AT 581-661+16 IS BEYOND ALLOWABLE LIMITS OF SRM SUP 53-31-49. R & R SEAT RAIL AT RBL9 FS 581-00-661.00+16 IAW AMM 53-00-49-000-801 AND 53-00-49-400-801. COMPLIED WITHSDR ASOA2015101213916Seat Track · corrodedRBL9 SEAT RAIL SEQMENT FS 349-485 CORRODED SEVERAL AREAS. EVALUATED CORROSION SEAT RAIL CORRODED BEYOND REPAIR IAW SRM 53-21-49-101-001 A01 ALLOWABLE DAMAGE EXCEEDED IAW SUP: 53-21-49. REMOVED RBL9 SEAT RAIL, FS 349-485 IAW AMM 53-00-49-000-801. FABRICATED NSDR ASOA2015101013983Floorbeam · corrodedRIGHT SIDE FLOOR SILL AT FRAME 280 IS CORRODED. R & R FLOOR SILL DUE TO SEVERE CORROSION. REMOVED AND BEGAN INSTALLATION RT FLOOR SILL BETWEEN FS 280 AND FS 319 IAW SRM 51-42-06-001-001-A01 AND 51-42-13-001-001-A01. RT FLOOR SILL BETWEEN FS 280 AND FS 319 FSDR ASOA2015101013963Floor Support · corrodedRT FLOOR SUPPORT BETWEEN FS 349 AND FS 364 IS CORRODED. REMOVED CORROSION FROM RT FLOOR SUPPORT STRUCTURE BETWEEN FS 349 AND FS 353, RBL 40-RBL 43 IAW SRM 51-21-06-001-001-A01. BLEND DIMENSIONS ARE 2.5" WIDE BY 4" LONG. RECEIVED & COMPLIED WITH REO 670-53-2SDR ASOA2015101013962Access Panel · chafedRT AILERON LOWER L/E ACCESS PANEL 699BB HAS CHAFE MARKS. REMOVED DAMAGE ON ACCESS PANEL 699BB IAW SRM 51-12-00-001-001-A01. RECEIVED AND COMPLIED WITH EA 26-2015-152. RECEIVED AND COMPLIED WITH ECTC EA26-2015-152. COMPLIED WITH PERMANENT OF EA26-2015-152.SDR ASOA2015101013915Floor Support · corrodedLEFT FLOOR SUPPORT BS 364 AND 349 IS CORRODED. COMPLIED WITH EC/TC REO 670-53-00-390 AND EO 670-53-00-390, REV.SDR ASOA2015101013914Floor Support · corrodedRIGHT SIDE FLOOR SUPPORT BETWEEN FRAME 310 AND FRAME 319.7 IS CORRODED. R & R RT FLOOR SUPPORT BETWEEN FS 288 AND 319 IAW SRM 51-12-06-001-001-A01, 51-42-21-001-001-A01 AND 51-42-13-001-001-A01.SDR ASOA2015100813982Wire · brokenRIGHT AFT LIGHT ON PANEL 172CR HAS A BROKEN WIRE. INSTALLED SERVICEABLE CONTACT ON WIRE THAT WAS BROKEN OFF FROM CONTACT IAW ESPM 20-12-00 AND 20-26-00. REMOVED CONTACT/WIRE FROM POSITIVE CONNECTOR OF LIGHT, EM EXTERIOR. INSTALLED SERVICEABLE LIGHT EM EXTERISDR ASOA2015100813961Floor Panel · crackedFWD EQUIPMENT COMPARTMENT FLOOR IS CRACKED ON LT SIDE AT FRAME CUTOUT AT FS193.00. COMPLIED WITH EC/TC REO 670-53-11-509 AND GREO 670-53-11-509 REV B, DATED 01/28/2014 FOR LT SIDE.SDR ASOA2015100813913Floor Panel · crackedFWD EQUIPMENT COMPARTMENT FLOOR IS CRACKED ON RT SIDE AT FRAME CUTOUT AT FS 193.00. COMPLIED WITH EC/TC REO 670-53-11-509 AND GREO 670-53-11-509, REV B, DATED 1-28-14 FOR RT SIDE.SDR ASOA2015100713960Light · deterioratedSEVERAL PIECES OF EMERGENCY LIGHT TRACK WORN, STRAINED. REQUIRES REPLACEMENT CUT AS REQUIRED, RECEIVED SERIVCABLE LIGHT TRACKS AND CUT AS REQURIED IAW CMM 33-51-01.SDR ASOA2015021912248Light · inoperativeNR 1 EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE EXTERNAL EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR ASOA2015020612165Door · out of rigMAIN CABIN DOOR WILL NOT OPEN, DOOR ACTUATOR HOLDING DOOR UP. REPOSITIONED DOOR CABLE ON PULLEY & OPS CHECKED SEVERAL TIMES. OPS CHECKED GOOD. IAW AMM 52-11-00. ACFT OK FOR SERVICE.SDR ASOA2014092511318Light · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R RT AFT OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-51-15. OPS CHECKED GOOD.SDR ASOA2014082511136Flashlight · inoperativeF/O FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT. OPS CHECKED GOOD.SDR ASOA2014061310673Skin · burnedTWO BURNS ON FASTENERS AND ONE BURN ON FUSELAGE SKIN BETWEEN FS 677-693 ABOVE STR 20. REPAIRED IAW REO 670-53-00-045.SDR ASOA2014061310672Skin · burnedTWO BURNS ON FASTENERS BETWEEN FS 645-661 AND S20R. REPAIRED IAW REO 670-53-00-045.SDR ASOA2014061310671Skin · burnedONE BURN ON FASTENER AT FS 645 ABOVE S20R. REPAIRED IAW REO 670-53-00-045.SDR ASOA2014061310670Skin · burnedTWO BURNS ON FASTENERS AT FS 265 AND S22R. REPAIRED IAW REO 670-53-00-045.SDR ASOA2014061310669Skin · burnedTWO BURNS ON FASTENERS BETWEEN F 235-250 AND S23R. REPAIRED IAW REO 670-53-00-045.SDR ASOA2014061310668Skin · burnedONE BURN ON FASTENER AT FS 20275 AND STGR 23R. REPAIRED IAW REO 670-53-00-045.SDR ASOA2014021109959Handle · frozenPAX DOOR HANDLE FROZEN. HEATED CABIN WITH THE APU AND REMOVED DEBRIS FROM DOOR JAM OPS CHECKED OK IAW AMM 52-11-00. ACFT OK FOR SERVICE.SDR ASOA2014013109820Handle · frozenMAIN PAX DOOR HANDLE WILL NOT OPERATE TO LOCK, UNLOCK DOOR. RAN ACFT HEATING SYSTEM WITH PAX DOOR HELD IN CLOSED POSITION, PAX DOOR OPERATES NORMALLY IAW AMM 52-11-00. AIRCRAFT RETURNED TO SERVICE.SDR ASOA2014011509748Megaphone · inoperativeF/A REPORTED MEGAPHONE INOPERATIVE. R & R MEGAPHONE IAW AMM 25-61-14. CHECKED GOOD.SDR ASOA2013112209473Ground Wire · brokenLT AFT OVER WING EMERGENCY LIGHT INOP. FOUND BROKEN GROUND WIRE REPAIRED IAW ESPM 20-16-00. OPS CHECKED GOOD IAW AMM 33-51-00-710-801.SDR ASOA2013112209472Bulb · burned outEMERGENCY LIGHT AT SERVICE DOOR ON GALLEY 2 AT FLOOR LEVEL HAS THREE BULBS INOPERATIVE. R & R BULBS, OPS CHECKED GOOD IAW AMM 33-51-00-710-801.SDR ASOA2013112209471Floorbeam · damagedFLOORBEAM DAMAGED. REPAIRED CENTER COCKPIT FLOORBEAMS AT BL 12.00. FABRICATED IMBD UPPER ANGLE IAW REO 690-53-11-603 STEP G. LOCATED AND DRILLED -ANGLE IAW REO 690-53-11-603. COMPLETED ECTC REO 690-53-11-603 AND REO 690-53-11-603. MAJOR REPAIR.SDR ASOA2013112209470Skin · dentedDENT FOUND IN FUSELAGE SKIN BETWEEN BS 193-202.75 AND BETWEEN S12-13L. COUNTERSUNK DEBURRED TREATED AND PRIMED NWE SKIN PANEL IAW SRM 51-21-11-001-001-A01, 51-40-11-001-001-A01. INSTALLED NEW SKIN PANEL AND APPLIED FILLET SEALANT IAW SRM 51-42-06-001-001-A01SDR ASOA2013112209469Floor Support · corrodedFOUND LOGITUDINAL BEAM AT LBL 9 CORRODED ON UPPER FLANGE BETWEEN FS 280 AND 295. REMOVED CORROSION FROM UPPER SURFACE OF LONGITUDINAL BEAM AT LBL 9 FLANGE BETWEEN FS280 -FS 295 IAW SRM 51-21-06-001-001-A01. MAJOR REPAIR.SDR ASOA2013112209468Hinge · gougedPAX DOOR HINGE GOUGED ON MULTIPLE HALF LUGS. REPAIRED IAW REO 670-52-11-511 REV DATED 6-29-10, REO 670-53-21-582 REV B.SDR ASOA2013112209467Skin · dentedDENT IN HORIZONTAL STAB RT SIDE JUST BELOW CENTER LINE AND INBD OF RIB 3 DIMENSIONS ARE 1.9" LONG BY 1.2" WIDE AND HAS MAX DEPTH OF .053. REPAIRED IAW REO 690-55-12-872, REO 690-55-12-572, ECTC REO 690-55-12-072 AND REO 690-55-12-072. MAJOR REPAIR.SDR ASOA2013112209466Skin · dentedTWO DENTS ON LT INBD FLAP TOP SURFACE LOCATED BETWEEN FLS 30.00 AND 42.00 FWD T/E AND 6" FWD T/E. COMPLIED WITH NON FLASH REPAIR TO INBD FLAP IAW EO 900-57-0012 AND SRM 57-52-01-201-001-A01.SDR ASOA2013112209465Angle · corrodedSERVICE DOOR ANGLE MOUNT CORRODED UNDER DOOR STOP. REMOVED SERVICE DOOR ANGLE MOUNT IAW SRM 51-42-06-001-001-A01. LOCATED AND DRILLED NEW ANGLE MOUNT. INSTALLED NEW ANGLE MOUNT IAW SRM 51-42-06-001-001-A01, 51-42-34-001-001-A01 AND DWG SH670-31996.SDR ASOA2013112009445Skin · corrodedSKIN ON OUTER SURFACE UNDER TCAS ANTENNA BS 295 & 310 CORRODED AT STRINGER 27. REPAIRED IAW REO 690-53-21-567.SDR ASOA2013112209464Frame · corrodedFRAME BS 295 HAS CORROSION BETWEEN S24-25R. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR ASOA2013112009444Attach Angle · corrodedFOUND ATTACH ANGLE CORRODED AT FS 349 RT SIDE. REMOVED CORRODED ATTACH ANGLE IAW REO 690-53-21-568. LOCATED DRILLED AND DEBURRED HOLES IN ANGLE IAW SRM 51-40-11-001-001-A01. INSTALLED ATTACH ANGLE IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SDR ASOA2013112209463Angle · corrodedMID CAP ANGLE CORRODED AT PAX DOOR FLOOR SUPPORT. R & R ANGLE IAW SRM 51-42-13-001-001-A01, SRM 51-41-02-001-001-A01.SDR ASOA2013112209462Attach Angle · corrodedLEFT COCKPIT DOOR POST LOWER END ATTACH ANGLE CORRODED BEYOND LIMITS FS 280, LBL 11.00 REPLACED CORRODED ANGLE. REPAIRED IAW SRM 51-12-00-001-001 AND SRM 53-00-00-101-001.SDR ASOA2013112009443Seat Track · corrodedLBL 9 SEAT TRACK CORRODED AT FS 661+16. R & R SEAT TRACK IAW AMM 53-00-49-000-801 AND AMM 53-00-49-400-801.
Back to N691CA