N928XJ
Service difficulty reports · 233
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 = 'N928XJ' 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 = 'N928XJ' 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 REXA2014060200564Fireshield · chafedTASK CARD 900-71-430-100 LT ENG LOWER CORE COWLING HAS CHAFE DAMAGE TO FIRE SEALS. REPAIRED AREA IAW EO R54090.SDR REXA2014060100563Structure · dentedTASK CARD 900-53-900-106 RIVET PUSHED IN ON THE BOTTOM OF THE FUSELAGE BY 919.00 & SMALL DENT WHERE RIVET IS LOCATED. REPAIRED AREA IAW EO R53545.SDR REXA2014053100562Fireshield · bentTASK CARD 900-71-440-100 RT ENG LWR CORE COWL AFT Z FIRE SHIELD BENT ON CORNERS. REPAIRED IAW EA CRJ954-02612.SDR REXA2014053000561Fireshield · chafedTASK CARD 900-71-440-100 RT ENG LOWER CORE COWLING HAS CHAFE DAMAGE ON FIRE SEAL. REPAIRED FIRE SHIELD IAW EO R54090.SDR REXA2014053000560Seat Track · corrodedRIGHT SEAT TRACK IN FRONT OF FWD LAVATORY HAS CORROSION ON FWD END. R & R RT SEAT TRACK FWD OF LAVATORY IAW AMM 53-00-49-000-801-A07 & 53-00-49-400-801-A07.SDR REXA2014053000559Seat Track · corrodedTASK CARD 900-53-900-101 LT SEAT TRACK IN FRONT OF FWD LAVATORY HAS CORROSION ON FWD END. R & R LT SEAT TRACK IN FRONT OF FWD LAVATORY IAW AMM 53-00-49-000-801-A07 & AMM 53-00-49-400-801-A07.SDR REXA2014052800558Bracket · crackedPAX DOOR ASSIST CABLE PULLEY BRACKET CRACKED. R & R PAX DOOR ASSIST CABLE PULLEY BRACKET IAW SRM 51-42-22-001-001-A01, STEPS 11 & 9.SDR REXA2014052700557Cover · crackedTASK CARD 900-25-280-101 WIFI RACK SIDE COVER CRACKED. REPAIRED WIFI RACK SIDE COVER IAW ER NR CRJ946-02602 REV 1R.SDR REXA2014052400534Light · missingTASK CARD 900-25-900-907 FIRST CLASS 1 EACH EMERGENCY LIGHT STRIP MISSING. REPLACED MISSING EMERGENCY LIGHT STRIP IAW AMM 33-51-01-400-801-A21.SDR REXA2014052300522Light · degradedFLOOR TRACK LIGHT DEGRADED ON LT SIDE OF ROWS 3 - 4. REPLACED EMERGENCY FLOOR TRACK LIGHT PN PL-88-900LH00 IAW AMM 33-51-01.SDR REXA2014020700188Strip · missingEMERGENCY FLOOR TRACK STRIP MISSING AT WINDOW EXIT 13DC. REPLACED FLOOR TRACK STRIP AT SEAT 13DC IAW CRJ 900 AMM 33-51-01.SDR REXA2013120902221Light · unsecureEMERGENCY LIGHTING STRIP IN THE GALLEY AREA IS NO LONGER SECURE. STRIP LOCATED IN FRONT OF CARTS NR 305 & 306. SECURED STRIP LIGHTING IN FWD GALLEY IAW 33-51-00, ACFT OK TO CONTINUE.SDR REXA2013112002182Cable · faultyMAIN PAX DOOR WOULD NOT FULLY OPEN UPON ARRIVAL. REMOVED CABLE BALL END AT DOOR FRAME ATTACHMENT. LOWERED DOOR, CABLE BACKLASHED ON DRUM, STOWED CABLE, STOWED MTR CONNECTOR, PULLED & COLLARED CBP 1 E1 VERIFIED DOOR OPEN & CLOSES FREELY WITHOUT INTERFERENCE &SDR REXA2013111402177Charger · inoperativeCHARGER PS43P1 INOPERATIVE. R & R CHARGER IAW AMM 33-51-17. OPS CHECKED GOOD.SDR REXA2013103002157Battery Pack · inoperativeBATTERY AT PS35 BURNED. R & R EPSU BATTERY PACK AT PS35 IAW J/C 33-900-701.SDR REXA2013092101844Light · missingEMERGENCY LIGHT MISSING IN GALLEY. REPLACED EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR REXA2013013000037Beam · corrodedLEFT 280 BEAM HAS CORROSION. REMOVED AND REPLACED LEFT FS 280 BEAM IAW EO R53290 & EO R53117 AND EO R53127.SDR REXA2013013000036Skin · crackedFWD EQUIPMENT COMPARTMENT RT SKIN CRACKED UNDER ADG HAND PUMP. REPAIRED CRACKED RT SKIN AS REQUIRED IAW REO 670-53-11-509.SDR REXA2013013000035Beam · crackedLBL 12 BEAM IN THE VERY FWD E & E BAY IS CRACKED. REMOVED AND REPLACED CRACKED SECTION OF LBL 12 BEAM IAW EO R53289.SDR REXA2013012400034Stringer Splice · corrodedSPLICE ON STGR 25R AT FRAME 333 HAS CORROSION, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 25R SPLICE AT FS 333 IAW CRJ 900 SRM 51-42-06.SDR REXA2013012400033Stringer · corrodedSTRINGER 26R HAS CORROSION BETWEEN FRAMES 333 AND 280, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 26R FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06.SDR REXA2013011100032Beam · crackedRBL 12 BEAM IN THE VERY FWD E & E BAY IS CRACKED. REMOVED AND REPLACED CRACKED PORTION OF RBL 12 BEAM IAW EO R53289. AAR SM-10.SDR REXA2013011100031Beam · crackedRBL 12 BEAM IN THE VERY FWD E & E BAY IS CRACKED. REMOVED AND REPLACED CRACKED PORTION OF RBL 12 BEAM IAW EO R53289. AAR SM-10.SDR REXA2013011100030Beam · corrodedRIGHT 280 BEAM UPPER FREE FLANGE AT BL 0.00, UPPER RADIUS HAS CORROSION. REMOVED AND REPLACED RIGHT FS 280 BEAM IAW EO R53290 + EO 53127. P/N CC670-34094-2S.SDR REXA2013011100029Structure · corrodedFLT DECK FLOOR FLANGE AFT LANDING LOWER SURFACE HAS CORROSION NEW 280 BEAM. REMOVED AND REPLACED AFT FLOOR LANDING IAW CRJ 900 RM 51-40-11 & 51-42-06. P/N CC670-34095-35. AAR SM-10.SDR MALA201112310290Battery · inoperativeFOUND EMERGENCY BATTERY TO BE BAD. R & R BATTERY AT PS 43 IAW JOB CARD 33-900-701. OPS CHECKED GOOD.SDR MALA110288Light · malfunctionedWITH THE EMERGENCY LIGHT SWITCH IN THE ARMED POSITION THE EMERGENCY LIGHTS COME ON AND FLICKER OFF ON THEIR OWN. PERFORMED OPS TEST OF EMERGENCY LIGHTING IAW AMM 33-51.SDR MALA110162Light · inoperativeFWD OVERWING EMERGENCY LIGHT & ROW 12 EMERGENCY LIGHTS ON WHEN ACFT POWER REMOVED. LIGHTS COME ON INTERMITTENTLY. REPLACED PS37 POWER SUPPLY/CHARGER P/C 11-0049, SN 23169, AND REPLACED BATTERY ASSY PN 2013-1A, SN 98024, IAW AMM 33-51-17. OPS CHECKED GOOD.SDR MALA110157Battery Pack · inoperativeDURING RETURN TO GATE, NOTED ROW 12 EMERGENCY LIGHTS ILLUMINATED. REPLACED BATTERY PACK PS37 IAW AMM 33-51-17 PN ON/OFF 2013-1A, SN OFF 99445, SN ON 98024.SDR MALA100192Relay · failedDURING CRUISE AT FL 340, THE EMERGENCY LIGHTS IN THE CABIN (ALL OF THEM) ALONG WITH THE ASSOCIATED "EMER LTS ON" EICAS STATUS MESSAGE BEGAN CYCLING ON AND OFF. ALL OTHER SYS APPEARED NORMAL. CONTINUED FOR REMAINDER OF FLIGHT AND WHILE PARKED AT THE GATE ON EXTSDR MALA100034Light · damagedDURING INSPECTION, NOTED LT SIDE GALLEY FLOOR TRACK LIGHT STRIP BROKEN/MISSING. INSTALLED NEW FLOOR TRACK LIGHT STRIP ON LT SIDE OF GALLEY.SDR MALA090156Light · missingEMERGENCY LIGHT STRIP IN GALLEY IS MISSING. REPLACED FLOOR TRACK LIGHTING.SDR MALA080127Selector Valve · malfunctionedGEAR EXTENSION FAILED ON APPROACH TO DTW. PERFORMED EMERGENCY LANDING GEAR EXTENSION AND LANDED IN DTW. (A)
Back to N928XJ