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 V0XD201402180004Attach Angle · corrodedATTACHMENT ANGLE AT STRINGER 26R CORRODED. R & R ATTACHMENT ANGLE IAW CRJ 700 SRM 51-42-06 & 51-42-13. AVMAX WORK ORDER 80201 & WORK CARD 1095.SDR V0XD201402180003Striker · corrodedSERVICE DOOR SEAL STRIKER CORRODED. R & R SEAL STRIKER WITH NEW PN SH670-31412-7 IAW CRJ700 SRM 51-42-06 & CRJ700 AMM 20-70-00.SDR V0XD201402150002Pushrod · corrodedCORROSION FOUND ON MAIN PAX DOOR LOWER PUSH ROD ASSEMBLY. REMOVED LOWER PUSH ROD BOLT. CLEANED AFFECTED AREA IAW AMM 51-26-00, NO FURTHER DAMAGE FOUND. REINSTALLED LOWER PUSH ROD BOLT IAW CRJ 700 AMM 52-11-02.SDR V0XD201402150001Rivet · chafedTWO DAMAGED RIVETS, ONE FWD OF LOWER STEP & ONE AFT OF LOWER STEP ON MAIN PAX DOOR. R & R TWO RIVETS IAW SRM 51-42-10..SDR N6WA20131223001Lens · brokenEMERGENCY EXIT LIGHT LENS ON RT SIDE IS BROKEN. DEFERRED RT FWD EMERGENCY EXIT LIGHT LENS IAW CRJ700 CDL 33-50.SDR N6WA20131118002Warning System · false activationOTBD SPOILERS & OTBD SPOILERON CAUTION MESSAGE. PILOT PERFORMED SOP RESET PROCEDURE. NO MESSAGES AT THIS TIME.SDR N6WA20131011001Pipe · damagedLEFT ENGINE BLEED MASTER CAUTION LIGHT. R & R NR 1 PACK COMPRESSOR DISCHARGE PIPE ASSEMBLY IAW AMM 21-51-06 AND 21-51-08, OP'S AND LEAK CHECK CHECK GOOD AT THIS TIME.SDR N6WA20131009001Shutoff Valve · failedRT BLEED DUCT WARNING MESSAGE AT 13000 FT. R & R RT 10TH STAGE HIGH PRESSURE SHUTOFF VALVE IAW AMM 36-12-05. OPS AND LEAK CHECK GOOD AT THIS TIME.SDR N6WA20131003004Warning Light · false activationPAX DOOR OUTER HANDLE CAUTION.SDR N6WA20131007003Warning Light · false activationPAX DOOR OUTER HANDLE CAUTION MESSAGE. PERFORMED OP'S TEST OF DOOR WARNING SYS IAW AMM 52-70-00. OP'S CHECKED GOOD AT THIS TIME.SDR N6WA20130929004Proximity Sensor · out of adjustNOSE DOOR OPEN WARNING MESSAGE AND PROXIMITY SYS NR 1 AFTER TAKEOFF. ADJUSTED PROXIMITY SENSOR TO CORRECT RANGE AND OPS CHECK GOOD IAW AMM 32-61-05.SDR N6WA20130804001Warning Light · false activationPAX DOOR OUTER HANDLE CAUTION MESSAGE. PERFORMED OP'S CHECK OF PAX DOOR IAW AMM 52-11-00, OP'S CHECKED GOOD, NO DEFECTS AT THIS TIME.SDR N6WA2013080201Warning Message · false activationLEFT BLEED DUCT MASTER WARNING MESSAGE IN FLIGHT. INSPECTED BLEED AIR LOOP, NO DEFECTS NOTED. INSPECTED LT SIDE BLEED AIR DUCT IN SAME AREA, NO DEFECTS NOTED IAW AMM 63-21-00.SDR N6WA2013072101Grounding Strap · brokenGROUNDING CABLE ON PAX DOOR BROKEN. R & R CABLE ASSY IAW AMM 52-11-15, OP'S CHECK GOOD AT THIS TIME.SDR N6WA2013062504Charger · inoperativeEMERGENCY LIGHTS WILL NOT REMAIN ON. R & R NR 2 BATTERY CHARGER IAW AMM 33-51-17. OP'S CHECKED GOOD ON GROUND IAW AMM 33-51-00.SDR N6WA2013062503Light · inoperativeEMERGENCY LIGHTS WILL NOT REMAIN ILLUMINATED.SDR N6WA2013062502Light · inoperativeEMERGENCY LIGHTS WILL NOT REMAIN ILLUMINATED.SDR N6WA2013062501Light · malfunctionedEMRERGENCY LIGHTS WILL NOT REMAIN ILLUMINATED.SDR N6WA2013061101Lamp · burned outEMERGENCY OVERHEAD LIGHT BURNED OUT AT ROW 9. REPLACED LAMP EMERGENCY LIGHT ROW 9 IAW 33-51-09, OP'S CHECKED GOOD.SDR N6WA20130608Pin · damagedPAX DOOR AFT RAIL PIN IS DAMAGED. R & R PAX DOOR AFT RAIL PIN IAW AMM 52-11-27.SDR N6WA20130607Placard · damagedPAX DOOR "OPEN" PLACARD WORN. REMOVED DAMAGED PLACARD, REPLACED WITH SERVICABLE PLACARD IAW AMM 20-60-04.SDR N6WA20130604Bonding Strap · brokenPAX DOOR BONDING STRAP BROKEN. R & R PAX DOOR BONDING STRAP IAW AMM 51-80-00.SDR N6WA2013060403Step · loosePAX DOOR STEP HAS LOOSE HARWARE. TORQUED PAX DOOR STEP HARDWARE IAW AMM 20-21-00.SDR N6WA2013030901Seal · dirtyWATER DRIPPING FROM THE EMERGENCY EXIT HATCH IN THE COCKPIT. REMOVED HATCH, CLEANED DEBRIS FROM SEAL, REINSTALLED HATCH IAW AMM 52-22-00.SDR N6WA2013022804Cable · unsecurePAX DOOR POWER ASSIST CABLE CAME OFF THE PULLEY. FOUND MIDDLE CABLE ON PAX DOOR OFF OF PULLEY, RESECURED CABLE, IAW AMM 52-10-01, OP'S CHECK GOOD AT THIS TIME.SDR N6WA20120701Fmu · failedRIGHT FADEC MESSAGE ON TAKE OFF ROLL. REMOVED & REPLACED NR 2 ENGINE FMU PER AMM. OP'S CHECKED GOOD AT THIS TIME.SDR N6WA2012102202Bulb · inoperativeTWO OF FIVE BULBS INOPERATIVE IN EXIT SIGN, ROW 12 SEATS A & C RT. PERFORMED OPS CHECK OF OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR N6WA2012081401Lens · missingLT OVERWING EXIT PULL HANDLE COVER MISSING THE LENS. DEFERED TO NEF 25-100-6, NEF CONTROL 12587, CAT 5.SDR N6WA2012050909Lens · crackedFORWARD INTERIOR SERVICE DOOR EMERGENCY EXIT LENS CRACKED. R & R FORWARD INTERIOR SERVICE DOOR EMERGENCY EXIT LENS IAW IAW AMM 33-51-15.SDR N6WA2012050908Lens · crackedRT AFT EXTERIOR EMERGENCY EXIT LENS CRACKED. R & R RT AFT EXTERIOR EMERGENCY EXIT LENS IAW AMM 33-51-15.SDR N6WA2012050907Lens · crackedLEFT FORWARD EXTERIOR EMERGENCY EXIT LENS CRACKED. R & R LT FORWARD EXTERIOR EMERGENCY EXIT LENS IAW AMM 33-51-15.SDR N6WA2012050906Cap · missingPAX DOOR ASSIST CABLE ENDS AT SURROND AREA MISSING RUBBER CAPS. INSTALLED HEAT SHRINK RUBBER CAPS ON DOOR ASSIST CABLE ENDS IAW AMM 52-11-00.SDR N6WA2012050905Lens · crackedAFT INTERIOR SERVICE DOOR EMERGENCY EXIT LENS CRACKED. R & R INTERIOR SERVICE DOOR EMERGENCY EXIT LENS IAW AMM 33-51-05.SDR N6WA2012050904Lens · out of positionRIGHT FORWARD EXTERIOR EMERGENCY EXIT LENS NEEDS TO BE INDEXED PROPERLY. INDEXED RT FORWARD EMERGENCY EXIT LIGHT LENS IAW AMM 33-51-15.SDR ASOA201200094Web · corrodedRT BS 280 WEB CORRODED JUST ABOVE FLOOR LEVEL. COMPLIED WITH REO 670-53-11-59401 AND REO 670-53-594 REV.SDR ASOA201200093Skin · dentedDENTS IN FUSELAGE SKIN FS 193 - 202 S15-16L. REPAIRED IAW REO 670-53-11-671.SDR ASOA201200080Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. COMPLY WITH REO 670-53-11-047.SDR ASOA201200079Crossbeam · corrodedLT 280 CROSSBEAM WEB CORRODED. COMPLY WITH REO 670-53-11-594.SDR ASOA201200092Intercostal · chafedINTERCOSTAL & STRINGER 9R CHAFED. BLENDED DAMAGE TO SMOOTH CONTOUR IAW REO 670-53-61-292 REPAIR A STEPS 1-3. PERFORMED UT THICKNESS INSPECTION IAW MAC NDT PROCEDURE UT-3. MIN MATERIAL REMAINING IS .055", ORIGINAL IS .071" MATERIAL. REMOVED IS .046" WITHINSDR ASOA201200091Stringer · chafedSTRINGER 7 RT IS CHAFED AT FS 1158. BLENDED DAMAGE. DAMAGE WITHIN LIMITS OF REO 670-53-61-292, REPAIR B, STEP 1.SDR ASOA201200020Floor Support · corrodedAVIONICS BAY FLOOR SUPPORT CHANNEL CORRODED. REMOVED CORRODED FLOOR SUPPORT CHANNEL IAW SRM 51-42-06-001-001. LOCATED AND DRILLED NEW SUPPORT CHANNEL IAW SRM 51-40-11-001-001. INSTALLED NEW FLOOR SUPPORT CHANNEL IAW SRM 51-42-06-001-001. REPAIR CLASSIFIEDSDR ASOA201200090Floorbeam · damagedREMOVED COCKPIT FLOORBEAM IAW SRM 51-42-06-001-001-, 51-42-21-001-001, 51-42-22-001-001. INSTALLED COCKPIT FLOORBEAM ANGLE AT IAW SRM 51-42-06-001-001, 51-42-21-001-001 AND 51-42-22-001-001.SDR ASOA201200008Channel · corrodedRIGHT NUTPLATE CHANNEL ON AFT CARGO BAY SILL CORRODED AT APPROX FS 1031 TO FS 1088.20. REMOVE CORROSION IAW SRM 51-21-001-001-A01. REPAIR CLASSIFIED AS MINOR.SDR ASOA201102456Web · corrodedRT 280 WEB CORRODED JUST ABOVE FLOOR LEVEL. BLENDED CORROSION IAW SRM 51-21-06-001-001 AND 53-11-10-201-003. FOUND TO BE OUT OF LIMITS IAW SRM 53-11-10-201-003-A01. REPAIRED IAW REO 670-53-11-594.SDR ASOA201102455Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. R & R FLOORBEAM IAW SRM 51-42-06, 51-42-13, 51-42-21 & REO 670-53-11-047.SDR ASOA201102454Cargo Track · corrodedAFT CARGO TRACK AT LBL 9.00 HAS CORROSION AROUND SCREW HOLES. REMOVED CARGO TRACK IAW AMM 53-00-49-000-8001. INSTALLED SERVICEABLE CARGO TRACK IAW AMM 53-00-49-400-801.SDR ASOA201102453Cargo Track · corrodedCARGO TRACK AT RBL 27, FS 1000.00 CORRODED AROUND SCREW HOLES AFT CAGRO BAY. REMOVED CARGO TRACK IAW AMM 53-00-49-000-801. INSTALLED SERVICEABLE CARGO TRACK IAW AMM 53-00-49-400-801.SDR ASOA201102452Cargo Track · corrodedCARGO TRACK AT RBL 9, FS 1000.00 CORRODED AROUND SCREW HOLES AFT CARGO BAY. REMOVED CARGO TRACK IAW AMM 53-00-49-000-801. INSTALLED SERVICEABLE CARGO TRACK IAW AMM 53-00-49-400-801.SDR ASOA201200007Bracket · crackedLEFT INBD FLAP OTBD HINGE ARM OTBD NUTPLATE BRACKET CRACKED IN HALF. REMOVED DAMAGED BRACKET IAW SRM 51-42-06-001-001-A01. INSTALLED NEW BRACKET IAW SRM 51-42-06-001-001-A01.SDR ASOA201102445Bracket · corrodedIN FWD CARGO BAY AT BS 533 LBL 2.5 THE MACHINE BRACKET IS CORRODED. NO CORROSION FOUND ON MACHINE BRACKET AT ST533, LBL2.6.
Back to N317CA