N937XJ
Service difficulty reports · 187
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 = 'N937XJ' 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 = 'N937XJ' 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 REXA2016120702421Link Assy · crackedLT & RT WING LINKS AT BS 797 HAVE CRACKED BEARINGS. LT LOWER IS CRACKED AND RT UPPER IS CRACKED. LINKS ARE IN CONTACT WITH ATTACHMENT FITTINGS. REPAIRED IAW EO R57200, R57189, AND R57190.SDR REXA2016120702422Wire · brokenEMERGENCY LIGHT HAS A BROKEN WIRE. REPLACED THE WIRE. OPS CHECKED GOOD IAW ESPM 20-16-05 AND AMM 33-51-00-710-802-A16.SDR REXA2016120602373Stringer · corrodedSTRINGER 24R BETWEEN BS 349 AND 394 CORRODED. REPAIRED THE STRINGER IAW EA CRJ953-05081.SDR REXA2016120602386Structure · gougedPAX DOOR CUTOUT IS GOUGED FWD SIDE BS 310. REPAIRED PAX DOOR FWD SIDE CUTOUT IAW REO 670-53-22-001 REPAIR TYPE I REV H.SDR REXA2016120602392Support Angle · corrodedGALLEY SERVICE DOOR SUPPORT ANGLE CORRODED. REMOVED AND REPLACED THE SUPPORT ANGLE IAW SRM 51-42-06-001-001-A01.SDR REXA2016120402374Intercostal · corrodedINERCOSTAL BS 349 TO 364 STRINGER 26L CORRODED. REMOVED & REPLACED IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, & 51-42-21-001-001-A01.SDR REXA2016120402375Intercostal · corrodedINERCOSTAL BS 349 TO 364 STRINGER 26R CORRODED. REMOVED & REPLACED IAW SRM 51-40-11-001-001-A01, & 51-42-06-001-001-A01, & 51-42-21-001-001-A01.SDR REXA2016120402393Bulkhead Web · corrodedLEFT AND RIGHT BS 280 BULKHEAD WEB AND CROSSBEAM ARE CORRODED. REMOVED & REPLACED THE BULKHEAD WEB IAW REO 670-53-11-594 REV A AND THE
CROSSBEAM IAW SRM 51-42-06-001-001-A01 & 51-42-22-001-001-A01.SDR REXA2016120202402Seat Track · corrodedRIGHT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01, AND REO 670-53-00-343 REV M.SDR REXA2016120202403Seat Track · corrodedRIGHT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01,
AND REO:670-53-00-343 REV M.SDR REXA2016120202404Seat Track · corrodedRIGHT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01, AND REO:670-53-00-343 REV M.SDR REXA2016120202405Seat Track · corrodedRIGHT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01, AND REO:670-53-00-343 REV M.SDR REXA2016120102381Floorbeam · corrodedAVIONICS BAY FLOORBEAM ANGLE BS 280 IS CORRODED. REMOVED UNSERVICEABLE AVI BAY FLOORBEAM ANGLE. INSTALLED A NEW SNGLE IAW SRM 51-40-11-001-01-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2016120102394Seat Track · corrodedFLOOR SEAT TRACK CORRODED AT RBL 9 BS 349 TO 485. FABRICATED A NEW SEAT TRACK IAW SRM 51-40-11-001-001-A01 AND
REO 670-53-00-343, AND INSTALLED IAW AMM 53-00-49-400-801-A07.SDR REXA2016120102411Seat Track · corrodedRIGHT SEAT TRACK AT RBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01 & REO 670-53-00-343 REV M.SDR REXA2016120102412Seat Track · corrodedRIGHT SEAT TRACK AT RBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01 & REO
670-53-00-343 REV M.SDR REXA2016120102413Seat Track · corrodedRIGHT MID/AFT SEAT TRACK SEGMENTS AT RBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, SRM 51-40-11-001-001-A01 & REO 670-53-00-343 REV M.SDR REXA2016120102415Skin · chafedLEFT AND RIGHT RUDDER LEADING EDGE SKINS ARE CHAFED OVER ENTIRE LENGTH OF RUDDER. REPAIRED THE SKIN IAW EA'S CRJ955-05096, 955-05092, AND
955-05095. REMOVED AND REPLACED THE SKIN IAW SRM 51-42-06-001-001-A01 AND 51-40-11-001-001-A01.SDR REXA2016112902377Frame · corrodedBS 295 FRAME CORRODED BETWEEN STRINGERS 24L AND 24R. REPAIRED THE FRAME IAW REO 670-53-21-799.SDR REXA2016112802399Seat Track · corrodedLEFT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07.SDR REXA2016112802400Seat Track · corrodedLEFT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07.SDR REXA2016112802401Seat Track · corrodedLEFT FUSELAGE AFT SIDE SEAT TRACK BS 669 - 977 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07.SDR REXA2016112702395Seat Track · corrodedLEFT FUSELAGE SIDE SEAT TRACK BS 379 - 669 CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, AMM 53-00-49-400-801-A07 AND REO
670-53-00-343 REV M.SDR REXA2016112702396Seat Track · corrodedLEFT FUSELAGE SIDE SEAT TRACK BS 379 - 669 CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, AMM 53-00-49-400-801-A07 AND REO
670-53-00-343 REV M.SDR REXA2016112702397Seat Track · corrodedLEFT FUSELAGE SIDE SEAT TRACK BS 379 - 669 CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, AMM 53-00-49-400-801-A07 AND REO
670-53-00-343 REV M.SDR REXA2016112702398Seat Track · corrodedLEFT FUSELAGE SIDE SEAT TRACK BS 379 - 669 CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, AMM 53-00-49-400-801-A07 AND REO
670-53-00-343 REV M.SDR REXA2016112702418Stiffener · chafedVERTICAL STAB RT STIFFENER ASSEMBLY UNDER 326AR IS CHAFED ON THE LOWER SKIN. REMOVED AND INSTALLED IAW SRM 51-41-02-001-001-A01.SDR REXA2016112602419Panel · corrodedPANEL 542AZ HAS CORROSION ON THE UNDER SIDE OF THE PANEL AROUND THE MOUNTING SCREW HOLES. REMOVED AND REPLACED THE PANEL IAW SRM 51-40-11-001-001-A01.SDR REXA2016112502378Stringer · corrodedSTRINGER 26R IS CORRODED FROM BS 295 TO 349. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2016112502379Stringer · corrodedSTRINGER 26R IS CORRODED FROM BS 295 TO 349. REMOVED AND REPLACED STRINGER IAW SRM 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2016112502380Stringer · corrodedSTRINGER 26R IS CORRODED FROM BS 295 TO 349. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2016112302376Stringer · corrodedSTRINGER 25R IS CORRODED FROM FS 333 TO 364. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06-001-001-A01, & 51-42-21-001-001-A01.SDR REXA2016112302382Hinge · corrodedPAX DOOR TOP FOLDING STEP HINGE AT AIRFRAMES SIDE HAS CORROSION. REMOVED AND REPLACED WITH NEW SERVICEABLE FOLDING STEP HINGE IAW SRM 51-41-02-001-001-A01 AND 51-40-11-001-001-A01.SDR REXA2016112302384Retainer · gougedCENTER CARGO DOOR, FWD SIDE INNER SEAL RETAINER GOUGED. REMOVED AND REPLACED THE CARGO DOOR FWD INNER SEAL RETAINER IAW SRM 51-41-02-001-001-A01.SDR REXA2016112302406Seat Track · corrodedLEFT CABIN SEAT TRACK AT LBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW REO 670-53-00-343 AND AMM 53-00-49-400-801 CONFIG A01.SDR REXA2016112302407Seat Track · corrodedLEFT CABIN SEAT TRACK AT LBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW REO 670-53-00-343 AND AMM 53-00-49-400-801 CONFIG A01.SDR REXA2016112302408Seat Track · corrodedLEFT CABIN SEAT TRACK AT LBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW REO 670-53-00-343 AND AMM 53-00-49-400-801 CONFIG A01.SDR REXA2016112302409Seat Track · corrodedLEFT CABIN SEAT TRACK AT LBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW REO 670-53-00-343 AND AMM 53-00-49-400-801 CONFIG A01.SDR REXA2016112302410Seat Track · corrodedLEFT CABIN SEAT TRACK AT LBL 9 CORRODED BS 477 - 977. REMOVED AND REPLACED THE SEAT TRACK IAW REO 670-53-00-343 AND AMM 53-00-49-400-801 CONFIG A01.SDR REXA2016111702383Mount · corrodedFWD CARGO BAY JUST AFT OF FWD DOORWAY TWO TIE DOWN BASE PLATES HAVE MINOR CORROSION. REPLACED TIE DOWN BASES IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-21-001-001-A01, & 51-42-22-001-001-A01.SDR REXA2016111602300Light · dimRIGHT EMERGENCY LIGHT IS DIM AT SEAT 12DC. REPLACED THE LIGHT IAW AMM 33-22-01-000-801 A01. OPS CHECKED GOOD.SDR REXA2016101601999Elt · failedELT FAILS OPS CHECK. R & R THE ELT IAW AMM 25-62-02. OPS CHECKED GOOD.SDR REXA2016051700841Light · saturatedLEFT AFT, WING TE EMER LIGHT 1/2 FULL OF WATER. REMOVED EMER LIGHT LENS DRIED OUT INTERIOR AREA & RE-INSTALLED LENS ROTATED 180 WITH DRAIN HOLES AT BOTTOM IAW AMM 33-51-15. OPERATIONS CHECKED GOOD.SDR REXA2015092600902Light · inoperativeUPON PREFLIGHT, FLIGHT ATTENDANT NOTICED EMER ROW LIGHTING INOPERATIVE. INSTALLATION OF FLOOR ILLUMINATION STRIP IAW AMM 33-51-01. NO FURTHER DEFECTS NOTED. INSTALLATION COMPLETE.SDR REXA2015083100845Battery Pack · dischargedFIRST OFFICER EMER FLASHLIGHT RED LED LIGHT NOT BLINKING. R & R FLASHLIGHT BATTERY PACK IAW AMM 256100. OPERATIONS TESTED GOOD.SDR REXA2015082900839Pcu · malfunctionedOUTBOARD SPOILERONS & OTBD SPOILERS CAUTION MSG. LT OTBD SPOILERON DEPLOYED & YELLOW COLOR ON DISPLAY. RT OTBD SPOILERON WHITE COLOR ON DISPLAY. R & R ON LT WING LT OTBD SPOILER PCU. OPERATIONAL TEST & LEAK CHECK GOOD IAW AMM 27-62-01-400-801.SDR REXA2015042700431Light · brokenSEGMENT OF FLOOR TRACK LIGHTING ON THE LT SIDE OF THE FWD FIRST CLASS CABIN BROKE OFF DURING BOARDING, INSTALLED FWD LT GALLEY EMER LIGHTING IAW AMM 33-51-01.SDR REXA2015041700418Fuse · blownEMERGENCY LIGHT EXIT SIGN, AT PAX DOOR & SERVICE DOOR INOPERATIVE. R & R FUSE BOTTOM ON NR 1 BATTERY CHARGER IAW AMM 33-51-17. OPERATIONS CHECKED GOOD. R & R REPLACED NR 1 EMER LIGHT BATTERY PACK IAW AMM 33-51-17.SDR REXA2015041700417Screw · brokenEXTERNAL LT AFT OVERWING EMER LIGHT ASSEMBLY HAS SCREW BROKEN OFF IN LENS COVER ATTACHMENT NUTPLATE. R & R LT OVERWING EMER LIGHT ASSEMBLY, DS102, IAW AMM 33-51-15. OPERATIONAL CHECKED GOOD.SDR REXA2015041700416Fuse · blownROW 12CD LOWER EXIT LIGHT INOPERATIVE & LT WING OVERWING CTR LIGHT INOPERATIVE. REPLACED FUSE F3 ON ELBP NR 5. REINSTALLED BATTERY ASSEMBLY IAW AMM 33-51-17.
Back to N937XJ