N695CA
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 = 'N695CA' 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 = 'N695CA' 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 ASOA201705071557Stringer · corrodedSTRINGER 26L,FS 319.70- FS 333.00 CORRODED. REMOVED AND REPLACED STRINGER AT FS 319.70-333.00 26L PER SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01. P/N-SH670-31654-1. DRAWING SH670-343651.SDR ASOA201705061556Doubler · corrodedTCAS ANTENNA INTERNAL DOUBLER BETWEEN FS 295.00 AND 310.00, NEAR STRINGER 27 IS CORRODED. REMOVED AND REPLACED TCAS ANTENNA INTERNAL DOUBLER BETWEEN FS 295.00 AND 310.00 NEAR STRINGER 27 IAW SRM 51-42-06-001-001 A01.SDR ASOA201705061555Frame · corrodedFS 319.70 BETWEEN STRINGER 25L AND 25R, FWD AND AFT SIDES CORRODED. REMOVED CORROSION AND 5 RIVETS IAW SRM 51-21-06-001-001 A01 AND 51-42-06-001-001 A01. PERFORMED UT THICKNESS INSPECTION OF FRAME IAW NDTM PT 1 51-20-004-270 A01. MINIMUM THICKNESS IS .047", ORSDR ASOA201705061554Frame · corrodedFS 333.00 FRAME BETWEEN STRINGERS 25L AND 26R, AFT SIDE IS CORRODED. REMOVED CORROSION ON FS 333.00 IAW SRM 51-21-06-001-001 A01 AND 6 RIVETS IAW SRM 51-42-06-001-001-A01. PERFORMED UT THICKNESS INSPECTION OF FRAME IAW NDTM PT 1 51-20-004-270 A01. MINIMUM THICSDR ASOA201705061553Intercostal · corrodedINTERCOSTAL, FS349-364, STR 27R CORRODED. REMOVED AND INSTALLED NEW INTERCOSTAL, FS349-364, STR 27R IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-42-20-001-001-A01, 51-40-11-001-001-A01, 51-23-00-001-001-A01, 51-25-16-001-001-A01, 51-21-11-001-001-A01SDR ASOA2016071515090Door · out of adjustUNABLE TO OPEN FWD PAX DOOR FROM INSIDE OR FROM OUTSIDE GRD CREW. FOUND THE PAX DOOR LATCH SPRINOTS OUT OF ADJUSTMENT CAUSING THE LATCH OCMS TO BIND WICH COUSED THE SECONDARY LOCK MECHONISM TO BIND AND NOT UNLOCK. ADJUSTED THE PAX DOOR LATCH SPGOTS IAW AMM SDR ASOA2016070815076Lever · unknownMAIN CABIN DOOR LEVER DIFFICULT TO RAISE AND LOWER. PERFORMED OPS TEST OF THE PASSENGER DOOR IAW AMM 52-11-00. OPS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIME.SDR ASOA2016062815028Door · bindingMAIN PASSSENGER DOOR STICKS WHEN OPENING FROM INSIDE. COMPLIED WITH OPERATIONAL TEST OF PASSENGER DOOR PER AMM 52-11-00 WITH NO FAULTS FOUND.SDR ASOA2016062214980Door · jammedMAIN PASSENGER DOOR WOULD NOT OPEN, TOOK SEVERAL ATTEMPTS TO OPEN BEFORE DOOR WOULD OPEN. COMPLIED WITH INSPECTION OF PASSENGER DOOR AND DOOR FRAME NO DEFECTS NOTED. COMPLIED WITH FUNCTIONAL TEST OF PASSENGER DOOR, OPS CHECK GOOD. NO DEFECTS NOTED OK IAW AMSDR ASOA2016062114979Shaft · lack of lubeF/A REPORTS PASSENGER DOOR VERY DIFFICULT TO OPEN. CYCLED PASSENGER DOOR SEVERAL TIMES, OPS TEST GOOD IAW AMM 52-11-00. APPLY LUBE TO PASSENGER DOOR INNER HANDLE SHAFT ASSY IAW AMM 12-20-52. ACFT OK FOR SERVICE.SDR ASOA2016061114921Door · stuckPASSENGER DOOR WILL NOT OPEN. PERFORMED OPS CHECK IAW AMM 52-11-00, NO DEFECTS NOTED. ACFT OK FOR SERVICE.SDR ASOA2016053114907Ice Breaker · brokenMAIN PAX DOOR T-HANDLE OUTSIDE DIFFICULT TO OPEN EVERY NOW AND THEN. FOUND ICE BREAK BROKEN ON THE T-HANDLE. R & R ICE BREAKER. OPS CHECK TEST GOOD. REF AMM 52-11-15.SDR ASOA2016053114906Door · unknownCABIN DOOR VERY DIFFICULT TO OPEN AFTER FLIGHT. OPS CHECK OF THE CABIN DOOR CHECK GOOD AFTER SEVERAL CYCLES. NO FURTHER DEFECT NOTED AT THIS TIME. REF AMM 52-11-00.SDR ASOA2016052714899Megaphone · unserviceableDMEGA PHONE INOPERATIVE. R & R MEGAPHONE IAW AMM 25-61-14, IPC 25-61-14, ITEM 5. ACFT OK FOR SERVICE.SDR ASOA2016050614758Roller · lack of lubePAX DOOR DIFFICULT TO LATCH CLOSED AND EVEN MORE DIFFICULT TO UNLATCH OPEN. INSPECTED PAX DOOR; NO DEFECTS NOTED. LUBED ROLLERS AND OPS CHECKED DOOR IAW AMM 52-11-00.SDR ASOA2016042714741Door · lack of lubeF/A COULD NOT OPEN DOOR UPON PARKING, RAMPER COULD NOT OPEN FROM OUTSIDE, THE F/O FINALLY GOT IT WITH A LOT OF SHOULDER. F/A SAYS IT IS NOT FUNCTIONING PROPERLY. SPRAY LUBED AND OPS CHECKED IAW AMM 52-11-00. OPS CHECKED GOOD.SDR ASOA2016030114547Lock · malfunctionedF/A REPORTS DIFFICULTY OPERATING MAIN PAX DOOR. COMPLIED WITH INSP OF PAX DOOR LOCKING MECHANISM NO DEFECTS NOTED, C/W OPS CHECK OF PASSENGER DOOR CHECK GOOD, NO DEFECTS NOTED, OK IAW AMM 52-11-00.SDR ASOA2015122014235Megaphone · unknownMEGAPHONE TO BE REPLACED TO C/W TC EO 700-25-0166. R & R MEGAPHONE IAW AMM 25-61-14.SDR V0XD20150903170Web · corrodedLEFT & RIGHT WEBS AT FS 280.00 CORRODED. R & R WEBS AT FS 280.00 WITH FABRICATED WEBS IAW REO 670-53-11-594 DATED 27 APRIL 2015.SDR ASOA2015081713554Door · lack of lubeF/A UNABLE TO OPEN PASSENGER DOOR F/O WAS ABLE TO ASSIST BY PUSHING ON TOP LATCH TO RELEASE. LUBRICATED PASSENGER DOOR IAW AMM 12-20-52. OPS CHECK GOOD. AIRCRAFT READY FOR SERVICE.SDR ASOA2015061513107Latch · dirtyCABIN DOOR LATCH IS STICKING INTERMITTENTLY, F/A WAS UNABLE TO OPEN DOOR ON ARRIVAL. CLEANED LATCH AND LUBRICATED AND OPS CHECKED IAW AMM 52-11-00. OPS CHECKED GOOD.SDR ASOA2015041012586Smoke Detector · false indicationAFT LAV SMOKE WARNING MESSAGE IN FLT. COMPLIED WITH QRH, BREAKERS PULLED, FALSE FIRE WARNING DURING FLIGHT. PERFORMED OPS TEST OF THE AFT LAVATORY SMOKE DETECTOR IAW AMM 26-16-00. OPS CHECK GOOD, ACFT OK FOR SERVICE.SDR ASOA2014112111719Floor Support · corrodedRIGHT CABIN FLOOR SUPPORT BETWEEN BS 280 & 319.70 WAS FOUND CORRODED AND NEW PART WAS MIS-DRILLED. RECEIVED REO678-53-21-684. COMPLIED WITH REO 690-53-21-684. RECEIVED & COMPLIED WITH EC/TC REO 690-53-21-684.SDR ASOA2014112111717Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED. REPAIRED AFT DRAG ANGLE ON PAX DOOR IAW SRM 52-11-04-201-002-A01.SDR ASOA2014112011711Seat Track · corrodedRT SIDE SEAT TRACK HAS CORROSION, FS 785.15. DAMAGED IS BEYOND ALLOWABLE LIMITS IAW SRM 53-41-49-101-001-A01. REMOVED THE SEAT TRACK IAW AMM 53-00-49-0000-801, CONFIG A07. FABRICATED NEW SEAT TRACK IAW SRM 51-40-11-001-001-A01 & REO 670-53-00-343. INSTALLESDR ASOA2014111811698Stiffener · crackedBS 280 LOWER BULKHEAD WEB STIFFENER IS CRACKED AT LBL 38.50. R & R CRACKED STIFFNER WITH NEW STIFFNER IAW SRM 51-42-06-001-001-A01.SDR ASOA2014112111716Stringer · corrodedSTRINGER 25R CORRODED AT BS 336. REMOVED AND INSTALLED NEW JOINT SPLICE IAW SRM 51-42-06-001-001-A01.SDR ASOA2014112111715Frame · corrodedFRAME BS 295 CORRODED FWD & AFT SIDES BETWEEN STR'S 26LT-25RT. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REPAIRED FRAME SECTION IAW REO 670-53-21-799 & 670-53-21-687.SDR ASOA2014112111714Retainer · gougedCENTER BAGGAGE BAY DOOR LOWER SEAL RETAINER IS GOUGED AT LOWER AFT CORNER. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. RECEIVED AND COMPLIED WITH EC/TC REO 690-52-35-013 FOR THE PERMANENT REPAIR IAW REO 690-52-35-013, REV A.SDR ASOA2014112111713Retainer · dentedCENTER BAGGAGE BAY DOOR LOWER SEAL RETAINER DENTED AT LOWER FWD CORNER. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. RECEIVED AND COMPLIED WITH EC/TC REO 690-52-35-013 FOR THE PERMENENT REPAIR IAW REO 690-52-35-013, REV A.SDR ASOA2014112011710Angle · corrodedGALLEY SERVICE DOOR LOWER SILL ANGLE IS CORRODED. REMOVED THE DOOR SILL ANGLE IAW SRM 51-42-06-001-001-A01AND INSTALLED IAW SRM 51-42-06-001-001-A01.SDR ASOA2014112011709Seat Track · corrodedLBL 9 SEAT TRACK SEGMENT CORRODED AT BS 374. REMOVED THE SEAT TRACK IAW AMM 53-00-49-000-801. FABRICATED A NEW SEAT TRACK IAW REO 670-53-00-343. INSTALLED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07.SDR ASOA2014112011708Angle · corrodedPAX DOOR UPPER CAP ANGLE CORRODED. R & R THE CAP ANGLE IAW SRM 51-40-11-001-001-A01, SRM 51-41-02-001-001-A01 & SRM 51-45-00-001-001-A01.SDR ASOA2014112011707Bulkhead Web · corrodedBULKHEAD WEB AT BS 280 IS CORRODED. REPAIRED IAW REO 670-53-11-594 AND GREO 670-53-11-594 REV. MAJOR REPAIR.SDR ASOA2014112011706Bulkhead Web · corrodedBULKHEAD WEB AT BS 280 IS CORRODED. REPAIRED IAW REO 670-53-11-594 AND GREO 670-53-11-594 REV. MAJOR REPAIR.SDR ASOA2014112011705Floor Support · corrodedRT CABIN FLOOR SUPPORT CORRODED BETWEEN BS 280 & 319.7. FOUND TO BE OUT OF LIMITS. R & R THE FLOOR SUPPORT IAW SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01.SDR ASOA2014112011704Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 349 & 364 AT STR 27L. R & R INTERCOSTAL IAW SRM 900 51-42-06-001-001-A01.SDR ASOA2014112011703Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 349 & 364, STR 27RT. R & R INTERCOSTAL IAW SRM 51-42-06-001-001-A01.SDR ASOA2014112011702Doubler · corrodedTCAS DOUBLER INTERNAL SKIN CORRODED AT STR27 BETWEEN FRAMES 295-310. NO DAMAGE ALLOWED IAW SRM 53-21-01-101-02-A02. RECEVIED SERIVCEABLE TCAS DOUBLER FROM STORES. REMOVED UNSERVICABLE TCAS ANTENNA DOUBLER REF TO SRM 51-42-06-001-001-A01 AND 5-42-21-001-001-SDR ASOA2014112011701Skin · corrodedCIRCUMFERENTIAL JOINT AT FS 280.00 INTERNAL SKIN CORRODED FROM STR 24LT-25RT. REMOVED CORROSION AT FS 280.00 BETWEEN STR 24LT AND 24RT IAW SRM 51-22-06-001-001-A01. RECEIVED AND COMPLIED WITH STS EA 32-2014-171. RECEIVED AND COMPLIED WITH ECTC EA 32-2014-16SDR ASOA2014111811697Seat Track · corrodedLBL 9 SEAT TRACK SEGMENT 581-661+32 CORRODED SEVERAL AREAS. FOUND BEYOND ALLOWABLE DAMAGE LIMITS IAW GREO670-53-00-013. REMOVED SEAT TRACK IAW AMM 53-00-49-000-801-A07. FABRICATED NEW SEAT TRACK IAW GREO670-53-00-343, REV G 9/25/14. INSTALLED SEAT TRACK ISDR ASOA2014111811696Seat Track · corrodedLBL 9 SEAT TRACK SEGMENT BS 661+32-692.97 CORRODED SEVERAL AREAS. CORROSION IS BEYOND ALLOWABLE DAMAGE LIMITS IAW SRM 53-41-49-101-001-A01. REMOVED SEAT RAIL AT LBL 9 IAW AMM 53-00-49-000-801-A07. FABRICATED NEW SEAT TRACK IAW REO670-53-00-343, REV G 9/25SDR ASOA2014111811695Seat Track · corrodedRBL 9 SEAT TRACK SEGMENT BS 661+32-692.97 CORRODED SEVERAL AREAS. CORROSION IS BEYOND ALLOWABLE DAMAGE LIMITS IAW SRM 53-41-49-001-A01. REMOVED SEAT TRACK AT RBL 9 IAW AMM 53-00-49-000-801-A07. FABRICATED SEAT TRACK IAW REO670-53-00-343, REV G 9/25/14. SDR ASOA2014111811694Seat Track · corrodedRBL 9 SEAT TRACK SEGMENT BS 581-661+32 CORRODED SEVERAL AREAS. BEYOND ALLOWABLE DAMAGE LIMITS IAW GREO670-53-00-013. REMOVED THE SEAT TRACK IAW AMM 53-00-49-000-801-A07. FABRICATED NEW SEAT TRACK IAW GREO670-53-00-343, REV G 9/25/14. INSTALLED SEAT TRACKSDR ASOA2014111811693Seat Track · corrodedRBL9, SEAT TRACK SEQMENT 349.50-485.00 CORRODED SEVERAL AREAS. DAMAGE BEYOND ALLOWABLE LIMITS IAW SRM 53-21-49-101-001-A01. REMOVED SEAT TRACK RBL 9 IAW AMM 53-00-49-000-801-A07. FABRICATED NEW SEAT TRACK IAW GREO670-53-00-343, REV G 9/25/14. INSTALLED SSDR ASOA2014111811692Floorbeam · corrodedCOCKPIT FLOORBEAM CORRODED AT BS 280.00. FLOORBEAM ANGLE R & R IAW SB 670BA-53-041.SDR ASOA2014111811691Floorbeam · corrodedLEFT BS 280 FLOORBEAM CORRODED. FLOORBEAM R & R.SDR ASOA2014111811690Floorbeam · corrodedRIGHT BS 280 FLOORBEAM CORRODED. FLOORBEAM R & R .SDR ASOA2014071610881Panel · damagedPAX DOOR AFT SIDE PANEL DAMAGED. CUT OUT DAMAGED AREA IAW EA 05-2014-002. INSTALLED REPAIR IAW EA 05-2014-002 REV F. MAJOR REPAIR IAW GMM 5-3.SDR ASOA2014070110780Battery Pack · inoperativeEMERGENCY EXIT SIGN AFT 1ST CLASS WILL NOT ILLUMINATE. R & R 1 BATTERY PACK IN FWD AVIONIC BAY IAW AMM 33-51-17, IAPC 33-51-17, FIG 1, ITEM 8. OPS CHECK GOOD.
Back to N695CA