N913XJ
Service difficulty reports · 290
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 = 'N913XJ' 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 = 'N913XJ' 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 REXA2022091402078Frame · corrodedFRAME AT FS 349.00 IS CORRODED BETWEEN STGR 27 AND 26R.. INSTALLED NEW FRAME SECTOR P/N SH670-31357-5S AT FS349 BETWEEN STGR 23L AND STGR 24 R IAW CRJ 900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR REXA2022091402077Seat Track · corrodedLBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 661+32 TO F.S. 581. INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402076Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 661+32 TO F.S. 581. INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402075Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 693 TO F.S. 847. FABRICATED AND INSTALLED NEW SEAT TRACK IAW CRJ900 SRM 51-40-11-001-001-A01 AND 53-00-49-201-002-A01, AND CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022100502200Striker · corrodedAFT SIDE, BOTTOM OF GALLEY DOOR SEAL RETAINER IS CORRODED. REMOVED AND REPLACED LOWER GALLEY DOOR SEAL STRIKERSDR REXA2022100502195None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 661.00+14-720.00 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022100302170None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 867.00-969.00. FABRICATED AND INSTALLED NEW SEAT RAIL IAW IAW CRJ900 SRM 51-40-11-001-001-A01 AND 53-00-49-201-002-A01, AND CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402088None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 785.00-847.00+12. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402087None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 708.00-720.00. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402086None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 672.00-693.00. FABRICATED AND INSTALLED NEW SEAT RAIL IAW IAW CRJ900 SRM 51-40-11-001-001-A01 AND 53-00-49-201-002-A01, AND CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402085None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 847.00+12-903.00 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402084None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 785.00-847.00+12. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402082None · corrodedCORROSION FOUND LH SIDE SEAT RAIL BETWEEN FS 661.00+14-672 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402081None · corrodedCORROSION FOUND LH SIDE SEAT RAIL BETWEEN FS 571.00-661.00+14 INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402074Seat Track · corrodedLBL 27 SEAT TRACK IS CORRODED BETWEEN F.S. 927 TO F.S. 985. FABRICATED, INSTALLED SEAT TRACK AT LBL27 FS 927 TO FS 985 IAW CRJ900 AMM 53-00-49-400-801-A07 AND SRM 51-40-11-001-001-A01, 53-00-49-201-002-A01SDR REXA2022091402073Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847+48 TO F.S. 985. FABRICATED, INSTALLED SEAT TRACK AT RBL 9 FS 847+48 TO FS 985 IAW CRJ900 AMM 53-00-49-400-801-A07 AND SRM 51-40-11-001-001-A01, 53-00-49-201-002-A01SDR REXA2022091402072Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847 TO F.S. 847+48. REPLACED SEAT TRACK PN BA690-30000-6959 IAW CRJ AMM 53-00-49-400-801-A07.SDR REXA2022091402071Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847 TO F.S. 847+48 INSTALLED FABRICATED SEAT TRACK AT LBL 9 F.S 847 - 847+48 IAW CRJ 900 AMM 53-00-49-400-801-A07SDR REXA2021032900188Wire · disconnectedAFT R/W LIGHT ON FUSELAGE WIRES ARE NOT CONNECTED. R&R RH AFT OVER WING EMERGENCY LIGHT IAW CRJ 900 AMM 33-51-15 & REPLACED CONNECTOR PINS IAW CRJ 900 ESPM 20-16-00.OPS CHECK GOOD. LIGHT CONNECTORS P/N ON/OFF: 2LA006954-00, P/N ON: B0808002-037SDR REXA2020081800620Light · inoperativeRT AFT OVERWING EXTERIOR EMERGENCY LIGHT WAS NOT TURNING ON. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33--51-15. OPS TEST OK.SDR REXA2020081800619Lens · crackedLEFT FORWARD EMERGENCY OVERWING LIGHT LENS CRACKED. REPLACED LEFT FORWARD EMERGENCY OVERWING LIGHT LENS IAW CRJ 900 AMM 33-51-15; OP CK GOOD.SDR REXA201908151243Skin · gougedLH MLG TRUNNION INBD 3RD HOLE AFT HAS VISUAL DAMAGE APPROX .01" LONG BY .2" WIDE BY .020" DEEP. REPAIRED LH MLG TRUNNION INBD 3RD HOLE AFT FASTENER HOLE IAW BOMBARDIER REO 690-57-21-311 REV -- DATED 2019-08-08.SDR REXA2018122711314Smoke Detector · false activation"SMOKE AFT LAV" WARNING FOR ABOUT 5 SECONDS IN FLIGHT. FA VERIFIED NO
SMOKE PRESENT.
DEFERRED AFT LAV SMOKE DETECTION IAW MEL 26-16-1. NOTIFIED MOC 98628.
ENTERED IN MMO2. PLACARD INSTALLED.SDR REXA2018103001048Canister · crackedRT WING SLAT TRACK 1-3 CAN IS CRACKED INSIDE FUEL TANK NEAR ATTACH BRACKET. REPAIRED RT WING STAT TRACK 1-3 CANISTER IAW REO 670-57-42-577.SDR REXA2018103001043Door Sill · corrodedAFT CARGO DOOR SILL PLATE IS CORRODED. REMOVED DAMAGED AFT CARGO DOOR SILL PLATE & INSTALLED NEW SILL PLATE IAW SRM 51-42-06, 51-42-21, 51-42-13 AND REO 690-53-61-794(IR).SDR REXA2018102801044Floorbeam · corrodedAFT CARGO STA 1031 LBL 27 CORROSION TOP SIDE. REPAIRED AFT CARGO FLOORBEAM STATION 1031 LBL 27 IAW REO 670-53-00-029.SDR REXA2018102801042Floorbeam · corrodedAFT CARGO STA 1031 LBL 27 CORROSION TOP SIDE. REPAIRED ADT CARGO FLOORBEAM STATION 1031 LBL 27 IAW REO 670-53-00-029.SDR REXA201811091073Stringer · crackedSTRGR 3L AFT OF FS 280 CRACKED.
REPAIRED STRGR3L AT FS.281 IAW REO 670-53-21-493 LEAK CHECKED
IAW CRJ 900 AMM 21-23-00-790-801. NO LEAKS NOTED.
AAR SM-33SDR REXA2018102401070Floorbeam · corrodedLT FLOORBEAM AT FS 280 HAS CORROSION. REPLACED LT 280 FLOORBEAM IAW SRM 51-42-06, 51-42-21, 51-42-10 AND 51-40-11.SDR REXA2018102401069Support Angle · corrodedFS280 CROSSBEAM HAS MULTIPLE AREAS OF CORROSION. REPLACED FWD FLOOR SUPPORT IAW 51-42-06 AND 51-40-11.SDR REXA2018102401068Panel · chafedPANEL 684GB HAS CHAFING. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS. MATCH DRILLED AND COUNTERSUNK HOLES IAW SRM 51-41-02.SDR REXA2018102401067Panel · chafedPANEL 684EB IS CHAFED. REMOVED DAMAGE IAW SRM 51-12-00. FOUND TO BE OUT OF LIMITS IAW SRM 57-42-32. LOCATED AND DRILLED NEW PANEL IAW SRM 51-40-11.SDR REXA2018102401050Floorbeam · corrodedRT FLOORBEAM AT FS 280 HAS CORROSION. REPLACED RT 280 FLOORBEAM IAW SRM 51-42-06, 51-42-21, 51-42-10 AND 51-40-11.SDR REXA2018102301066Hinge Bracket · crackedRT ENGINE FWD CORE COWL AFT HINGE MOUNTING BRACKET (TIE BAR) HAS BROKEN BRACKET. REMOVED AND REPLACED CORE COWL AFT HINGE MOUNTING BRACKET IAW SRM 51-42-06.SDR REXA2018102201064Seat Track · corrodedCABIN SIDE, SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE BETWEEN EMERGENCY EXITS. REMOVED/REPLACED SIDEWALL SEAT RAIL FS743-763 FABRICATED ON NR 1016251 2000 0172 SN6611399 IAW AMM 53-00-49.SDR REXA2018102101065Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE INBOARD FLOOR STICK 1. REMOVED & REPLACED LBL 9 SEAT TRACK NR 1 IAW AMM 53-00-49.SDR REXA2018101801063Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE INBOARD FLOOR STICK 6. REMOVED/REPLACED FLOOR SEAT TRACK IAW AMM 53-00-49.SDR REXA2018101801062Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. RIGHT SIDE FLOOR STICK 4. REMOVED CORROSION AND GOUGES IAW SRM 51-21-06 AND 51-12-00. FOUND TO BE OUT OF LIMITS IAW SRM 53-21-19. REMOVED AND INSTALLED NEW SEAT TRACK IAW AMM 53-00-49. LOCATED AND DRILLED NEW SEAT TRACKSDR REXA2018101801061Seat Track · corrodedCABIN SEATRAIL HAS CORROSION. RIGHT SIDE FLOOR STICK 1. REMOVED AND REPLACED WITH NEW SEAT RAIL IAW AMM 53-00-49.SDR REXA2018101801060Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. RIGHT SIDE FLOOR STICK 5. REMOVED AND REPALCED FLOOR SEAT TRACK IAW AMM 53-00-49.SDR REXA2018101701059Seat Track · corrodedCABIN SIDE, SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE 2 STICK, AFT OF EMERGENCY EXITS. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-00-49.SDR REXA2018101701058Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE INBOARD FLOOR STICK 7. REMOVED/REPLACED FLOOR SEAT TRACK IAW AMM 53-00-49.SDR REXA2018101701057Seat Track · corrodedCABIN SEATRAIL HAS CORROSION. RIGHT SIDE FLOOR STICK 2. REMOVED/REPLACED RBL9 SEAT TRACK NR 2 IAW AMM 53-00-49.SDR REXA2018101701047Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. RIGHT SIDE FLOOR STICK 3. REMOVED ALL SEATRAIL AND INSTALLED NEW SEAT RAIL IAW AMM 53-00-49.SDR REXA2018101601056Seat Track · corrodedCABIN SIDE, SEATRAIL HAS CORROSION AND GOUGES LEFT SIDE 2 FORWARD OF EMERGENCY EXITS. REMOVED AND REPLACED SIDE SEAT RAIL IAW AMM 53-00-49.SDR REXA2018101601055Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE INBOARD FLOOR STICK 5. REMOVED DAMAGE IAW SRM TR 51-41. FOUND TO BE OUT OF LIMITS IAW SRM 53-21-49. REMOVED SEAT TRACK IAW AMM 53-00-49. LOCATED/DRILLED NEW SEAT TRACK IAW SRM 53-11-49. INSTALLED SEAT TRACK IASDR REXA2018101601051Seat Track · corrodedCABIN SIDE, SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE AFT OF EMERGENCY EXITS. REMOVED & REPLACED SEATRAIL IAW AMM 53-00-49.SDR REXA2018101601046Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. RIGHT SIDE FLOOR STICK 7. REMOVED AND REPLACED CABIN SEATRAIL IAW AMM 53-00-49.SDR REXA2018101601045Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. RIGHT SIDE FLOOR STICK 6. REMOVED AND REPLACED CABIN SEATRAIL IAW AMM 53-00-49.SDR REXA2018101501054Seat Track · corrodedCABIN SEATRAIL HAS CORROSION AND GOUGES. LEFT SIDE OUTBOARD FLOOR STICK 2. REMOVED AND REPLACED WITH NEW TRACK IAW AMM 53-00-49.
Back to N913XJ