N927XJ
Service difficulty reports · 193
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 = 'N927XJ' 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 = 'N927XJ' 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 REXA2019081201372Seat Track · corrodedINITIAL INSPECTION: CORROSION AND WEAR ON SIDE SEAT RAIL FS669.4 TO FS977.00 STR 15R (SM)TCI: 53-20-233 SUMMARY OF NRC:00170; CORROSION LEVEL # 2 AND WEAR ON SIDE SEAT RAIL FS669.4 TO FS977.00 STR 15R. SIDE SEAT RAIL FS669.4 TO FS977.00 STR 15R WERE REPLACED PSDR REXA2019081201370Seat Track · corrodedINITIAL INSPECTION: CORROSION AND WEAR ON SIDE SEAT RAIL FS669.4 TO FS977.00 STR 15L (SM)TCI: 53-20-233 SUMMARY OF NRC:00169 CORROSION LEVEL # 2 AND WEAR ON SIDE SEAT RAIL FS669.4 TO FS977.00 STR 15L. SIDE SEAT RAIL FS669.4 TO FS977.00 STR 15L WERE REPLACED PESDR REXA2019081201364Seat Track · corrodedINITIAL INSPECTION: WEAR AND CORROSION ON SEAT RAILS FS280 TO 693.00 ABOVE FLOOR LEFT SIDE. (SM) SUMMARY OF NRC:00177 WEAR AND CORROSION LEVEL # 2 ON SEAT RAILS FS280 TO 693 ABOVE FLOOR LEFT SIDE. SEAT RAIL FS280.00 TO FS693.00 ABOVE FLOOR LEFT SIDE WERE REPLASDR REXA2019081201356Seat Track · corrodedINITIAL INSPECTION: CORROSION AND WEAR ON SIDE SEAT RAIL FS379.00 TO FS669.40, STR 15R (SM)TCI: 53-20-217. SUMMARY: SIDE RAIL ON FS379.00 TO FS669.40, STR 15R WERE REPLACED PER AMM 53-00-49-400-801 (CONFIG A07). LEVEL CORROSION II.SDR REXA2019081201345Fitting · wornINITIAL INSPECTION : WEAR ON FWD/AFT FITTINGS (4 EA) PROJECTION STR 21L AT FWD / CENTRAL CARGO DOORS SURROUND STRUCTURE ( FUS )
SUMMARY OF NRC 00171: FWD/AFT FITTINGS (4 EA) PROJECTION STR 21L AT FWD / CENTRAL CARGO DOORS SURROUND STRUCTURE WERE REPLACED PER SDR REXA2019081101374Floor Support · corrodedINITIAL INSPECTION: CORROSION ON FLOOR SUPPORT FS280 BTW STR 24R AND STR 24L AT MAIN AVIONICS COMPARMENT. (SM)TCI: 100-09 SUMMARY OF NRC 00146, CORROSION LEVEL-2: FLOOR SUPPORT ON FS280 BTW STR 24R AND STR 24L AT MAIN AVIONICS COMPARMENT WAS REPLACED PER SRM 5SDR REXA2018042760320Lamp · burned outEMERGENCY EXIT SIGN, FLOOR LEVEL HAS LAMP BURNED OUT. REMOVED AND REPLACED THE LAMPS IAW 33-51-05. OPS CHECKED GOOD.SDR REXA2018032500218Battery · inoperativeCOPILOT EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED THE BATTERY IAW AMM 25-61-00SDR REXA2017062100758Battery · disconnectedFORWARD FLIGHT ATTENDANT FLASHLIGHT RED LIGHT NOT FLASHING. CONNECTED THE BATTERY IAW CMM-25-60-11. OPS CHECKED GOOD IAW AMM-25-61-00.SDR REXA2017062100757Flashlight · inoperativeFORWARD FLIGHT ATTENDANT FLASHLIGHT ASSY IAW AMM 25-61-02. REPLACED THE FLASHLIGHT ASSY IAW AMM 25-61-02.SDR REXA2017051300598Fitting · corrodedFORWARD JACK FITTING AT BS 278, LEFT SUPPORT ATTACH FLANGE AND WEB CORRODED. REMOVED AND REPLACED THE FWD JACK FITTING IAW SRM 51-42-06, AND 51-42-21.SDR REXA2017051300597Fitting · corrodedFORWARD JACK FITTING AT BS 278, RIGHT SUPPORT ATTACH FLANGE AND WEB CORRODED. REMOVED AND REPLACED THE FWD JACK FITTING IAW SRM 51-42-06, AND 51-42-21.SDR REXA2017051300596Seat Track · corrodedLEFT AISLE SEAT TRACK HAS CORROSION BETWEEN BS 865 AND 977. THE SEAT TRACK WAS REPAIRED.SDR REXA2017051100595Floorbeam · crackedFLIGHT DECK FLOORBEAM AT LBL 12 CRACKED AT BACK-UP BRACKET ATTACHMENT. REMOVED AND REPLACED FLIGHT DECK FLOORBEAM IAW EO R53276.SDR REXA2017051100594Floorbeam · crackedFLIGHT DECK FLOORBEAM AT RBL 12 CRACKED AT BACK-UP BRACKET. REMOVED AND REPLACED THE FLOORBEAM IAW EO53276.SDR REXA2017051100593Frame · corrodedFRAME BS 847+32 HAS CORROSION ON THE AFT SIDE BETWEEN STRINGER 26L AND 26R, AT THE AFT CABIN, BELOW THE FLOOR. REMOVED THE CORROSION AND REPAIRED THE FRAME IAW EA CRJ953-05647.SDR REXA2017051100592Skin · corrodedWHILE REMOVING THE STRINGER SLICED 26R AT BS 333, FOUND CORROSION ON THE FUSELAGE SKIN. REMOVED DAMAGE AND REPAIRED THE SKIN IAW EA CRJ953-05653.
"SDR REXA2017051100591Stringer Splice · corrodedSTRINGER SPLICE 25R AT BS 333 CORRODED. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM 51-42-06.
"SDR REXA2017051100590Stringer Splice · corrodedSTRINGER SPLICE 21R CORRODED BS 477.2. REPAIRED THE STRINGER SPLICE IAW EA 953-05662, REV B.SDR REXA2017051100589Stringer Splice · corrodedWHILE REPLACING STRINGER SPLICE 21R AT BS 477, CORRODED. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM 51-42-06, AND 51-42-21.SDR REXA2017051100588Seat Track · corrodedRIGHT AISLE SEAT TRACK HAS CORROSION BETWEEN BS 865 AND 977. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801.SDR REXA2017051100587Seat Track · corrodedRIGHT AISLE SEAT TRACK HAS CORROSION BETWEEN BS 847 AND 865. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-400-801.SDR REXA2017050700586Angle · corrodedR1 DOOR CUTOUT LOWER SILL INBD ANGLE CORRODED FROM BS 319.7 - 347. REMOVED AND REPLACED THE ANGLE IAW SRM 51-42-06.SDR REXA2017050600585Seat Track · corrodedLT AISLE SEAT TRACK HAS CORROSION BETWEEN BS 847 AND 865. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-41-02, SRM 51-40-11, SRM 51-23-00, AND AMM 53-00-49.SDR REXA2017050600584Stringer Splice · corrodedSTRINGER SPLICE 22R AT BS 333 CORRODED. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM 51-42-06, AND 51-42-21.SDR REXA2017050400583Hinge · crackedL1 DOOR TOP STEP INBD HINGE CRACKED ON EDGE. REMOVED AND REPLACED THE HINGE IAW SRM 51-42-06.SDR REXA2017012600125Controller · malfunctionedAFTER APPLYING POWER TO AIRCRAFT FOR FIRST FLIGHT OF THE DAY, ALL PASSENGER OXYGEN MASKS DROPPED. CHECKED MDC NO FAULT REPORTED. REPLACED CABIN PRESSURE CONTROL IAW AMM 21-33-01 REPACKED PASSENGER MASKS IAW AMM 35-21-09 AND OPERATIONAL TEST PAX OXYGEN MANUAL DSDR REXA2016100301891Flap System · malfunctionedFLAP FAIL CAUTION ON RETRACTION 43 DEGREES FLAPS STOPPED , SLAT RETRACTED NORMALLY. PROCEDURE WAS PERFORMED AND MESSAGE CLEARED. PERFORMED OP CHECK OF THE FLAP AND SLAT SYSTEM IAW AMM 27-50-00. NO DEFECTS NOTED AT THIS TIME. AIRCRAFT OK FOR SERVICE. SDR REXA2016070401250Battery Pack · inoperativeCAPTAIN`S FLASHLIGHT INDICATOR DOES NOT BLINK. REPLACED BATTERY, OPS CHECKED GOOD IAW AMM 25-61-02.SDR REXA2016050100695Glowstrip · broken900-53-900-510 6Y NEW. FLOOR PHOTO LUMINESCENT LIGHT TRACK FRONT LT NR 1 IS BROKEN. R & R NR 1 LT FLOOR PHOTO LUMINESCENT LIGHT TRACK IAW AMM 33-51-01-400-801 A21.SDR REXA2016043000698Oxygen Mask · defectiveOBSERVER CREW OXYGEN MASK WILL NOT FLOW CONTINUOUSLY IN EMER OR PRESS TO TEST POSITION CONSISTENTLY. R & R OBSERVER'S CREW OXYGEN MASK IAW AMM 35-11-12-400-801 A02.SDR REXA2016043000694Angle · corrodedPASSENGER DOOR CUT OUT UPPER MID-CAP ANGLE CORRODED. CONTINUATION CARD 81518811 OP 220. R & R PAX DOOR UPPER MID-CAP ANGLE IAW SRM 51-40-06-001-001-A01, 51-40-11-001-001-A01 & 51-41-02-001-001-A01.SDR REXA2016042800693Crossbeam · corrodedCORROSION ON FS 280 CROSSBEAM UPPER FLANGE, BETWEEN RBL 9 & RBL 16. CROSSBEAM IS ALSO CRACKED, UPPER FLANGE. CONTINUATION CARD 81518811 OP 203. DRILLED, LOCATED & INSTALLED NEW FS 280 CROSSBEAM IAW SRM 51-40-11-001-001-A01, 51-42-16-001-001-A01, 51-42-22-001SDR REXA2016042600692Door Sill · corrodedPASSENGER DOOR LOWER SILL CAP ANGLE IS CORRODED FROM FS 310 - 349. R & R PAX DOOR LOWER SILL ASSEMBLY IAW SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR REXA2016042500691Housing · damagedAVIONICS DOOR HANDLE HOUSING HAS AN INDICATION ALL AROUND THE BASE OF THE HANDLE SHAFT, APPROX 100% FSH, FAILED NDT. CONTINUATION CARD 81518811 OP 195. R & R AVIONICS DOOR HANDLE HOUSING IAW SRM 51-42-21-001-001-A01.SDR REXA2016042200696Bolt · not reportedCONTINUED FROM MWC JOB 81518811 OP 24. AFT LT, FWD RT & AFT RT OVERWING EMER EXITS FAILED FUNCTIONAL TEST OF HANDLE PULL FORCE. ALL THREE IN EXCESS OF 50 LB. REPLACED 2 LOWER BOLTS ON EACH DOOR IAW SRM 51-41-02-001-001-A01. ADJUSTED DOOR IAW 52-21-00-720-8SDR REXA2016042200690Seat Track · corrodedLEFT & RIGHT FLOOR SEAT RAILS ARE CORRODED AT FS 364, RBL 9 & LBL 9. REPLACED LT & RT BL 9 SEAT RAIL IAW GREO 670-53-00-33 & AMM 53-00-49-400-01-A01.SDR REXA2016042100689Angle · corrodedFS 280 COCKPIT THRESHOLD FWD J ANGLE & SACRIFICIAL STRIP ARE CORRODED. R & R FS 280 FWD J ANGEL IAW SRM 51-42-06-001-001-A01.SDR REXA2016041800688Handle · crackedPASSENGER DOOR INNER HANDLE IS CRACKED. REMOVED DAMAGED HANDLE 600-31887-15 & INSTALLED A NEW HANDLE IAW SRM 51-77-00-001-001-A01.SDR REXA2016012900122Oxygen Mask · defectiveOBSERVERS OXYGEN MASK INFLATABLE STRAP DOES NOT INFLATE. OBSERVERS OXYGEN SYS PLACED ON MEL IAW MEL 35-10-1. MM02 UPDATED, PLACARD INSTALLED, CAT A. R & R OBSERVERS 02 MASK IAW AMM 35-11-12. OPERATIONS CHECKED GOOD. PLACARD REMOVED. PN ON & OFF MF10-08-0SDR REXA2015031700323Battery Pack · inoperativeREPEAT WRITE UP, EMERGENCY LIGHTS COME ON INTERMITTENTLY UNDER THE DIRECTION OF MOC 96096, DEFERED ACFT EMERGENCY LIGHTS IAW MEL 33-51-1A. PLACARD INSTALLED, ENTERED IN MM02. R & R BATTERY PACK, PS35, PS36 IAW AMM 33-51-17. COMPLETED TEST OF EMERGENCY LIGHTSDR REXA2015031700322Relay · inoperativeEMERGENCY LIGHTS IN THE ARM POSITION THEY ALL COME ON, EXCEPT OVERWING EXIT. R & R K198 SENSE RELAY IAW AMM 33-51-19. R & R POWER SUPPLY PS37 IAW AMM 33-51-17, OPS CHECK GOOD.SDR REXA2014090400860Light · missingEMERGENCY FLOOR TRACK LIGHTING AT SEAT 12CD MISSING. REPLACED EMER FLOOR TRACK LIGHTING STRIP AT SEAT 12CD IAW MM 33-51-01.SDR REXA2014082100819Strip · missingEMERGENCY FLOOR LIGHTING STRIP MISSING AT EMER EXIT ROW 12 SEAT CD. REPLENISHED EMER LIGHTING STRIP IAW AMM 33-51-01. PN PL88-930LH05, PL88-900LH00 & PL88-910LH00.SDR REXA2014070300647Battery · dischargedFIRST OFFICER`S FLASHLIGHT INOPERATIVE. R & R FIRST OFFICER`S EMER FLASHLIGHT BATTERY IAW AMM 25-61-02. ACFT OK FOR SERVICE.SDR REXA2014070100642Battery Pack · dischargedEMERGENCY LIGHT FWD OVERHAUL GROUP INOPERATIVE. R & R BATTERY PACK IAW JOB CARD 33-900-701. R & R EPSU BATTERY CHARGER IAW AMM 33-51-17. OPERATIONS CHECKED GOOD.SDR REXA2014052200521Rub Strip · damagedTASK CARD 900-54-430-300 FWD UPPER CORE COWL, INNER BAND, OTBD SIDE IS RUBBING ON AFT CORE COWL. METAL MISSING IN PLACES. JOB CARD 900-54-430-300 IS GVI FOR LT ENG NACELLE SMS 701035 5-22-14. REPAIRED FWD UPPER CORE COWL AFT RUB STRIP IAW SRM 54-23-00-201-SDR REXA2014052200520Rub Strip · damagedFORWARD LOWER CORE COWL, INNER BAND, OTBD SIDE IS RUBBING ON AFT CORE COWL. METAL MISSING IN PLACES. JOB CARD 900-54-430-300 IS FVI OF LT ENG NACELLE SMS 701035 5-22-14. REPAIRED FWD CORE COWL AFT EDGE RUB STRIP IAW SRM 54-23-00-201-007-A01.SDR REXA2014052100519Drag Angle · crackedMAIN PAX DOOR ON THE AFT SIDE DRAG ANGLE BY DOOR ASSIST CABLE PULLEY HAS POSSIBLE CRACK. REPAIRED MAIN PAX DOOR AFT DRAG ANGLE IAW EO R52026.SDR REXA2014052000528Panel · gougedTASK CARD 900-54-430-301 LT ENG LOWER COWL PANEL WITH 4 HOLES IN IT GOUGED. R & R INLET ASSEMBLY VENT IAW AMM 71-12-08-001-801-A01 & 71-12-08-400-801-A01.
Back to N927XJ