N903XJ
Service difficulty reports · 234
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 = 'N903XJ' 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 = 'N903XJ' 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 REXA2018032000206Oxygen Mask · damagedFIRST OFFICER`S OXYGEN MASK STRAP HAS A HOLE IN THE BACK SIDE. REMOVED AND REPLACED THE OXYGEN MASK IAW AMM 35-11-12. OPS CHECKED GOOD.SDR REXA2018030500178Light · missingROW 13 EXIT ROW EMERGENCY LIGHT MISSING. REPLACED EMERGENCY LIGHT STRIP IAW AMM 33-51-01.SDR REXA2017122301288Megaphone · inoperativeMEGAPHONE INOPERATIVE. R & R THE MEGAPHONE IAW AMM 25-61-14.SDR REXA2017121301241Flashlight · inoperativeCAPTS EMERGENCY FLASHLIGHT RED LIGHT NOT BLINKING.
REPLACED CAPTS EMERGENCY FLASHLIGHT BATTERY WITH SERV. UNIT. PN OFF/ON
94-01-0021. OP TEST GOOD IAW CRJ900 AMM 25-61-00.SDR REXA2017111201165Battery · inoperativePILOTS EMERGENCY FLASHLIGHT IS INOPERATIVE. R & R THE BATTERY IAW CMM 25-60-11. OPS CHECKED GOOD.SDR REXA2017083100956Oxygen Mask · malfunctionedFO REPORTED THE OXYGEN MASK DOESN'T INFLATE PROPERLY. REMOVED & REPLACED THE OXYGEN MASK IAW AMM 35-11-12. CHECKED GOOD.SDR REXA2017080100848Relay · defectiveEMER LIGHT ON STATUS THE LIGTHS ARE TURNING ON & OFF THE WHOLE TIME. REMOVED AND REPLACED EMERGENCY LIGHTS RELAY IAW AMM 33-51-19. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR REXA2017061100705Battery · inoperativeAFT EMERGENCY FLASHLIGHT NOT CHARGING. R & R AFT FLASHLIGHT BATTERY IAW CMM 25-60-02.
"SDR REXA2017060500681Angle · corrodedSTRINGER 21R JOINT PIECE BETWEEN BS 379 AND 394 CORRODED. REMOVED AND REPLACED THE STRINGER JOINT PIECE IAW SRM 51-42-06, OPS CHECKED GALLEY/LAV EXHAUST FAN AMM 21-23-93-710-801, CHECKED BAD GALLEY HEATER IAW AMM 21-23-64-400-801 CHECK GOOD LEAK TEST OF EXHASDR REXA2017060500680Stringer · corrodedSTRINGER 23R HAS CORROSION BETWEEN BS 333 AND 280, IN THE FWD E & E BAY. REPAIRED THE STRINGER IAW EA 953-05722.SDR REXA2017060400679Stringer · corrodedSTRINGER 21R HAS CORROSION BETWEEN BS 349 AND 379 IN THE FWD E & E BAY. REPAIRED THE STRINGER IAW EA 953-05726.SDR REXA2017060400678Stringer · corrodedSTRINGER 20R HAS CORROSION BETWEEN BS 364 AND 379, IN THE FWD E & E BAY. REPAIRED STRINGER 20R IAW EA 953-05725.SDR REXA2017060300695Contact · brokenLEFT AFT OVERWING LIGHT CONNECTOR HAS A BROKEN CONTACT. REPAIRED THE CONTACT IAW ESPM 20-16-00, STEP 5C(1)-(14). OPS TESTED GOOD IAW AMM 33-51-15-710-801.SDR REXA2017060300674Diaphragm · corrodedDIAPHRAM THAT SITS ON TOP OF STRINGER 26R HAS CORROSION BETWEEN BS 364 AND 349, IN THE FWD E & E BAY. REMOVED AND REPLACED THE DIAPHRAM IAW SRM 51-42-21, & 51-42-06 .SDR REXA2017060100677Stringer · corrodedSTRINGER 26R HAS CORROSION BETWEEN BS 349 AND 333, IN THE FWD E & E BAY. REMOVED & REPLACED THE STRINGER IAW SRM 51-42-06, & 51-42-21.SDR REXA2017060100676Diaphragm · corrodedDIAPHRAM THAT SITS ON TOP OF STRINGER 26L HAS CORROSION BETWEEN BS 364 AND 349, IN THE FWD E & E BAY. REMOVED & REPLACED THE DIAPHRAM IAW SRM 51-42-21, & 51-42-21.SDR REXA2017060100675Stringer Splice · corrodedSTRINGER SPLICE 26R HAS CORROSION AT FRAME 333, IN THE FWD E & E BAY. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM 51-42-06, & 51-42-21.SDR REXA2017052900673Support Bracket · crackedAFT CARGO DOOR FRAME AFT LOWER TRACK SUPPORT IS CRACKED. REMOVED AND REPLACED THE TRACK SUPPORT BRACKET IAW SRM 51-42-06.SDR REXA2017052900670Guard · crackedRIGHT MLG WHEEL WELL LOWER SPASH GUARD PLATE IS CRACKED. REMOVED AND REPLACED THE RT MLG WELL LOWER SPLASH GUARD IAW SRM 51-42-02.SDR REXA2017052800672Post · corrodedBS 280 DOOR POST HAS CORROSION AT LBL 12 JUST ABOVE FLOOR LEVEL. CUT OUT DAMAGE AND INSTALL A REPAIR IAW REO 670-53-11-745.SDR REXA2017052800671Floorbeam · corrodedCRAWLWAY FLOORBEAM ON THE BACK SIDE OF BS 280 HAD CORROSION, JUST ABOVE STRINGERS 26L AND 26R, IN THE FWD E & E BAY. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-06, AND 51-42-21.SDR REXA2017052700669Stringer · corrodedSTRINGER 24R HAS CORROSION BETWEEN BS 310 AND 280, IN THE FWD E & E BAY. REMOVED & REPLACED THE STRINGER IAW SRM 51-42-06.SDR REXA2017052700668Stringer Splice · corrodedSTRINGER SPLICE 26L HAS CORROSION JUST FWD OF BS 333, IN THE FWD E & E BAY. REMOVED AND REPLACED STRINGER SPLICE IAW SRM 51-42-06, & 51-42-21.
"SDR REXA2017052700667Stringer Splice · corrodedSTRINGER SPLICE 25R HAS CORROSION JUST FWD OF BS 333, IN THE FWD E & E BAY. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM 51-42-06, & 51-42-21.SDR REXA2017052500666Web · crackedFWD EQUIPMENT BAY DECK WEB CRACKED AT LH SIDE BS 202.75. REPAIRED THE DECK WEB IAW REO 670-53-11-509, REV D.SDR REXA2017052400665Tray · crackedMOUNTING TRAY CRACKED AT FWD OTBD BEND RADIUS. REMOVED DAMAGE, FOUND IN LIMITS AND RESTORED FINISH IAW SRM 53-00-00.SDR REXA2017052400664Doubler · corrodedANTENNA DOUBLER HAS CORROSION AT THE ACFT BELLY BETWEEN BS 310 - 295 AND STRINGERS 26L THRU 26R, IN THE FWD E & E BAY. REMOVED AND REPLACED ANTENNA DOUBLER IAW SRM 51-42-06.SDR REXA2017052400663Stringer · corrodedSTRINGER 27 HAS CORROSION BETWEEN BS 349 AND 333, IN THE FWD E & E BAY. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06.SDR REXA2017052400662Stringer · corrodedSTRINGER 25L HAS CORROSION BETWEEN BS 333 AND 295, IN THE FWD E & E BAY. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06.SDR REXA2017052400661Stringer · corrodedSTRINGER 26L HAS CORROSION BETWEEN BS 364 AND 333, IN THE FWD E & E BAY. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06.
"SDR REXA2017052400660Stringer · corrodedSTRINGER 26R HAS CORROSION BETWEEN BS 333 AND 295, IN THE FWD E & E BAY. REMOVED AND REPLACED THE STRINGER IAW SRM 51-42-06.SDR REXA2017052400659Bulkhead Web · corrodedAFTER REMOVING CAP ANGLE ON LT FS 280 FLOORBEAM TO EVALUATE CORROSION, FOUND CORROSION ON BULKHEAD WEB. REMOVED AND REPLACED IAW REO 670-53-11-594.
AAR EMP 29026
"SDR REXA2017052400658Floorbeam · corrodedBS 280 FLOORBEAM UPPER FLANGE HAS CORROSION BETWEEN LBL 12 AND LBL 18. REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-06, 51-42-13, & 51-42-21.SDR REXA2017052400657Floorbeam · crackedBS 280 FLOORBEAM RBL 9 OTBD ANGLE IS CRACKED. REMOVED AND REPLACED THE FLOORBEAM ANGLE IAW SRM 51-42-21.SDR REXA2017042800544Flashlight · inoperativeFORWARD FA FLASHLIGHT INOPERATIVE. REMOVED & REPLACED THE FLASHLIGHT AND HOLDER IAW AMM 25-61-02.SDR REXA2017021600249Oxygen Mask · brokenSEAT 6 AB OXYGEN MASK HAD A BROKEN FLOW VALVE. REPLACED THE PAX OXYGEN MASK IAW AMM 35-21-09.SDR REXA2017021600248Oxygen Mask · brokenROW 5 AB OXYGEN MASK HAS A BROKEN LANYARD. REPLACED PAX OXYGEN MASK IAW AMM 35-21-09.SDR REXA2016100501892Fan · inoperativeDISPLAY COOL CAUTION IF FLIGHT-QRH COMPLETE DISPLAY COOL CAUTION ON GROUND QRH COMPLETE, DISPLAY COOL CAUTION-WITH FAN NOISES AND ODOR, FAN TO STANDBY. REMOVED AND REPLACED COCKPIT DISPLAY FAN NR 1 IAW AMM 21-24-12 OPS TEST NORMAL.SDR REXA2016092801831Sensor · failedFLAPS FAIL CAUTION MSG INFLIGHT AT 29,500 FEET. LANDED AT FLAPS 1. DURING TROUBLE SHOOTING FOUND B1-00720 FOR SKEW SENSOR MT2 AND B1-
006797 MT4 SKEW SENSOR TO BE BAD. REMOVED AND REPLACED SKEW SENSOR MT4
P/N ON/OFF 5913164 S/N OFF A2263 S/N ON A2416 REMOVSDR REXA2016092701830Warning System · false activationFLAPS FAIL CAUTION MSG INFLIGHT CAME ON IN CLIMB AROUND 33,000 FT, LAND
ED ON FLAPS 1. CLEARED INHIBITS FOR SFECU IAW AMM 45-45-00. NO MESSAGES FOUND
. A/C OK FOR SERVICE.SDR REXA2016092701829Warning System · false activationFLAPS FAIL CAUTION MESSAGE.
PER AMM PERFORMED TASK 05-51-51-920-801. CLEARED INHIBITS ON
SFE1F. FLAPS FAIL MESSAGE GONE, FLAPS OPERATE THRU FULL RANGE MTC SWITCH T
O OFF.SDR REXA2016091301718Flashlight · inoperativeAFT FLASHLIGHT INOPERATIVE. R & R THE FLASHLIGHT IAW AMM 25-61-02. OPS CHECKED GOOD. OK FOR SERVICE.SDR REXA2016042100655Hose · kinkedFORWARD FLIGHT ATTENDANT OXYGEN MASK IN CEILING HAS A SEVERELY KINKED HOSE. REMOVED & INSTALLED SERVICEABLE FWD FLIGHT ATTENDANT OXYGEN MASK, PN 289-601-066-2 IAW AMM 35-21-09-400-803-A01.
SDR REXA2016042000623Seat Track · corrodedFLOOR TRACK SEGMENTS, ONE EACH AT LBL 9 & RBL 9, BETWEEN FS 847+62 - FS 954 IS CORRODED. LBL 9 - RBL 9 SEAT TRACK SEGMENTS, BETWEEN FS 847+62 & FS 954.00 WERE FABRICATED, R & R IAW GREO 670-53-00-343, AMM 53-00-49-000 400-801-A07.SDR REXA2016042000621Bulkhead · corrodedRIGHT FS 280 BULKHEAD WEB HAS CORROSION UNDER CORROSION CAP AT INBD EDGE. CONTINUATION CARD 81513411 OP 173. BULKHEAD WEB WAS REPAIRED IAW REO 670-53-11-594 REV A. CAP ANGLE REMOVED & REINSTALLED IAW SRM 51-42-06-001-001-A01. REPLACED FS 280 CROSSBEAM ON SDR REXA2016041800613Ground Wire · brokenEMERGENCY LIGHTS LOCATED BEHIND PANELS 171CL & 172CR HAVE BROKEN GND WIRES. REPAIRED GND WIRES FOR EMER LIGHTS LOCATED BEHIND PANEL 171CL & 172CR IAW ESPM 20-16-05. BOND TESTED GOOD IAW AMM 51-80-00-760-801-A01. THIS IS THE CORRECT NR FOR THIS ISSUE. PLEASSDR REXA201600613Ground Wire · brokenEMERGENCY LIGHTS LOCATED BEHIND PANELS 171CL & 172CR HAVE BROKEN GROUND WIRES.
REPAIRED GND WIRES FOR EMER LIGHTS IAW ESPM 20-16-05. BOND TEST GOOD IAW AMM 51-80-00-760-801-A01.
SDR REXA2016041700618Seat Track · corrodedFLOOR SEAT RAIL AT RBL 9 IS CORRODED, BETWEEN FS 374 - 394. SEAT TRACK WAS REPLACED IAW REO 670-53-00-343 REV M & AMM 53-00-49-400-801-A07.SDR REXA2016041700617Seat Track · corrodedFLOOR SEAT RAIL AT LBL 9 IS CORRODED, BETWEEN FS 349 - 394. SEAT TRACK WAS REPLACED IAW REO 670-53-00-343 REV M & AMM 53-00-49-400-801-A07. THIS IS THE CORRECT SUBMISSION FOR THIS SDR NUMBER. PLEASE DISREGARD PREVIOUS SUBMISSION.SDR REXA201600617Seat Track · corrodedFLOOR SEAT RAIL AT LBL 9 IS CORRODED BETWEEN FS 349 - 394. SEAT TRACK AT LBL 9, FS 349 - 394 WAS REPLACED IAW REO 670-53-00-343 REV M & AMM 53-00-49-400-801-A07.
Back to N903XJ