N917XJ
Service difficulty reports · 245
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 = 'N917XJ' 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 = 'N917XJ' 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 REXA2018122851331Seat Track · corrodedSEAT TRACK THAT SITS ON LBL 9 HAS CORROSION SPOTS BETWEEN FS 985 AND
FS 1000, IN THE AFT CARGO BAY.
REMOVED AND REPLACED SEAT TRACK. I.A.W. CRJ-900 AMM 53-00-49 SEAT
TRACK WAS LOCATED, DRILLED AND COUNTERSUNK ON WORK SDR REXA201812281323Stiffener · corrodedSTIFFENER ON PNL 196DR HAS NUMEROUS PULLED FASTENERS
REPLACED FASTENER ON STIFFENER FOR PANEL 196DR
I.A.W. CRJ-900 SRM 51-42-10
AAR SM-58SDR REXA2018122841332Seat Track · corrodedRH AISLE SEAT TRACK STICK 4 HAS CORROSION, IN THE CABIN.
REMOVED AND REPLACED SEAT TRACK I.A.W. CRJ-900 AMM 53-00-49. SEAT
TRACK MADE ON CARD 6764486/1016449 2000 0219SDR REXA201812281322Seat Track · corrodedRH SIDEWALL SEAT TRACK CHANNEL UPPER AND LOWER FLANGES HAVE CORROSION
SPOTS BETWEEN FS 785.15 AND FS 842+48, IN THE CABIN.
REMOVED AND REPLACED SEAT TRACK CHANNEL I.A.W. CRJ-900 SRM 51-41-02SDR REXA2018122831329Seat Track · corrodedRH SIDEWALL SEAT TRACK CHANNEL UPPER AND LOWER FLANGES HAVE CORROSION
SPOTS BETWEEN FS 693 AND FS 720, IN THE CABIN.
R&R SIDEWALL SEAT TRACK CHANNEL IAW CRJ-900 SRM 51-41-02
SDR REXA2018122831328Seat Track · corrodedRH SIDEWALL SEAT TRACK STICK 5 HAS CORROSION, IN THE CABIN.
R&R SEAT TRACK IAW CRJ 900 AMM 53.00.49
SDR REXA2018122811327Seat Track · corrodedRH SIDEWALL SEAT TRACK STICK 6 HAS CORROSION, IN THE CABIN.
REMOVED AND REPLACED R/H STICK #6 TRACK IAW CRJ 900 AMM 53-00-49
SDR REXA201812281326Seat Track · corrodedRH SIDEWALL SEAT TRACK STICK 3 HAS CORROSION, IN THE CABIN.
REMOVED AND REPLACED SEAT TRACK IAW CRJ-900 AMM 53-00-49
SDR REXA2018122811325Seat Track · corrodedLH SIDEWALL SEAT TRACK STICK 4 HAS CORROSION, IN THE CABIN.
REMOVED AND REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49SDR REXA2018122801324Seat Track · corrodedLH SIDEWALL SEAT TRACK STICK 9 HAS CORROSION IN THE CABIN
REMOVED AND REPLACED #9 L/H IAW CRJ 900 AMM 53-00-49, STEP 424
SDR REXA201812281321Seat Track · corrodedRH AISLE SEAT TRACK STICK 3 HAS CORROSION, IN THE CABIN.
REMOVED/REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49
SDR REXA201812281320Seat Track · corrodedLH AISLE SEAT TRACK STICK 3 HAS CORROSION, IN THE CABIN.
REMOVED/REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49
SDR REXA201812281319Seat Track · corrodedRH SIDEWALL SEAT TRACK STICK 8 HAS CORROSION, IN THE CABIN.
REMOVED/REPLACED SEAT TRACK IAW CRJ 900 AMM 53-00-49
AAR AP-225SDR REXA2018010300005Light · brokenEMERGENCY LIGHT ASSY ABOVE SERVICE DOOR FOUND BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY. OPS CHECKED GOOD IAW AMM 33-51-05.SDR REXA2017021600238Flashlight · inoperativeF.O'S FLASHLIGHT IS INOPERATIVE. R & R THE FLASHLIGHT IAW AMM 25-61-02 OPS CHECKED GOOD.SDR REXA2017012900129Light · missingEMERGENCY FLOOR TRACK LIGHT STRIP MISSING AT 13CD. REPLACED EMERGENCY FLOOR TRACK LIGHT STRIP AT 13CD IAW AMM 33-5
1-01.SDR REXA2016122902520Mount · crackedEXTERNAL POWER RECEPTACLE MOUNT STRUCTURE IS CRACKED AROUND FASTENERS HOLES AND LOWER RADIUS. REMOVED AND INSTALLED A NEW SERVICEABLE POWER RCEPTACLE MOUNT STRUCTURE IAW SRM 51-42-06-001-001-A01 & 51-42-13-001-001-A01. OPS TESTED GOOD. REMOVED & REINSTALLSDR REXA2016122802519Wire · brokenFWD RT OVERWING EMERGENCY LIGHT DOES NOT COME ON. FOUND A BROKEN WIRE. REMOVED AND REPLACED THE CONTACT WHERE THE WIRE FAILED IAW ESPM 20-16-05. OP TESTED GOOD IAW AMM 33-51-00-710-802-A16.SDR REXA2016122802507Intercostal · corrodedNLG JACK FITTING INTERCOSTALS CORRODED. REPLACED THE INTERCOSTALS IAW SRM 51-42-06-001-001-A01 AND EA CRJ953-05153.SDR REXA2016122302515Frame · corrodedSTUB FRAME CORRODED AT BS 549 ABOVE FWD CARGO DOOR CUTOUT. REPAIRED THE FRAME IAW EA CRJ953-05164 REV IR.SDR REXA2016122302514Intercostal · corrodedSTRINGER 20L INTERCOSTAL FROM BS 319.70 - 333 IS CORRODED. REMOVED AND REPLACED IAW SRM 51-42-06-001-001-A01, 51-40-11-001-001-A01, 51-25-01-001-001-A01, AND 51-25-11-001-001-A01.SDR REXA2016122302508Striker · corrodedSERVICE DOOR LOWER SILL STRIKER IS CORRODED ALONG ENTIRE LENGTH AROUND FASTENER HOLES. REMOVED AND REPLACED THE STRIKER IAW SRM 51-4-11-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2016122202516Frame · corrodedSTUB FRAME CORRODED AT BS 533 ABOVE FWD CARGO DOOR CUTOUT. REPAIRED THE FRAME IAW EA CRJ 953-05164 REV IR.SDR REXA2016122102518Seat Track · corrodedAFT CABIN FLOOR SEAT TRACK CORRODED 3 BS 773 - 977. REMOVED, FABRICATED AND INSTALLED THE SEAT TRACK IAW AMM 53-00-49-000/-400-801 AND REO 670-53-00-343 REV M.SDR REXA2016122102517Seat Track · corrodedAFT CABIN RIGHT SEAT TRACK AT RBL 9 CORRODED BS 773 - 977. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW AMM 53-00-49-000/400-801-A07 AND REO 670-53-00-343.SDR REXA2016121902513Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED ABOVE PULLEY BRACKET. REPAIRED THE AFT DRAG ANGLE IAW REO 670-52-11-072 REV G.SDR REXA2016121902511Access Panel · chafedRIGHT WING ACCESS PANEL 684EB CHAFED. LOCATED AND DRILLED NEW SERVICEABLE FLAP PANEL 684EB IAW SRM 51-40-11-001-001-A01.SDR REXA2016121902510Access Panel · chafedLEFT WING ACCESS PANEL 584GB CHAFED. LOCATED AND DRILLED NEW SERVICEABLE ACCESS PANEL 584GB IAW SRM 51-40-11-001-001-A01.
SDR REXA2016121802509Angle · corrodedANGLE CORRODED. REMOVED AND THE BS 280 ANGLE IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2016121702512Access Panel · chafedRT WING ACCESS PANEL 684GB CHAFED. LOCATED, DRILLED A NEW ACCESS PANEL IAW SRM 51-40-11-001-001-A01.SDR REXA2016111902256Oxygen Mask · inoperativePILOT OXYGEN MASK INOPERATIVE. R & R THE PILOT OXYGEN MASK IAW AMM 35-11-12. OPS CHECKED GOOD.
"SDR REXA2016072201404Motor · failedFLAP FAIL CAUTION MESSAGE. REPLACED THE NR 1 FLAP PDU MOTOR IAW AMM 27-52-41.SDR REXA2016071301287Light · unsecureGALLEY EMERGENCY LIGHT UNSECURE. SECURED THE LIGHT IAW 33-51-01. OK FOR SERVICE.SDR REXA2016062501150Pbe · unserviceableFLIGHT DECK PBE IS SOFT AND SQUISHY, NO LONGER VACUUM SEALED. DOT IS BLUE BUT DOES NOT PASS CFM GUIDANCE. R & R FLT DECK PBE IAW JOB CARD 900-25-900-902. PN OFF/ON:MR-10042NO SN OFF/ON.SDR REXA2016052900953Flashlight · inoperativeFLIGHT ATTENDANT NOTED AFT FLASHLIGHT NOT BLINKING. MX & DISPATCH NOTIFIED. R & R FLASHLIGHT MOUNTING BRACKETS IAW CRJ900 AMM 25-61-00.SDR REXA2016041800605Strip · brokenEMERGENCY LIGHTING REFLECTIVE STRIP NEAR FWD LAVATORY IS BROKEN & LOOSE. SECURED STRIP IAW AMM 33-51-01.SDR REXA2016021800234Flashlight · inoperativeEMERGENCY FLASHLIGHT INOPERATIVE IN THE GALLEY SECTION. R & R GALLEY EMER FLASHLIGHT IAW AMM 25-61-02. OK FOR SERVICE.SDR REXA2015083000843Connector · defectiveWHILE CLIMBING THROUGH 28000, RECEIVED A LT BLEED DUCT WARNING. IT PERSISTED FOR MORE THAN 30 SEC, WHICH LED TO AN UNPRESSURIZED LANDING. FOLLOWED NON-NORMAL CHECKLIST FOR LT BLEED DUCT 8-252 & UNPRESSURIZED LANDING 8-256. DEFERRED LT AIR LEAK DETECTION SYSSDR REXA2015082700822Light · inoperativeRIGHT AFT EXTERIOR EMER LIGHT INOPERATIVE. OK TO DEFER IAW MEL 33-51-2A CAT C. R & R RT AFT EXTERIOR EMER LIGHT IAW CMM 33-52-01. PERFORMED OPERATIONS TEST OF EXTERIOR EMER LIGHT IAW AMM 33-51-15. OPERATIONS CHECKED GOOD AT THIS TIME. THIS ACTION CLEARS CSDR REXA2015073000765Wire · damagedTASK CARD ROUTINE 900, LEFT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. SPLICED DAMAGED POWER WIRE, YAH8999-22, IAW ESPM REPAIR 9. R & R THE LEFT AFT OVERWING EMERGENCY LIGHT IAW AMM 33-51-15-000-801-A08 & 33-51-15-400-801-A08. PERFORMED OPERATIONS TEST OF THSDR REXA2015072900758Glowstrip · damagedTASK CARD 900-53-230-500 GALLEY SERVICE DOOR SURROUND PANEL 232AZ & BZ HAS A DAMAGED PHOTO LUMINESCENT LIGHT STRIP. R & R PHOTO LUMINESCENT STRIP ON PANEL 232AZ & BZ IAW AMM 20-60-04.SDR REXA2015072800754Fitting · corrodedTASK CARD 900-53-230-504 CORROSION DAMAGE AT FS 319.00 ON FITTING STRAP AT THE FLOOR LEVEL JUST FORWARD OF THE SERVICE DOOR. R & R FITTING FS 319 RIGHT FRAME AT FLOOR LEVEL IAW SRM 51-42-21.SDR REXA2015072800753Spigot · wornTASK CARD 900-54-430-300 LEFT ENGINE AFT TRANS COWL LATCH ACCESS DOOR SPIGOT & GUIDE BRACKET. EVALUATED LEFT AFT TRANS COWL LATCH ACCESS GUIDE & FOUND WEAR TO PRIMER ONLY. APPLIED PRIMER TO GUIDE BRACKET IAW SRM 51-25-06-001-001-A01. R & R LEFT AFT TRANS COSDR REXA2015072700749Skin · gougedTASK CARD 900-54-430-300 LEFT ENGINE PYLON, LOWER AFT HINGE FAIRING 433BB GOUGED ON AFT END. REPLACED LEFT ENGINE PYLON LOWER AFT HINGE FAIRING SKIN IAW SRM 51-42-06 & 54-12-01.SDR REXA2015072700748Skin · crackedTASK CARD 900-54-420-500 RIGHT TOP COWL AFT HINGE LINE FAIRING CRACKED. R & R RIGHT TOP COWL AFT HINGE LINE FAIRING SKIN IAW SRM 51-40-11, 51-42-13 & 51-42-06.SDR REXA2015072500752Floor Support · corrodedTASK CARD CR LIGHT CORROSION FOUND AT PASSENGER DOOR ON FLOORBOARD SUPPORT ANGLES. R & R MID & AFT CAP ANGLES AT PASSENGER DOOR CUT OUT IAW SRM 51-41-02, SRM 51-40-11 & SRM 51-42-13.SDR REXA2015072500744Skin · damagedTASK CARD C1 PANEL SHEET LEFT UPPER HINGE LINE FAIRING IS DAMAGED ON AFT END. R & R SKIN ON LEFT UPPER HINGE LINE FAIRING IAW SRM 51-42-06 & 51-40-11. DEPTH GAUGE EXQS121.SDR REXA2015072400757Liner · damagedTASK CARD 900-52-830-306 LEFT AFT OVERWING EMERGENCY EXIT DOOR LINER HAS COMPOSITE DAMAGE TOP CORNERS. REPAIRED LEFT AFT OVERWING EMERGENCY EXIT DOOR LINER IAW CMM 25-6000-1 SEC 15.SDR REXA2015072300759Antenna · erodedTASK CARD 900-53-900-317 ELT ANTENNA HAS EROSION. R & R THE ELT ANTENNA IAW AMM 25-62-01-000-801-A03 & 25-62-01-400-801-A03. PERFORMED FUNCTION CHECK OF THE ELT SYSTEM IAW AMM 25-62-00-720-801-A01. FUNCTION CHECKED GOOD.SDR REXA2015072300751Floor Support · corrodedTASK CARD 900-53-900-504 CORROSION UNDER MOST FORWARD RIGHT FLOORBOARD NEAR FLOOR SILL & SERVICE DOOR FS 319. INSTALLED NEW FORWARD RIGHT FLOORBOARD SUPPORT ANGLE IAW SRM 51-42-06 & 53-21-27. REMOVED & REINSTALLED DOOR STOP IAW AMM 53-21-27.
Back to N917XJ