# Service difficulty reports: N8974C

A list on [N8974C](https://openairdocs.org/aircraft/N8974C.md).

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Page 1 of 2 · 97 reports

- [SDR REXA2022091402060](https://openairdocs.org/sdr/REXA2022091402060.md): Bushing · migrated · Sep 8, 2022 · N8974C · Cndair CL6002B19 · Main Landing Gear
  > RH MLG AFT TRUNNION BUSHING IS MIGRATED OUT OF LIMITS AT.024 (MAX IS.002) REMOVE AND REPLACED R/H MLG AFT TRUNNION BUSHING IAW BOMBARDIER SB601R-32-054 REV. C DATED MAY 22, 2019.
- [SDR REXA2022062401395](https://openairdocs.org/sdr/REXA2022062401395.md): Angle · cracked · Jun 16, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CABLE GUIDE PULLEY BRACKET FS 484 RBL 36 HAS CRACKED ATTACH ANGLE. REPLACED ANGLE PER REO 601R-53-41-059
- [SDR REXA2022062401394](https://openairdocs.org/sdr/REXA2022062401394.md): Angle · cracked · Jun 16, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CABLE GUIDE PULLEY BRACKET FS 484 RBL 27 HAS CRACKED ATTACH ANGLE. REPLACED ANGLE PER REO 601R-53-41-059
- [SDR REXA2022062401393](https://openairdocs.org/sdr/REXA2022062401393.md): None · cracked · Jun 16, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CABLE GUIDE PULLEY BRACKET AT FS484 LBL36 HAS CRACKED CLIP. REPLACED CLIP PER REO 601R-53-41-059
- [SDR REXA2022062401391](https://openairdocs.org/sdr/REXA2022062401391.md): Seat Track · corroded · Jun 11, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > SEAT TRACK AT RBL 9 F.S. 559.00+112 TO 121 CORRODED. COMPLIED WITH GREO 601R-53-00-485
- [SDR REXA2022062401389](https://openairdocs.org/sdr/REXA2022062401389.md): Seat Track · corroded · Jun 11, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > SEAT TRACK AT RBL27 F.S. 559.00+80-96 SCREW HOLES CORRODED. COMPLIED WITH GREO 601R-53-00-485
- [SDR REXA2022062401392](https://openairdocs.org/sdr/REXA2022062401392.md): Seat Track · corroded · Jun 8, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > SEAT TRACK AT LBL9 FS559.00+110 TO 559.00+121 ALL SCREW HOLES CORRODED. COMPLIED WITH GREO 601R-53-00-485
- [SDR REXA2022062401390](https://openairdocs.org/sdr/REXA2022062401390.md): Seat Track · corroded · Jun 8, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > SEAT TRACK AT RBL9 FS559.00+86 TO 559.00+96 ALL SCREW HOLES CORRODED. COMPLIED WITH GREO 601R-53-00-485
- [SDR REXA2022062401388](https://openairdocs.org/sdr/REXA2022062401388.md): Seat Track · corroded · Jun 2, 2022 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FLOOR SEAT TRACK CORRODED RBL 9 F.S. 409+116. COMPLIED WITH GREO 601R-53-00-485
- [SDR REXA2020081200612](https://openairdocs.org/sdr/REXA2020081200612.md): Solenoid Valve · inoperative · Aug 6, 2020 · N8974C · Cndair CL6002B19 · APU Engine Fuel and Control
  > CREW REPORTED A FUEL ODOR WITH THE NR 1 PACK ON, IN THE COCKPIT. FOUND FUEL SOLENOILD VALVE ON APU LEAKING. REPLACED THE SOLENOID VALVE IAW AMM 49-31-05. OPS AND LEAK CHECKED GOOD. R & R APU FUEL CONTROL IAW AMM 49-31-01. OPS & LEAK CHECKED GOOD.
- [SDR REXA2020030400315](https://openairdocs.org/sdr/REXA2020030400315.md): Bulkhead · chafed · Feb 23, 2020 · N8974C · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FS621 RPB WEB AHS 4 EA CHAFES FROM BAGGAGE LINEAR SCREWS AT WL103 RBL18, 27, AND 36 + WL76 LBL 23. C/W REPAIR TO 621RPB CHAFES IAW BSC REO 601R-53-61-2155 REV A DATED 2013-08-13. NO DEFECTS NOTED. WVAC
- [SDR REXA2020030400314](https://openairdocs.org/sdr/REXA2020030400314.md): Bulkhead · cracked · Feb 21, 2020 · N8974C · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > ONE CRACK INDICATION NOTED IN FS 621 RPB WEB AT ""HEEL LINE AREA"" OF LBL 27 VERT POST ""Z"" MEMBER AT WL 130.5 - WL 131 (TOP OF CARGO DOOR TRACK) BY 100% FSH. FAILED NDT INSP. REPAIRED FS621 BULKHEAD IAW REO 601R-53-61-1541 REV
- [SDR REXA2020030400313](https://openairdocs.org/sdr/REXA2020030400313.md): Seat Track · corroded · Feb 21, 2020 · N8974C · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > L/H SIDEWALL SEAT RAIL IS CORRODED AT F.S. 499 TO F.S. 544. REMOVED UNSERVICEABLE LH SIDEWALL SEAT RAIL AT FS 499-544 FABRICATED AND INSTALLED NEW SEAT RAIL IAW REO 601R-53-00-055 REV C. WVAC STAMP
- [SDR REXA2020030400312](https://openairdocs.org/sdr/REXA2020030400312.md): Support Angle · corroded · Feb 19, 2020 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > THE SERVICE DOOR LOWER FLOOR SUPPORT ANGLE IS CORRODED REPLACED MOUNTING ANGLE P/N 601R38303-253 IAW CRJ 200 SRM 51-42-36, 51-42-11, 51-42-21 AND 51-42-06. WVAC STAMP
- [SDR REXA2020030400310](https://openairdocs.org/sdr/REXA2020030400310.md): Seat Track · corroded · Feb 18, 2020 · N8974C · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > L/H SIDEWALL SEAT RAIL CORRODED FROM F.S. 409+16 TO F.S. 409+112. REMOVED AND REPLACED L/H SIDEWALL SEAT RAIL @ 409+16.0 TO 409+112 IAW BSC REO 601R-53-00-485 DATED 2018-01-29 REV D. WVAC STAMP
- [SDR REXA2020030400311](https://openairdocs.org/sdr/REXA2020030400311.md): Support Angle · corroded · Feb 17, 2020 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FS 349 TRANSVERSE BEAM CAP IS CORRODED AT RBL 40 AROUND OUTBOARD WINDSCREEN MOUNT. REPLACED CORRODED ANGLE AND REINSTALLED RELATED STRUCTURAL PARTS IAW CRJ 200 SRM 51-42-21, CRJ 200 SRM 51-42-13 AND CRJ 200 SRM 51-42-06. WVAC STAMP
- [SDR REXA2020030400309](https://openairdocs.org/sdr/REXA2020030400309.md): Seat Track · corroded · Feb 14, 2020 · N8974C · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > RH FLOOR SEAT RAIL IS CORRODED & GOUGED AT FS 394 TO FS 409+128. ISNTALLED NEW SEAT RAIL FS 394 - 409+128 RBL 9 P/N 601R31032-21 IAW BOMBARDIER CRJ 200 AMM 53-01-11-400-802. WVAC STAMP EMP# 717 MTC.
- [SDR REXA2020030400308](https://openairdocs.org/sdr/REXA2020030400308.md): Seat Track · corroded · Feb 14, 2020 · N8974C · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > L/H FLOOR SEAT RAIL CORRODED & GOUGED FROM F.S. 394 - F.S. 409+128 INSTALLED NEW SEAT RAIL F.S. 394 - 409.128 LBL 9 P/N 601R31032-21 IAW BOMBARDIER CRJ 200 AMM 53-01-11-400-802. WVAC STAMP EMP# 717 MTC.
- [SDR REXA2020030400307](https://openairdocs.org/sdr/REXA2020030400307.md): Seat Track · corroded · Feb 14, 2020 · N8974C · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > R/H FLOOR SEAT RAIL CORRODED/GOUGED AT F.S. 364-394. INSTALLED NEW SEAT RAIL F.S. 364-394 RBL 9 P/N 601R31032-15 IAW BOMBARDIER CRJ 200 AMM 53-01-11-400-802. WVAC STAMP
- [SDR REXA2020030400306](https://openairdocs.org/sdr/REXA2020030400306.md): Light · inoperative · Feb 14, 2020 · N8974C · Cndair CL6002B19 · Emergency Lighting
  > EMERGENCY LIGHT CENTER OF CABIN CEILING LIGHT INOP LOCATION: (F) CEILING EMERGENCY FLOOD LT #2 (REF: AMM 33-51-00-13)PG.13). REMOVED AND INSTALLED NEW SERVICEABLE EMERGENCY LIGHT IAW CRJ 200 AMM 33-51-16-000-801 AND 33-51-16-400-801. OPS TEST GOOD. WVAC EMP #
- [SDR REXA2018121401232](https://openairdocs.org/sdr/REXA2018121401232.md): Bulb · inoperative · Dec 14, 2018 · N8974C · Cndair CL6002B19 · Emergency Lighting
  > EXTERIOR EMERGENCY LIGHT 4 INOP RELAMPED EXTERIOR EMERGENCY LIGHT 4 REF CRJ200 AMM 33-51-21. OPS CHECK GOOD
- [SDR REXA2018091100817](https://openairdocs.org/sdr/REXA2018091100817.md): Flashlight · inoperative · Sep 9, 2018 · N8974C · Cndair CL6002B19 · Emergency Equipment
  > FA FLASHLIGHT INOP. REMOVED AND REPLACED FA FLASHLIGHT IAW AMM 25-61-02. OPS CHECK GOOD.
- [SDR REXA2018051760387](https://openairdocs.org/sdr/REXA2018051760387.md): Oxygen Mask · leaking · May 16, 2018 · N8974C · Cndair CL6002B19 · Crew Oxygen System
  > ENROUTE, SUSPECT FIRST OFFICER 02 MASK LEAKINE OR SOV NOT CLOSING. R & R THE FIRST OFFICER`S OXYGEN FULL FACE MASK, OPS CHECKED GOOD IAW AMM 35-11-12.
- [SDR REXA2018040900280](https://openairdocs.org/sdr/REXA2018040900280.md): Yaw Damper · malfunctioned · Apr 9, 2018 · N8974C · Cndair CL6002B19 · Speed-Attitude Correction System
  > CREW DECLARED EMERGENCY, LEFT WIND FUEL CROSSFLOW RAN CONTINOUSLY AND IMBALANCE GREW TO 600LBS WITH LT WING LIGHT, UPON LEVEL OFF IMBALANCE BEGAN TO CORRECT AND RETURNED TO A BALANCED STATE. UNCOMMANDED YAW MOTION AT FL330, DESCENDED TO 270 AND YAW STILL PR
- [SDR REXA2018040700279](https://openairdocs.org/sdr/REXA2018040700279.md): Shear Tie · damaged · Apr 7, 2018 · N8974C · Cndair CL6002B19 · Fuselage Internal Mounting Structure
  > FRAME BS 267 MISSING END OF THE SHEAR TIE. REPAIRED THE SHEAR TIE IAW EA 253-06779
- [SDR REXA2018040700278](https://openairdocs.org/sdr/REXA2018040700278.md): Frame · damaged · Apr 7, 2018 · N8974C · Cndair CL6002B19 · Fuselage Main, Frame
  > UPPER LEFT BS 208 FRAME WAS FOUND DAMAGED. REMOVED AND REPLACED THE FRAME.
- [SDR REXA2018040600276](https://openairdocs.org/sdr/REXA2018040600276.md): Angle · cracked · Apr 6, 2018 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > STRINGER 3L, INBD AND OTBD ANGLES ARE CRACKED. JUST AFT OF BS 280. REMOVED AND REPLACED THE ANGLES IAW SRM 51-42-06, SRM 51-42-21, AND SRM 51-40-11.
- [SDR REXA2018032800275](https://openairdocs.org/sdr/REXA2018032800275.md): Bracket · cracked · Mar 28, 2018 · N8974C · Cndair CL6002B19 · Nacelle/Pylon Miscellaneous Structure
  > RIGHT PYLON UPPER STANG FAIRING FWD BRACKET CRACKED. REMOVED AND REPLACED THE BRACKET IAW CMM 20-42-06.
- [SDR REXA2018032800274](https://openairdocs.org/sdr/REXA2018032800274.md): Web · cracked · Mar 28, 2018 · N8974C · Cndair CL6002B19 · Passenger/Crew Doors
  > AFT WEB AT STEP 1 IS CRACKED ON THE PAX DOOR. CUTOUT THE DAMAGE AND INSTALLED A REPAIR IAW REO 601R-52-11-702, OPS CHECKED GOOD IAW AMM 52-11-17-710-802.
- [SDR REXA2018032600273](https://openairdocs.org/sdr/REXA2018032600273.md): Support Bracket · cracked · Mar 26, 2018 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > RIGHT OVERWING SUPPORT BRACKET AT BS 449.85 IS CRACKED. REMOVED AND REPLACED THE SUPPORT BRACKET IAW SRM 51-42-06.
- [SDR REXA2018032500272](https://openairdocs.org/sdr/REXA2018032500272.md): Bracket · cracked · Mar 25, 2018 · N8974C · Cndair CL6002B19 · Fuselage Main, Attach Fittings
  > FLIGHT DECK PILOT SIDE ANGLE BRACKET IS CRACKED NEAR WINDOW SILL BY BS 210. REMOVED AND REPLACED BRACKET IAW SRM 51-42-21.
- [SDR REXA2018032400269](https://openairdocs.org/sdr/REXA2018032400269.md): Frame · cracked · Mar 24, 2018 · N8974C · Cndair CL6002B19 · Fuselage Main, Frame
  > FRAME 333 IS CRACKED JUST I/B OF STR 1L, IN THE CABIN. REPAIRED FRAME 333, I/B OF STR 1L IAW EA CRJ-253-06709.
- [SDR REXA2018032100271](https://openairdocs.org/sdr/REXA2018032100271.md): Attach Bracket · cracked · Mar 21, 2018 · N8974C · Cndair CL6002B19 · Wing, Attach Fittings
  > LT WING CTR L/E PANEL INBD ATTACH BRKT CRACKED AT ANTI-ICE TRANS DUCT MOUNT. REMOVED AND REPLACED LT WING CTR L/E PANEL INBD ATTACH BRKT IAW SRM 51-41-00.
- [SDR REXA2018031900270](https://openairdocs.org/sdr/REXA2018031900270.md): Angle · cracked · Mar 19, 2018 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > INTERCOSTAL BETWEEN LBL27 AND LT SILL AT FS 484.0 INBD CLIP IS CRACKED. REMOVED AND REPLACED INBOARD LT ANGLE(CLIP) FS484 WITH NEW ANGLE IAW REO 601R-53-41-059 REV B.
- [SDR REXA2017081800893](https://openairdocs.org/sdr/REXA2017081800893.md): Door Track · chafed · Aug 18, 2017 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > WHILE PERFORMING A 12 MONTH INSPECTION OF CARGO DOOR FITTINGS, DISCOVERED THE FORWARD CARGO DOOR BALANCE SPRING ASSEMBLY CABLE OUT OF POSITION, CAUSING A CHAFFING CONDITION ON THE UPPER CARGO DOOR TRACK CROSS MEMBER IN TWO LOCATIONS. REFERENCE E.O. CRJ253-059
- [SDR REXA2017081500885](https://openairdocs.org/sdr/REXA2017081500885.md): Button · broken · Aug 15, 2017 · N8974C · Cndair CL6002B19 · Crew Oxygen System
  > OBSERVER`S OXYGEN BOX HAS A BROKEN PUSH TO TEST BUTTON. PUSH TO TEST IS INOPERATIVE. REPLACED THE OBSERVER`S OXYGEN MASK BOX IAW AMM 35-11-15. OPS & LEAK CHECKED GOOD.
- [SDR REXA2017022600292](https://openairdocs.org/sdr/REXA2017022600292.md): Light · inoperative · Feb 26, 2017 · N8974C · Cndair CL6002B19 · Emergency Lighting
  > RIGHT AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT, OPS CKS GOOD IAW AMM 33-51-00. P/N ON/OFF - 1317
- [SDR REXA2016081401530](https://openairdocs.org/sdr/REXA2016081401530.md): Door · unknown · Aug 14, 2016 · N8974C · Cndair CL6002B19 · Passenger/Crew Doors
  > MAIN CABIN DOOR WILL NOT SECURE CLOSED. PASSENGER DOOR OUTLINED IN RED WITH PASSENGER DOOR OUTER HANDLE MESSAGE ON DOORS SYNOPTIC PAGE. AS IS UNABLE TO LOCK THE STOW AND SECURE HANDLE FROM INSIDE THE AIRCRAFT. PERFORMED VI OF PAX LATCH MECHANISM, DOOR CLOSED
- [SDR REXA2016071501814](https://openairdocs.org/sdr/REXA2016071501814.md): Bpsu · inoperative · Jul 15, 2016 · N8974C · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAPS FAIL CAUTION DURING FINAL, FAILED AT 30 AND AIRSPEED AT 160-165. REMOVED AND REPLACED THE LEFT AND RIGHT BPSU IAW MTR.
- [SDR REXA2016071301293](https://openairdocs.org/sdr/REXA2016071301293.md): Bpsu · failed · Jul 13, 2016 · N8974C · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAPS FAIL CAUTION IN FLIGHT, FL 260. OCCURED WHILE FLAPS STOPPPED EICAS PFLAP POSITION INDICATES 0, FLAPS AT O. AIRSPEED 300KNTS/. 74 MACH 45 MINS INTO FLIGHT OAT SAT -22/TAT 5. FOUND RT BPSU SHORTED INTERNALLY. REMOVED AND REPLACED IAW AMM 27-51-10. ALL
- [SDR REXA2016071101813](https://openairdocs.org/sdr/REXA2016071101813.md): Bpsu · inoperative · Jul 11, 2016 · N8974C · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAPS FAILED AT 8 DEGREES AFTER DEPARTURE. R & R THE RT BPSU IAW AMM 27-51-10, AND FECU IAW AMM 27-51-05. OPS CHECKED AND RIGGING GOOD.
- [SDR REXA2016060800976](https://openairdocs.org/sdr/REXA2016060800976.md): Battery · discharged · Jun 8, 2016 · N8974C · Cndair CL6002B19 · Emergency Equipment
  > FORWARD FLIGHT ATTENDANT FLASHLIGHT NOT BLINKING. R & R FLIGHT ATTENDANT FLASHLIGHT BATTERY IAW AMM 25-61-02. OPERATIONS CHECKED NORMAL.
- [SDR REXA2016060300971](https://openairdocs.org/sdr/REXA2016060300971.md): Handle · out of adjust · Jun 3, 2016 · N8974C · Cndair CL6002B19 · Passenger/Crew Doors
  > MAIN CABIN DOOR NOT CLOSING PROPERLY. ADJUSTED OUTER HANDLE DETENT & PUSHROD IAW NRWC 520650.
- [SDR REXA2016052400910](https://openairdocs.org/sdr/REXA2016052400910.md): Structure · gouged · May 24, 2016 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > WHILE PERFORMING INCOMING DAMAGE PERMANENT REPAIR TO WATCH ITEM 53336, CUSTOMER CARD 628814 FOUND FURTHER DAMAGE. FOUR EACH GOUGES AT FS 589.00 - 596.00, BETWEEN STRINGER 21R & 22R. REPAIRED FS 589 - 596, BETWEEN STRINGER 21R & 22R IAW EA CRJ253-04343.
- [SDR REXA2016052300911](https://openairdocs.org/sdr/REXA2016052300911.md): Structure · dented · May 23, 2016 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > WHILE PERFORMING CUSTOMER TASK CARD W533337, A DENT AT FS 592, BETWEEN STRINGERS 25R & 26R COULD NOT BE RE-CONTOURED & REQUIRES REPAIR. PERFORMED CUT OUT OF DAMAGE & FABRICATED & INSTALLED REPAIR DOUBLER IAW EA CRJ253-04341.
- [SDR REXA2016052200908](https://openairdocs.org/sdr/REXA2016052200908.md): Angle · cracked · May 22, 2016 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FS 559 PRESS BULKHEAD CAP ANGLE IS CRACKED IN RADIUS AT LBL 18. REPAIRED CAP ANGLE AT 559 IAW EO P53025
- [SDR REXA2016052200907](https://openairdocs.org/sdr/REXA2016052200907.md): Angle · cracked · May 22, 2016 · N8974C · Cndair CL6002B19 · Engine Cowling System
  > LEFT ENG UPPER STANG FAIRING FWD Z ANGLE CRACKED. R & R UPPER STANG FAIRING FWD Z ANGLE IAW CMM 20-42-06.
- [SDR REXA2016051500906](https://openairdocs.org/sdr/REXA2016051500906.md): Post · cracked · May 15, 2016 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > VERTICAL POST STATION 409.0+128, BL 0.00, CRACKED RT SIDE IN RADIUS OF C CHANNEL. REMOVED CRACKED ANGLE & INSTALLED NEW ANGLE IAW REO 601R-53-41-2030 DATED 5 13 16 IAW SB 601R-53-083 REV C.
- [SDR REXA2016051200903](https://openairdocs.org/sdr/REXA2016051200903.md): Angle · cracked · May 12, 2016 · N8974C · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > RIGHT ACM RACK, Z ANGLE CRACKED. R & R UNSERVICEABLE Z ANGLE WITH A SERVICEABLE Z ANGLE IAW SRM 51-42-06 & 51-41-21.
- [SDR REXA2016051000905](https://openairdocs.org/sdr/REXA2016051000905.md): Support Bracket · cracked · May 10, 2016 · N8974C · Cndair CL6002B19 · Cargo/Baggage Doors
  > BAGGAGE DOOR LOWER FWD RAIL SUPPORT BRACKET IS CRACKED. R & R UNSERVICEABLE FWD RAIL SUPPORT BRACKET WITH A SERVICEABLE FWD RAIL SUPPORT BRACKET IAW SRM 51-42-06 & 51-41-02.

Next page: https://openairdocs.org/aircraft/N8974C/reports.md?page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'N8974C' AND registry_match = 'registration'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/aircraft/N8974C/reports

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.