N936XJ
Service difficulty reports · 191
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 = 'N936XJ' 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 = 'N936XJ' 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 REXA2016101902091Stiffener · corrodedFLOORBEAM STIFFENER IS CRACKED & BENT AT RBL 12 BETWEEN BS 942 & 954. REMOVED AND REPLACED THE STIFFENER IAW SRM 51-42-21-001-001-A01 AND EA CRJ95304907.SDR REXA2016101902084Stiffener · crackedVERTICAL STIFFENER ON FWD SIDE OF FS 280 BEAM AT RBL 26 IS CRACKED. REMOVED AND REPLACED CRACKED STIFFENER IAW SRM 51-42-06-001-001-A01 & 51-42-13-001-001-A01.SDR REXA2016101902075Seat Track · corrodedCORROSION ON SEAT TRACK AT RBL 12 BETWEEN FS 847.00 AND FS 977.00 AT VARIOUS LOCATIONS. REMOVED AND INSTALLED NEW SEAT TRACKS AT RBL 9.00 BETWEEN FS 847.00 TO FS 977.00 IAW REO 670-53-00-343 REV M DATED 2015-10-19 AND SRM 51-41-02-001-001-A01 AND 53-00-49-400SDR REXA2016101902074Seat Track · corrodedCORROSION ON SEAT TRACK AT RBL 12 BETWEEN FS 847.00 AND FS 977.00 AT VARIOUS LOCATIONS. REMOVED AND INSTALLED NEW SEAT TRACKS AT RBL 9.00 BETWEEN FS 847.00 TO FS 977.00 IAW REO 670-53-00-343 REV M DATED 2015-10-19 AND SRM 51-41-02-001-001-A01 AND 53-00-49-400SDR REXA2016101902073Seat Track · corrodedRT AFT FUSELAGE SEAT RAILS 8 HAS CORROSION. REMOVED DAMAGED SEAT TRACK SEGMENT. FABRICATED NEW SERVICEABLE SEAT TRACK SEGMENT AND INSTALLED NEW SERVICEABLE SEAT TRACK SEGMENT AT FS 851.03 - FS 865.00 IAW AMM 53-00-49-000-801-A07, AMM 53-00-49-400-801-A07, SRSDR REXA2016101902072Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED AT MULTIPLE LOCATIONS BETWEEN BS 477 AND 669. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, REO 670-53-00-343 REV M AND AMM 53-00-49-000/400-801-A07.SDR REXA2016101902071Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED AT MULTIPLE LOCATIONS BETWEEN BS 477 AND 669. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, REO 670-53-00-343 REV M AND AMM 53-00-49-000/400-801-A07.SDR REXA2016101902070Seat Track · corrodedLBL 9 SEAT TRACK IS CORRODED AT MULTIPLE LOCATIONS BETWEEN BS 477 AND 669. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-11-001-001-A01, REO 670-53-00-343 REV M AND AMM 53-00-49-000/400-801-A07.SDR REXA2016101802033Angle · corrodedFLOORBEAM ANGLE BS 280 IS CORRODED. REMOVED AND REPLACED THE FLOORBEAM ANGLE IAW SRM 51-42-06-001-001-A01.SDR REXA2016101802024Stringer Splice · corrodedSTRINGER SPLICE 25R HAS CORROSION BS 333. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 AND
51-42-21-001-001-A01.SDR REXA2016101602092Seat Track · corrodedLEFT AFT FUESLAGE SEAT TRACK CORRODED. FABRICATED & INSTALLED A NEW SEAT TRACK IAW REO 670-53-00-343 REV M AND AMM 53-00-49-400-801-A07.SDR REXA2016101602066Seat Track · corrodedLEFT AFT SEAT TRACKS CORRODED. FABRICATED & INSTALLED A NEW SEAT TRACK IAW REO 670-53-00-343 REV M AND AMM 53-00-49-400-801-A07.SDR REXA2016101602065Seat Track · corrodedLEFT AFT FUESLAGE SEAT TRACK CORRODED. FABRICATED & INSTALLED THE SEAT TRACKS IAW REO 670-53-00-343 REV M AND AMM 53-00-49-400-801-A07.SDR REXA2016101602042Seat Track · corrodedSEAT TRACK AT RBL 9, BS IS CORRODED BETWEEN BS 349 - 379. REMOVED, FABRICATED & INSTALLED A SERVICEABLE SEAT TRACK IAW AMM 53-00-49-000/400-801-A07, REO 670-53-00-343, SRM 51-40-11-001-001-A01, 51-21-11-001-001-A01, AND 51-21-16-001-001-A01.SDR REXA2016101402077Seat Track · corrodedCORROSION ON SEAT TRACK AT LBL 12 BETWEEN BS 847 AND 977 AT VARIOUS LOCATIONS. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-07, SRM 51-40-11-001-001-A01 AND REO 670-53-00-343 REV M.SDR REXA2016101402076Seat Track · corrodedCORROSION ON SEAT TRACK AT LBL 12 BETWEEN BS 847 AND 977 AT VARIOUS LOCATIONS. 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 REXA2016101402060Angle · corrodedPAX DOOR MID CAP ANGLE IS CORRODED BETWEEN BS 310 - 349. REMOVED CORRODED PAX DOOR MID CAP ANGLE AND INSTALLED SERVICEABLE ANGLE IAW SRM 51-40-11-001-001-A01 AND AMM 20-21-00-910-801-A01.SDR REXA2016101402059Seat Track · corrodedLEFT FWD SEAT TRACK CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, 51-40-11-001-010-A01 & REO 670-53-00-343 REV M.SDR REXA2016101402058Seat Track · corrodedLEFT FWD SEAT TRACK CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07, 51-40-11-001-010-A01 & REO 670-53-00-343 REV M.SDR REXA2016101402034Panel · chafed699AB IS CHAFED. RECEIVED SERVICEABLE PART. LOCATED, DRILLED AND COUNTERSUNK IAW SRM 51-40-11-001-001-A01.SDR REXA2016101302078Seat Track · corrodedRBL 9 FLOOR SEAT TRACK IS CORRODED AT BS 669 AND 613. REMOVED FABRICATED AND INSTALLED THE SEAT TRACK IAW REO 670-53-00-843 REV M AND AMM 53-00-49-400-801-A07.SDR REXA2016101102041Seat Track · corrodedSEAT TRACK SEGMENT AT LBL 9 IS CORRODED BETWEEN BS 373 TO 379. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801-A07 AND REO 670-53-00-343.SDR REXA2016060700978Battery · dischargedFLIGHT ATTENDANT REPORTS XFA JUMP SEAT FLASHLIGHT BATTERY INOPERATIVE. R & R FLASHLIGHT & HOLDER IAW AMM 25-61-02. OPERATIONS CHECKED GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR REXA2015091600129Skin · dentedPERMANENT REPAIR OF THE RT FLAP LOWER SKIN. DENT MEASURES 1.34” X 1.29” X 0.020” DEEP & LOCATED AT APPROX FS 36.00, BETWEEN THE AFT SPAR & INTERCOSTAL SPAR. REPAIRED IAW EA CRJ957-03678.SDR REXA2015083100840Detector · malfunctionedFLAP FAIL CAUTION, FLAP FAIL 9 DEGREES, SLATS 0 DEGREES, LNG WGT 74500 & SPEED 180 KTS. R & R LHIB SKEW DETECTOR IAW AMM 27-52-45. OPERATIONS CHECKED GOOD.SDR REXA2015083100825Battery Pack · dischargedCOPILOT FLASHLIGHT INOPERATIVE. R & R FIRST OFFICERS EMER FLASHLIGHT BATTERY PACK IAW CMM 25-60-02. OPERATIONS CHECKED GOOD.SDR REXA2015050800467Cover · missingAFT EMER NOTICE SIGN, RED & YELLOW LIGHT FILTERS MISSING IN AFT CABIN. DEFERRED YELLOW LENS COVER IAW MEL 23-40-1N. MX NOTIFIED, PLACARD INSTALLED. REPLACED MISSING EMER LT COVER IAW AMM 33-51-07. OPERATIONS CHECKED GOOD. THIS CLEARS MEL, MM02 UPDATED & SDR REXA2015031600321Light · unsecurePHOTO LUMINESCENT STRIP EXIT ROW 12B CAME OFF. RESECURED EMERGENCY FLOOR STRIP AT ROW 12B IAW AMM 25-60-00.SDR REXA2015022700270Heater · failedCABIN & COCKPIT HAD STRONG ODOR OF EXHAUST FUMES DURING FLIGHT. FUMES PERSISTENT AFTER LANDING. R & R GALLEY HEATER IAW AMM 21-23-64.SDR REXA2014101401035Lens · missingSERVICE DOOR EXIT LIGHT LENS COVER IS MISSING. INSTALLED EXIT SIGN LENS IAW AMM 33-51-05. PART ON BC5-0393-288, SERIAL N/A.SDR REXA2014100101027Panel · chafedPANEL 622CB CHAFED ON LE. DRILLED UP NEW PANEL IAW SRM 51-40-11-001-001-A01. PANEL TO BE INSTALLED ON OPERATION 192.SDR REXA2014100101010Fuse · failedTASK CARD 900-53-140-509 FLIGHT ATTENDANT STATION G1 & G2 EMER EXIT FLOOR LEVEL LIGHTS INOPERATIVE 15. DURING TROUBLE SHOOTING FOUND FUSE F3 ON EMER BATTERY CHARGER FAILED. REPLACED FUSE IAW CMM RE 25-60-03. REMOVED & REINSTALLED EMER BATTERY CHARGER NR 1 ISDR REXA2014093001026Bracket · wornNUMBER 2 ENG AFT CORE COWL ALIGNMENT STANDOFF BLOCK AT 3 O'CLOCK POSITION HAS WORN ALIGNMENT FINGER. REMOVED REPAIR STRIPS FROM NR 2 CORE COWL. R & R STANDOFF ALIGNMENT BRACKET. REINSTALLED WEAR STRIPS ON NR 2 CORE COWL IAW SRM 51-42-06-001-001-A01 & AMM 54SDR REXA2014093001025Access Panel · chafedRIGHT WING INBD FLAP ACCESS PANEL 684EB SHOWS CHAFE DAMAGE. CHECKED LIMITS IAW SRM 57-52-01-101-001-A01 PART OUT OF LIMITS. DRILLED NEW PANEL 684EB IAW SRM 51-40-11-001-A01.SDR REXA2014093001024Fairing · chafedRIGHT HINGE LINE FAIRING 443B CHAFED. REPLACED & DRILLED NEW SKIN HINGE FAIRING. REATTACHED STIFFENERS, PAINTED IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01 & 51-25-01-001-001-A01.SDR REXA2014092901023Access Panel · chafedRIGHT WING INBD FLAP VANE ACCESS PANEL 684ET SHOWS CHAFE DAMAGE. DRILLED UP NEW PANEL 684ET & INSTALLED RIVETS IAW SRN 51-42-06-001-001-A01. OLD PANEL OUT OF LIMITS IAW SRM 57-52-01-101-001-A01. PANEL TO BE INSTALLED.SDR REXA2014092901022Access Panel · chafedLEFT WING INBD FLAP VANE ACCESS PANEL 584ET SHOWS CHAFE DAMAGE. DAMAGE FOUND TO BE OUT OF LIMITS ON PANEL 584ET IAW SRM 57-52-01-101-001-A01. LOCATED & DRILLED FASTENER HOLES IN NEW PANEL IAW SRM 51-40-11-001-001-A01. PAINTED NEW PANEL IAW SRM 51-25-01-001-SDR REXA2014092901021Support Channel · looseMAIN LANDING GEAR FAIRING RT VERTICAL SUPPORT CHANNEL IS LOOSE WHERE IT SECURES TO THE LOWER SUPPORT CHANNEL DUE TO ATTACH SCREW PULLING THROUGH THE VERTICAL SUPPORT CHANNEL. REMOVED RT MLG VERTICAL SUPPORT CHANNEL. REPLACED, MATCH DRILLED & INSTALLED NEW RTSDR REXA2014092801020Housing · crackedAVIONICS BAY DOOR HANDLE HOUSING CRACKED AROUND THE HANDLE. REMOVED AVIONICS DOOR IAW AMM 52-42-00-000-801-A01. REMOVED AVIONICS DOOR HANDLE IAW 52-42-03-000-801-A01. LOCATED & DRILLED NEW HANDLE HOUSING IAW SRM 51-42-21-001-001-A01 & 51-40-11-001-001-A01.SDR REXA2014092701019Support Channel · looseMAIN LANDING GEAR FAIRING LT VERTICAL SUPPORT CHANNEL IS LOOSE WHERE IT SECURES TO THE LOWER SUPPORT CHANNEL. SUSPECT VERTICAL SUPPORT CHANNEL FASTENER HOLE IS WORN. PN CC670-85500-1 DWG CC 670-85500. REMOVED, DRILLED & INSTALLED NEW VERTICAL SUPPORT CHANNESDR REXA2014092601018Access Panel · damagedC1 RT WING INBD FLAP ACCESS PANEL 684GB SHOWS CHAFE DAMAGE. PANEL DAMAGE IS BEYOND LIMITS MATCH DRILLED NEW PANEL, PANEL WILL BE INSTALLED ON TALLY CARD 302 IAW SRM 57-52-01-101-001-A01 & 51-40-11-001-001-A01.SDR REXA2014092601017Panel · chafedLEFT PYLON HINGE FAIRING CHAFED. REPLACED LT PYLON HINGE FAIRING PANEL 433BB WITH NEW SKIN IAW SRM 51-42-06-001-001-A01 & 51-42-13-001-001-A01.SDR REXA2014092200988Lens · crackedTASK CARD 900-53-900-308 LT & RT FWD EMER LIGHT LENS COVER CRACKED. R & R WITH SERVICEABLE ONES IAW CMM 33-52-07 PG 3 SECT 3 1 A & PG 4 SECT 7 B.SDR REXA2014092200987Cover · crackedTASK CARD 900-53-900-107 LT & RT AFT EMER LIGHT COVERS CRACKED. R & R WITH SERVICEABLE ONES IAW CMM 33-52-07 PG 3 SECT 3 1 A & PG 4 SECT 7 B.SDR REXA2013121302222Valve · defectiveGEAR DISAGREE WARNING ON EICAS, NOSE GEAR WOULD NOT LOCK IN UP POSITION, FOLLOWED CRJ900 POM NON-NORMAL. RAMP WAS CONTAMINATED, RUNWAY ONLY SLIGHTLY WITH PACKED SNOW. GEAR WAS CHECKED AFTER LANDING IN GRR & APPEARED FREE OF CONTAMINANTS.
FOUND NLG STRUT FLSDR REXA2013120302209Acm · seizedCABIN & COCKPIT FILLED WITH SMOKE AFTER APU STARTED NR 1 PACK AUTO FAIL DISPLAYED. DEFER COCKPIT TEMP CONTROL SYS IAW MEL 21-61-14. CAT C, MC ADVISED 96041. ENTERED INTO MMO2, PLACARD INSTALLED. INVESTIGATED CTRL 2481268-1 NR 1 LT AUTO PACK FAIL, SMOKE IN CSDR REXA2013090401624Flashlight · inoperativeAFT F/A FLASHLIGHT IS INOPERATIVE. R & R F/A FLASHLIGHT, IAW AMM 25-61-01.SDR REXA2013071201297Pbe · failedFLIGHT DECK PBE HAS LOST ITS VACUUM SEAL. R & R PBE SMOKE HOOD IAW JC 900-25-900-902. ACFT OK FOR SERVICE.SDR REXA2013040800515Doubler · corrodedE/E BAY TCAS ANTENNA DOUBLER BETWEEN FS 295-310 HAS CORROSION. REMOVED AND REPLACED TCAS ANTENNA DOUBLER BETWEEN FS 293-310 E & E BAY IAW CRJ 900 SRM 51-42-06.SDR REXA2013040700513Seat Track · corrodedLEFT SIDE SEAT TRACK 4 CORRODED/GOUGED. REMOVED UNSERVICABLE NR 4 LEFT SIDE SEAT TRACK AND INSTALLED SERVICABLE TRACK IAW CRJ 900 AMM 53-00-43.
Back to N936XJ