N471CA
Service difficulty reports · 228
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 = 'N471CA' 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 = 'N471CA' 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 SWIA2019120246813Seat Track · corroded#4 SEAT TRACK ON LBL 9 HAS CORROSION (C-CHECK) RO: 12/1/2019 REMOVED CORROSION FOUND TO BE OUT OF LIMITS I.A.W. SRM INSTALLED NEW SEAT TRACKS I.A.W. AMM WORK ACCOMPLISHED BY AAR. SEE ATTACHED WORK CARD FOR WORK PERFORMED.SDR SWIA2019120246812Floor Support · corrodedR/H FLOOR SILL HAS CORROSION FROM FS 559 TO FS 559+80. (C-CHECK) RO: 12/1/2019 REMOVED CORROSION TO WITHIN LIMIT CONDITION F.S. 559.00+16 TO F.S. 559.0+80 I.A.W CRJ-200 SRM 51-21-06 REF REO 601R-53-00-526. CORROSION REMOVAL F.S. 539.00 TO F.S. 559.00+16 DETSDR SWIA2019120246811Floor Support · corrodedR/H FLOOR SILL HAS CORROSION FROM FS 559+80 TO FS 621. (C-CHECK) RO: 12/1/2019 REMOVED CORROSION ON RH FLOOR SILL FROM FS 559+80 TO FS 621 AND FOUND TO BE OUT OF LIMITS IAW REO REMOVE AND REPLACE OF RH FLOOR SILL ACCOMPLISHED ON WO 1017764 ZONE 1000 ITEM 02SDR SWIA2019120246810Floor Support · corrodedLBL 27 FLOOR BEAM CAP HAS CORROSION BETWEEN FS 589 AND FS 610. (C-CHECK) RO: 12/1/2019 REMOVED CORROSION ON LBL27 FLOOR BEAM CAP BETWEEN FS589 AND FS610 REF SRM OUT OF LIMITS REFER TO CARD W/O 1017764 1000 0198 FOR REPLACEMENT OF FLOOR BEAM CAP SEE CP 19733SDR SWIA2019120246809Floorboard · damagedFLOORBOARD 221ALF IS SOFT IN THE MIDDLE (C-CHECK) RO: 12/1/2019 FLOORBOARD 221ALF DAMAGE DETERMINED TO BE OUT OF LIMITS. I.A.W. REPAIR MANUAL RECIEVED REV. "J" NEW FLOORBOARD P/N 601R 330-42-1. TG BB4647. INSTALL ACCOMPLISHED ON CARD 1017763 2000 0002 S/N 7SDR SWIA2019120246808Vane · chafedLT WING I/B FLAP, FLAP VANE HAS CHAFE ON LEADING EDGE O/B OF O/B VANE ACT (C-CHECK) RO: 12/1/2019 LEADING EDGE FLAP VANE SKIN EVUALATED OUT OF LIMITS REMOVED AND REPLACED SKIN IAW SRM. WORK ACCOMPLISHED BY AAR. SEE ATTACHED WORK CARD FOR WORK PERFORMED.SDR SWIA2019120246807Floor Support · out of limitsLBL 27 FLOOR BEAM CAP FS574-610, REQUIRES REPLACEMENT DUE TO OUT OF LIMITS PER REO (C-CHECK) RO: 12/1/2019 REMOVED AND REPLACED LBL 27 FLOOR BEAM CAP FS574-610 REF SRM. WORK ACCOMPLISHED BY AAR. SEE ATTACHED WORK CARD FOR WORK PERFORMED.SDR SWIA2019120246806Actuator · out of toleranceREMOVE AND REPLACE RH IB FLAP. IB FLAP VANE ACT. OUT OF LIMITS PER REO. (C-CHECK) RO: 12/1/2019 REMOVED AND REPLACED R/H I/B FLAP ASSY IAW AMM OPS AND RIG COMPLETED ON WO 1017764 / 6000/0021 SN 7395595 SEE CP 19676267 FOR RIG AND OPS TEST / WORK ACCOMPLISHESDR SWIA2019071046040Selector Valve · faultyGEAR DISAGREE AND NOSE DOOR WARNING MESSAGES APPEARED AFTER TAKEOFF AND AFTER LDG GEAR LEVER WAS MOVED UP, AND WENT AWAY AFTER A DELAY, NOSE GEAR HAD A NORMAL RETRACTION. CONTINED TO DESTINATION. (FLT#5066) FO: 07/10/2019 CLOSED REMOVED AND REPLACED NLG SELECTSDR SWIA201744064Bracket · damagedGEAR DISAGREE ON TAKE OFF, NLG DID NOT COME UP, STAYED GREEN, DOWN & LOCKED. LEFT GEAR DOWN & RETURNED TO FIELD. REMOVED AND REPLACED THE PROXIMITY SENSOR BRACKET. ADJUSTED. OPS CHECKED GOOD.SDR SWIA201743793Cargo Track · corrodedRBL 27 CARGO TRACK BETWEEN BS 559+80 TO 559+96 HAS MULTIPLE SPOTS OF CORROSION. INSTALLED A NEW CARGO TRACK IAW AMM.SDR SWIA201743792Cargo Track · corrodedRBL 9 CARGO TRACK BETWEEN BS 559+112 TO 568 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED THE CARGO TRACK IAW REO.SDR SWIA201743791Cargo Track · corrodedRBL 9 CARGO TRACK BETWEEN BS 559+90 TO 559+96 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED THE CARGO TRACK IAW REO.SDR SWIA201743790Cargo Track · corrodedLBL 9 CARGO TRACK BETWEEN BS 614 - 618 HAS MULTIPLE SPOTS OF CORROSION. INSTALLED A NEW CARGO TRACK IAW AMM.SDR SWIA201743789Cargo Track · corrodedTHE CARGO BAY LBL 9 CARGO TRACK BETWEEN BS 559+112 TO 568 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED THE CARGO TRACK IAW REO.SDR SWIA201743788Cargo Track · corrodedTHE CARGO BAY, LBL 27 CARGO TRACK BETWEEN BS 559+80 TO 559+96 HAS MULTIPLE SPOTS OF CORROSION. REMOVED THE CARGO TRACK AND INSTALLED A NEW CARGO TRACK IAW SRM.SDR SWIA201642889Sensor · failedANTI-ICE WARNING DURING DESCENT, HARD FAULT. DECLARED EMERGENCY. TROUBLEHOT THE ANTI-ICE DUCT WARNING MESSAGE IAW FIM. MESSAGE WITH ENGINES OFF, REPLACED THE LT FUSELAGE SENSING ELEMENT A15WK IAW AMM. OPS CHECKED GOOD.SDR SWIA2014061938229Bulb · burned outEMERGENCY EXIT SIGN ON LT SIDEWALL, JUST FWD OF LT OVERWING EMERGENCY EXIT, HAS MULTIPLE BULBS BURNED OUT. REPLACED THE BULBS IAW AMM.SDR SWIA201437285Lamp · burned outLT WING CENTER EMERGENCY EXIT LIGHT IS BURNED OUT. REPLACED LAMP.SDR SWIA201437284Light · out of positionFLOOR EMERGENCY LIGHTS MISSING IN CERTAIN AREAS. REPOSITIONED THE EMERGENCY LIGHT STRIPS WHICH HAD SLID AFT IN THE EMERGENCY FLOOR LIGHTING CONDUIT IAW AMM.SDR SWIA201335483Skin · crackedLOWER WING PLANK ACCESS HOLE 640 FB IS CRACKED. C-CHECK REPAIRED LOWER WING PLANK ACCESS HOLE 640 FB IAW REO.SDR SWIA201335482Post · crackedFS 409.0 + 128 VERTICAL POST AT RBL 18.0 INBD SIDE, CRACKED. C-CHECK REPLACED VERTICAL POST AT FS 409.0 + 128 AT RBL 18.0 INBD SIDE IAW SRM & REO.SDR SWIA201335486Post · crackedFS 409.0 +128 VERTICAL POST S AT LBL 18.0 OTBD SIDE IS CRACKED. C-CHECK REPLACED VERTICAL POST AT FS 409. +128 LBL 18.0 OTBD SIDE IAW SRM.SDR SWIA201335485Post · crackedFS 409.0 +128 VERTICAL POST BL 0.0 LT SIDE IS CRACKED. C-CHECK REPLACED VERTICAL POST 409.0 + 128 BL 0.0 LT SIDE IAW CRJ-200 SRM 51-42-21 PG 17 STEP 9, IAW REO.SDR SWIA201335484Intercostal · crackedINTERCOSTAL ON AFT SIDE OF AFT PRESSURE BULKHEAD, LBL 36.20, BELOW BOX BEAM, IS CRACKED. C-CHECK REPLACED INTERCOSTAL ON AFT SIDE OF AFT PRESSURE BULKHEAD, LBL 36.20, BELOW BOX BEAM PN 601-35012-51 IAW SRM.SDR SWIA201335497Post · crackedFS 409.0 +128 VERTICAL POST AT RBL 18.0 OTBD SIDE IS CRACKED. C-CHECK REPLACED VERTICAL POST FS 409.0 + 128 AT RBL 18.0 OTBD SIDE IAW REO.SDR SWIA201335496Rib · chafedPAX DOOR VENT DOOR CHAFED AT RIB FROM ICE BREAK CABLE. C-CHECK BLENDED OUT DAMAGED AT PAX DOOR VENT DOOR RIB, IAW REO.C.SDR SWIA201335495Fitting · crackedFLOOR SUPPORT CLIP, STATION FS 484 LBL 27, INBD CLIP CRACKED. C-CHECK REPLACED CLIP AT FS 484 LBL 27 IAW REO.SDR SWIA201335494Fitting · crackedFLOOR SUPPORT CLIP, STATION FS 484 RBL 27, INBD CLIP CRACKED. C-CHECK REPLACED CLIP AT STATION 484 RBL 27 IAW REO.SDR SWIA201335493Support Fitting · crackedFLOOR SUPPORT CLIP, STATION FS 484 RBL 27 OTBD CLIP CRACKED. C-CHECK REPLACED CLIP AT FS 484 RBL 27 OTBD IAW REO.SDR SWIA201335492Vane · chafedLT INBD FLAP VANE IS CHAFED AT OTBD EDGE. C-CHECK REPLACED LT INBD FLAP VANE IAW SRM.SDR SWIA201335491Vane · chafedLT INBD FLAP VANE IS CHAFED AT MID EDGE. C-CHECK BLENDED LT INBD FLAP VANE CHAFE IAW REO.SDR SWIA201335490Vane · chafedLT INBD FLAP VANE IS CHAFED AT INBD EDGE. C-CHECK BLENDED LT INBD FLAP VANE CHAFE IAW REO.SDR SWIA201335489Vane · chafedRT INBD FLAP VANE IS CHAFED AT OTBD EDGE. C-CHECK BLENDED RT INBD FLAP VANE CHAFE IAW REO.SDR SWIA201335488Vane · chafedRT INBD FLAP VANE IS CHAFED AT MID EDGE. C-CHECK BLENDED RT INBD FLAP VANE CHAFE IAW REO.SDR SWIA201335487Vane · chafedRT INBD FLAP VANE IS CHAFED AT INBD EDGE BLENDED RT INBD FLAP VANE CHAFE. ORIGINAL THICKNESS .050. REMAINING THICKNESS .043. MATERIAL LOSS .007. FOUND TO BE WITHIN LIMITS IAW REO.SDR SWIA201335498Structure · crackedFS 202 CRACKED AT PARKING BRAKE. C-CHECK REPAIRED CRACK AT FS 202 PARKING BRAKE IAW REO.SDR SWIA201334223Battery Pack · dischargedEMERGENCY LIGHTS ON EXTERIOR OVER THE WING ARE BURNED OUT. SERVICE REPLACED THE NR 3 ELBP. PN ON 2013-1A, SN ON 110508, PN OFF AD-2013-1A & SN OFF 65916SDR SWIA201334132Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#6490 RELAMPED.SDR SWIA201333500Connector · dirtyLOWER LT WING EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE. CLEANED LOWER LT OVERWING EMERGENCY EXIT LIGHT CONNECTOR.SDR SWIA201333075Lens · missingRED LENSE CAP ON THE CENTER CABIN EMERGENCY SIGN IS MISSING. (FLT 6415) REPLACED FORWARD EMERGENCY EXIT SIGN RED LENS COVER AT ROW EIGHT.SDR SWIA201332684Skin · dentedFOUND DENT ON RIGHT LEADING EDGE HORIZONTAL STAB WHICH IS OUT OF LIMITS. (SERVICE) REPAIRED RT HORIZONTAL LEADING EDGE BY MEANS OF DRESS BACK DENT TO ORIGINAL CONTOUR ON LOWER SKIN SURFACE IAW REO.SDR SWIA201232236Light · inoperativeEMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 6271) RELAMPED EMERGENCY LIGHT.SDR SWIA201231863Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 5410) RELAMPED EMERGENCY LIGHT.SDR SWIA201231559Light · looseBOTTOM LIGHT OF THE EMERGENCY DOOR LIGHT STRIP NEXT TO THE GALLEY SERVICE DOOR IS INOPERATIVE. (FLT 5333) FOUND LIGHT STRIP BULB LOOSE. RE-INSTALLED LIGHT BULB IN REFERENCE TO MM.SDR SWIA201229857Sensing Element · failedRECEIVED MLG OVERHEAT FAIL MESSAGE FOLLOWED BY MLG BAY OVERHEAT MESSAGE. (FLT 5312) REPLACED RIGHT MLG SENSING ELEMENT AND WIRING HARNESS.SDR SWIA201229845Light · inoperativeRIGHT SIDE OVERWING AFT EXTERIOR EMERGENCY LIGHT IS OUT. (FLT 6424) RELAMPED EMERGENCY LIGHT.SDR SWIA201229464Light · inoperativeRIGHT AFT EXTERIOR EMERGENCY LIGHT IS OUT. (FLT 6207) RELAMPED EMERGENCY LIGHT.SDR SWIA201229375Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229189Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5530) RELAMPED EMERGENCY LIGHT.
Back to N471CA