N317CA
Service difficulty reports · 275
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 = 'N317CA' 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 = 'N317CA' 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 V0XD20160303046Placard · missingPITCH DISCONNECT & ALTERNATE EXTENSION HANDLES MISSING ILLUMINATING PLACARDS. INSTALLED PLACARDS, 604-51878-1, 604-51878-3, & 604-51878-7, ON HANDLES IAW AMM 20-60-04.SDR V0XD20160229037Floor Support · corrodedFLOORBOARD SUPPORT IN AVIONICS BAT AR FS 280.00 IS CORRODED. R & R FLOORBOARD SUPPORT ANGLE AT FS 280.00 IAW SRM 51-42-06 & 51-25-16.SDR N6WA2016010902Wire · burnedBURNING WIRE SMELL COMING FROM PAX DOOR AREA. TROUBLE SHOT WIRING & FOUND WIRES TCE4418WB LEADING TO PX27 & TCE4419WB LEADING TO PX EITH BURN MARK. WIRE REPAIR CARRIED OUT IAW ELEC WIRE REPAIR MANUAL 20-30-00. PERFORMED DOOR INDICATION CHECK IAW AMM 52-70-0SDR WVER2015120800001Angle · gougedWHILE PERFORMING SB 670BA-53-044, FOUND LT SIDE CAP ANGLE AT FS 202, BETWEEN STR 13L AND 14L TO BE GOUGED ON AFT SIDE NEAR RADIUS .27"L X .070"W X .040"D.SDR N6WA2015082201Light · inoperativeEMERGENCY LIGHT NEAR ROW 1 INOPERATIVE. DEFERRED EMER LIGHT NEAR ROW 1 IAW MEL 33-51-01B.SDR N6WA2015071801Light · malfunctionedEMERGENCY LIGHTS STAY ON, TWO IN FIRST CLASS & TWO AT THE OVERWING EXIT.SDR N6WA2015071202Door · lack of lubeUNABLE TO OPEN MAIN PAX DOOR. CLEANED & LUBED PAX DOOR AS REQUIRED. PERFORMED OPERATIONS CHECK OF PAX DOOR IAW AM 52-11-00. OPERATIONS CHECKED GOOD.SDR N6WA2015061801Door Seal · dirtyEMERGENCY COCKPIT HATCH LEAKING WATER. CLEANED & LUBED HATCH SEAL IAW AMM 12-20-52, NO LEAKS.SDR N6WA2015061502Light · inoperativeRIGHT OVERWING EMER EXIT LAMP OUT. RELAMPED RT OVERWING EMER EXIT LIGHT IAW AMM 33-51-05. OPERATIONS CHECKED GOOD.SDR N6WA2015060702Light · inoperativeEMERGENCY EXIT LIGHT BULBS BURNT OUT. R & R PAX & GALLEY DOOR EMER LIGHTS BULBS IAW AMM 33-51-05. OPERATIONS CHECKED GOOD.SDR N6WA2015060602Pin · out of positionSERVICE DOOR DOES NOT CLOSE PROPERLY. REPOSITIONED SERVICE DOOR PIN IAW AMM 52-11-00. OPERATIONS CHECKED GOOD.SDR N6WA2015050105Wheel · malfunctionedPASSENGER DOOR SUPPORT WHEEL FAILED TO DEPLOY WHEN DOOR OPENED & HIT THE GND. PERFORMED INSPECTION & OPERATIONS CHECK OF PAX DOOR SUPPORT WHEEL IAW AMM 52-11-13. PERFORMED EXTERNAL INSPECTION & OPERATIONS CHECK OF PAX DOOR IAW AMM 52-11-00. ALL OPERATIONS CHSDR N6WA2015012801Linkage · dirtyUNABLE TO CLOSE PAX DOOR. CLEANED & LUBED LINKAGE, CYCLED DOOR 5 CYCLES, OPERATIONS CHECKED GOOD IAW AMM 52-11-02.SDR N6WA2015030601Motor · malfunctionedMAIN CABIN DOOR ASSIST MOTOR STOPS ABOUT 3/4 WAY DOWN. DEFERRED PAX DOOR POWER ASSIST MOTOR IAW MEL 52-11-01A CAT C.SDR N6WA2015021802Cable · brokenPASSENGER DOOR ASSIST CABLE BROKEN. DIFFERED PAX DOOR ASSIST CABLE IAW MEL 52-11-01A. ON 2/19/15 R & R DOOR ASSIST CABLE IAW AMM 52-11-08.SDR N6WA2014112302Light · inoperativeEMERGENCY LIGHT BULBS INOPERATIVE AT ROW 12A. RELAMPED LOWER EMER LIGHT AT SEAT 12A IAW AMM 33-51-05. OPERATIONS CHECKED GOOD. ACFT OK FOR SERVICE.SDR N6WA2014100602Safety Valve · malfunctionedCABIN ALTIMETER CAUTION MSG. R & R SAFETY VLV IAW AMM 21-32-03. OPERATIONS CHECKED GOOD.SDR N6WA20170716001Motor · intermittentMAIN PAX DOOR MOTOR INTERMITTENT. PERFORMED OPERATIONS CHECK OF PAX DOOR FOR TROUBLESHOOTING IAW AMM 52-11-00, OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA20140624005Light · inoperativePASSENGER DOOR EMER FLOODLIGHT BULBS INOPERATIVE. R & R BULBS IAW AMM 33-51-05, OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA20140619003Cover · defectiveLEFT BLEED DUCT CAUTION MSG. INSPECTED DUCT MON SYS IAW AMM 36-21-00, OPERATIONS CHECK GOOD. INSPECTED BLEED SYS & PERFORMED OPERATIONS CHECK OF THE LT BLEED SYS IAW AMM 36-10-00, OPERATIONS & LEAK CHECK GOOD. FOUND BAD APU BLEED COVER COUPLING. R & R COVESDR N6WA20140618004Acm · malfunctionedSMOKE SMELL IN THE CABIN & COCKPIT. INSPECTED & FOUND RT ACM AS CAUSE OF SMOKE. DEFERRED RT PACK IAW MEL 21-51-01A CAT C.SDR N6WA20140618001Loop · out of positionLEFT BLEED DUCT WARNING IN FLIGHT. INSPECTED & FOUND BLEED LOOP AY MT141B & 142B TO BE TOUCHING. REPOSITIONED LOOPS IAW AMM 36-21-01. RAN EVENT LOCATIONS & FOUND NO DEFECTS AT THIS TIME. OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA2014050902Cable · frayedPASSENGER DOOR CABLE FRAYED. DEFERRED PAX DOOR POWER ASSIST SYS IAW MEL 52-11-01A CAT C.SDR N6WA20140421002Battery · dischargedFORWARD EMERGENCY LIGHTS INOPERATIVE. R & R NR 1, 2 & 3 EMERGENCY LIGHT BATTERIES IAW AMM 33-51-17.SDR N6WA20140320003Seal · dirtyESCAPE HATCH LEAKS WATER. REMOVED HATCH, CLEANED SEAL IAW CRJ700 AMM 12-20-52. RE-INSTALLED HATCH IAW CRJ700 AMM 12-20-52, NO WATER LEAKS AT THIS TIME, OK FOR SERVICE.SDR V0XD201402240030Angle · corrodedGALLEY SERVICE DOOR MOUNTING ANGLE CORRODED. R & R GALLEY SERVICE DOOR MOUNTING ANGLE PN SH670-31996-3 IAW CRJ700 SRM 51-42-06 & CRJ700 AMM 20-70-00.SDR V0XD201402240029Hinge · crackedPASSENGER DOOR LOWER STAIR PANEL HINGE ASSEMBLY CRACKED. R & R PAX DOOR LOWER STAIR PANEL HINGE ASSEMBLY PN 601R31980-65 IAW CRJ 700 AMM 52-11-04.SDR V0XD201402240027Tube · chafedSERVICE DOOR CONVOLEX TUBING CHAFFED & TORN. R & R CONVOLEX TUBING PN HCTE-0312-0 & APPLIED NEW HEAT SHRINK, PN RNF100-3-4BLK IAW REO 670-20-12-045.SDR N6WA20140303002Warning System · false activationPASSENGER DOOR LATCH CAUTION MSG. PERFORMED PAX DOOR WARNING SYS OPERATIONS CHECKED IAW CRJ700 AMM 52-70-04, OPERATIONS CHECKED GOOD.SDR N6WA20140302001Warning System · intermittentPASSENGER DOOR LATCH CAUTION INTERMITTENT IN FLIGHT. PERFORMED OPERATIONS CHECK OF DOOR IAW CRJ700 AMM 52-70-04, OPERATIONS CHECKED GOOD AT THIS TIME, NO FAULTS DETECTED.SDR V0XD201402240028Angle · corrodedCOCKPIT FLOOR PANEL 1/4 TURN ANGLE AT FS 280 BEAM CORRODED. REPLACED 1/4 TURN ANGLE AT FS 280.00 BEAM, PN CL670-33292-13 IAW CRJ700 SRM 51-42-06 & 51-42-13.SDR V0XD201402240026Door Seal · misinstalledLEFT OVERWING EMERGENCY EXIT PRESS SEAL IMPROPERLY INSTALLED. R & R LT OVERWING EMERGENCY SEAL WITH NEW IAW CRJ 700 AMM 52-21-07.SDR V0XD201402240024Skin · gougedFUSELAGE GOUGED AT FS 981.00, STRINGER 27. REMOVED DAMAGED SECTIONS, FABRICATED REPAIR PARTS & INSTALLED IAW REO 670-53-00-290 REV C.SDR V0XD201402040023Fitting · corrodedGALLEY 1 HAS THREE CORRODED FLOOR FITTINGS. REPLACED THREE CORRODED GALLEY FLOOR FITTINGS PN`S 9331091-3, CDSP 2019-7C760 & A661091-1 IAW C & D ZODIAC CMM 25-33-42.SDR V0XD201402240025Tru · overheatedTRU NR 2 0VERHEATED. R & R NR 2 TRU IAW CRJ 700 AMM 34-31-01, OPERATIONS CHECKED GOOD.SDR V0XD201402220020Sill · corrodedRIGHT HAND FS 280 - 319.7 SILL CORRODED. REMOVED DAMAGED SILL & ORIGINAL DOUBLER, INSTALLED NEW SILL & ORIGINAL DOUBLER IAW CRJ 700 SRM 51-42-13, 51-21-01, 51-25-16, 51-21-11, 51-40-11 & CRJ 700 AMM 20-70-00.SDR V0XD201202220019Fitting · crackedLINTEL AT STRINGER 3 & FS 285 CRACKED. REMOVED DAMAGED PORTION, PERFORMED NDT, FABRICATED NEW ANGLES & INSTALLED NEW PARTS IAW REO 670-53-21-493 REV C.SDR V0XD201202200018Angle · corrodedAFT QUARTER TURN ANGLE AT FS 280.00 CORRODED. R & R AFT QUARTER TURN ANGLE PN CC670-33292-13S IAW CRJ700 SRM 51-42-06 & 51-42-21.SDR V0XD201202200017Angle · corrodedPASSENGER DOOR MID CAP ANGLE CORRODED. R & R ANGLE IAW SRM 51-41-02, 51-40-11, 51-25-06, 51-45-00, & AMM 51-21-01 20-70-00.SDR V0XD201202200016Fitting · corrodedPASSENGER DOOR FWD CLOSING FITTING CORRODED. R & R CLOSING FITTING PN SH670-31840-3 IAW CRJ700 SRM 51-40-11, 51-45-00, 51-42-21, 51-42-06, & AMM 20-70-00.SDR V0XD201402200015Angle · corrodedPASSENGER DOOR FWD CAP ANGLE CORRODED. R & R FWD CAP ANGLE PN SH670-31821-5 IAW CRJ700 SRM 51-42-06, 51-40-11, & AMM 20-70-00.SDR V0XD201402200014Bulkhead · corrodedLEFT STATION 280.00 LOWER BULKHEAD WEB CORRODED. REMOVED LOWER WEB, FABRICATED & INSTALLED NEW WEB PN CC670-34170 IAW REO 670-53-11-594 REV 2011 04 27.SDR V0XD201402200013Bulkhead · corrodedRIGHT STATION 280.00 LOWER BULKHEAD WEB CORRODED. REMOVED LOWER WEB, FABRICATED & INSTALLED NEW WEB PN CC670-34170 IAW REO 670-53-11-594 REV 2011 04 27.SDR V0XD201402200012Intercostal · corrodedINTERCOSTAL AT STRINGER 27, NR 2 POSITION, AT FS 364.00 CORRODED. R & R INTERCOSTAL AT STRINGER 27, NR 2 POSITION AT FS 364.00 WITH NEW PN SH670-32075-4 CRJ 700 SRM 51-42-06, 51-21-11, 51-40-11, 51-23-00, 51-21-16, 51-42-13, 51-42-21 & CRJ AMM 20-70-00.SDR V0XD201402200011Intercostal · corrodedINTERCOSTAL AT STRINGER 27, NR 3 POSITION CORRODED. R & R INTERCOSTAL AT STRINGER 27, NR 3 POSITION WITH NEW PN SH670-3075-3 IAW SRM 51-42-06, 51-21-11, 51-40-11, 51-23-00, 51-21-16, 51-42-13, 51-42-21 & AMM 20-70-00.SDR V0XD201402200010Floorbeam · corrodedFS 280.00 BEAM CORRODED. R & R FS 280.00 BEAM WITH NEW PN CC670-34175-7S IAW SRM 53-11-41, 51-21-11, 51-21-16, 51-24-36, 51-42-13, 51-42-22, 51-42-02, 51-42-21, 51-42-06 & AMM 20-70-00.SDR V0XD201402200007Beam · corrodedFRAME AT FS 1036.00 AT LBL 26 CORRODED. REMOVED CORRODED SECTION OF BEAM FROM FS 994.00 - 1037.00 AT LBL 27, FABRICATED REPAIR PARTS & INSTALLED IAW REO 670-53-00-029 REV A DATED 2010-08-31.SDR V0XD201402200009Sill · corrodedAFT CARGO DOOR SILL CORRODED. REPLACED AFT CARGO DOOR SILL WITH NEW PN MM670-35655-003 IAW SRM 51-42-06, 51-42-13, 51-42-21, 51-23-00, 51-21-11, 51-40-11, 51-41-00, 51-25-16 & AMM 20-70-00.SDR V0XD201402200008Post · corrodedLEFT POST AT FS 279.00 LBL 11 CORRODED. REPAIRED LT POST AT FS 279.00 LBL 11 BY REMOVING CORRODED AREA, FABRICATING REPAIR PARTS & INSTALLING IAW REO 670-53-11-745 DATED 2012-09-08.SDR V0XD201402190005Drag Angle · corrodedPASSENGER DOOR AFT DRAG ANGLE CRACKED. REPAIRED PAX DOOR AFT DRAG ANGLE BY REMOVING DAMAGED AREA, FABRICATING REPAIR PARTS & INSTALLING IAW REO 670-52-11-072 REV E DATED 2009-10-26.
Back to N317CA