N936XJ
Service difficulty reports · 191
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 = 'N936XJ' 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 = 'N936XJ' 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 REXA2013033100514Seat Track · corrodedLEFT SIDE SEAT TRACK NR 7 CORRODED/GOUGED. REPLACED LEFT SIDE SEAT NR 7 TRACK IAW CRJ 900 AMM 53-00-49. P/N SH670-36230-5.SDR REXA2013033100512Charger · inoperativeTHE FOLLOWING EMERGENCY LIGHTS STAY ON AFTER POWER CUT: LEFT FWD O/W EXTERNAL, RIGHT AFT O/W EXTERNAL, ALL FOUR OW EXIT INTERNAL, BOTH AFT O/W FLOOR EXIT INTERNAL AND AFT FACING CENTER CEILING. REMOVED AND REPLACED NR 3 EMERGENCY LIGHT BATTERY CHARGER IAW CRSDR REXA2013033100511Stringer Splice · corrodedWHILE WORKING STRINGER 26R FS 319-333 CORROSION FOUND ON SPLICE ANGLE AT FS 333. REMOVED AND REPLACED STGR 26R SPLICE AT FS 333 IAW CRJ 900 SRM 51-42-06. P/N SH670-32429-3.SDR REXA2013033100510Seat Track · corrodedSIDE SEAT TRACK STICK 5 RIGHT IS CORRODED. REPLACED RIGHT NR 5 SIDE SEAT TRACK IAW CRJ-900 AMM 53-00-49. P/N SH690-36284-1.SDR REXA2013033100509Seat Track · corrodedSIDE SEAT TRACK STICK 7 RIGHT IS CORRODED. REPLACED RIGHT SIDE SEAT RAIL 7 IAW CRJ 900 AMM 53-00-49. P/N SH670-36260-5.SDR REXA2013033100508Seat Track · corrodedSIDE SEAT TRACK STICK 4 RIGHT IS CORRODED. REMOVED AND REPLACED RIGHT NR 4 SIDE SEAT TRACK IAW CRJ 900 AMM 53-00-49. P/N SH690-36283-1.SDR REXA2013033100507Seat Track · corrodedSIDE SEAT TRACK STICK 2 RIGHT IS CORRODED. REMOVED AND REPLACED RIGHT 2 SIDE SEAT TRACK IAW CRJ 900 AMM 53-00-49 STEP 4A.SDR REXA2013033100506Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE IS CRACKED. REPAIRED AFT DRAG ANGLE IAW REO 670-52-11-072 AND REO 690-52-11-222. P/N 601R31772-55.SDR REXA2013033100505Seat Track · corrodedLEFT SIDE SEAT TRACK NR 3 CORRODED/GOUGED. DOT A247 043. REMOVED AND REPLACED LEFT SIDE SEAT TRACK 3 IAW CRJ 900 AMM 53-00-49. P/N SH690-36282-1.SDR REXA2013033100504Seat Track · corrodedRIGHT NR 1 FLOOR TRACK CORRODED. REMOVED AND INSTALLED RIGHT NR 1 FLOOR TRACK IAW CRJ AMM 53-00-49-400-801 PART SH670-32159-1.SDR REXA2013033100503Sill · corrodedFORWARD OF SERVICE DOOR WEB CORRODED. REMOVED AND REPLACED FLOOR SILL AT FS 319.70 - FS 280 IAW CRJ 900 SRM 51-42-06. P/N SH670-32172-11.SDR REXA2013033100502Web · corrodedRIGHT FS 280.0 LOWER WEB CORRODED. REMOVED AND REPLACED DAMAGED SECTION OF RIGHT FS 280.0 LWR WEB IAW EO R53339.SDR REXA2013033100501Web · corrodedLEFT FS 280.0 LOWER WEB CORRODED. REMOVED AND REPLACED DAMAGED SECTION OF LEFT FS 280.00 LWR WEB IAW EO R53339.SDR REXA2013033100500Beam · corrodedRIGHT FS 280.0 BEAM CORROSION. REMOVED AND REPLACED RIGHT FS 280 BEAM IAW EO R53334. P/N CC670-34094-2S.SDR REXA2013033100499Beam · corrodedLEFT FS 280.0 BEAM CORRODED. REMOVED AND REPLACED LEFT FS.280 BEAM IAW EO R53334. P/N CC670-34094-1S.SDR REXA2013033100498Diaphragm · corrodedE/E BAY RT/OB DIAPHRAGM BETWEEN FS 349-364 HAS CORROSION. REMOVED CORROSION FROM RIGHT O/B DIAPHRAGM PART IS WITHIN LIMITS IAW CRJ 900 SRM 55-21-23 AMD EO 53277.SDR REXA2013033100497Frame · corrodedFS 349 FRAME HAS CORROSION ON AFT SIDE JUST LEFT OF S26R. REMOVED CORROSION FROM FRAME AT FS 349 PART IS WITHIN LIMITS IAW CRJ 900 SRM 53-21-106 AND EO R53277.SDR REXA2013033100496Stringer · corrodedSTRINGER 26R BETWEEN FS 319.70-333 ATTACH RIVETS AND SURFACE EVIDENCE OF CORROSION. REMOVED AND REPLACED STGR 26R FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06. P/N SH670-31634-2.SDR REXA2013033100495Frame · corrodedFS 319 FRAME HAS CORROSION BETWEEN S26L-S26R. REMOVED CORROSION FRAME 319. FRAME IS WITHIN LIMITS IAW CRJ 900 SRM 33-21-06 AND EP R53277.SDR REXA2013033100494Frame · corrodedFS 310 FAME HAS CORROSION ON FWD SIDE BETWEEN STRINGERS 26L-25R. REMOVED CORROSION FROM FRAME 310. PART IS WITHIN LIMITS IAW CRJ 900 SRM 53-21-06 AND EO R53277.SDR REXA2013033100493Frame · corrodedFS 295 FRAME AFT SIDE HAS CORROSION BETWEEN STRINGERS 26L-25R. REMOVED CORROSION FROM FS 295 FRAME. PART IS WITHIN LIMITS IAW CRJ 900 SRM 53-21-06.SDR REXA2013033100492Stringer · corrodedSTRINGER 26L HAS CORROSION BETWEEN FS 280-FS 295. REMOVED AND REPLACED STGR 26L FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06. SH670-31634-1.SDR REXA2013033100491Crossbeam · corrodedFS 280.00 CROSS BEAM LOWER SIDE HAS CORROSION AREA ABOVE SERVICE LIGHT. REMOVED AND REPLACED FS 280 BEAM FWD FLOOR ANGLE SPLICE IAW CRJ 900 SRM 51-40-11. P/N CC670-34095-3S.SDR REXA2013033100490Beam · crackedRBL 12 BEAM CRACKED FWD OF FS 280.00 CROSSBEAM. REMOVED AND REPLACED RBL 12 DAMAGED SECTION IAW EO R53333.SDR REXA2013033100489Beam · crackedLBL 12 BEAM CRACKED FWD OF FS 280.00 BEAM. REMOVED AND REPLACED LBL 12 DAMAGED SECTION IAW EO R53333.SDR REXA2013033100488Skin · damagedLEFT I/B FLAP LOWER I/B SKIN DAMAGED. REPAIRED DAMAGE IAW REO 670-57-52-160.SDR REXA2013033100487Panel · crackedRIGHT PYLON UPPER AFT HINGE PANEL CRACKED AT THE AFT FASTENER. REPAIRED HINGE FAIRING PANEL IAW CRJ 900 SRM 51-40-11.SDR REXA2013021100038Light · damagedEMERGENCY EXIT LIGHTING STRIP BY ROW 13 IS DAMAGED. RE-SECURED EXIT MARKING STRIP AT ROW 13AB. CONDITION & SECURITY CHECKS GOOD.SDR REXA2012122801602Light · looseTHE 13 A/B FLOOR TRACK LOOSE. RE-INSTALLED FLOOR TRACK LIGHT IAW CRJ900 AMM 33-51-01.SDR REXA2012063000938Battery Pack · inoperativeEMERGENCY LIGHTS ON STATUS MESSAGE, OVERHEAD "EXIT" LIGHT ILLUMINATED OVER ROW 13. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT ROW 13 OPS TESTED IAW AMM 33-51-17 GOOD.SDR REXA2012063000933Selector Valve · malfunctionedAFTER WAITING 10 MINUTES PER MEL 26-14-1A, RETRACTED THE GEAR AND RECEIVED A GEAR DISAGREE WARNING. FOLLOWED THE EMC NON-NORM CHECKLIST AND RETURNED TO DEPARTURE. REMOVED AND REPLACED MLG SELECTOR VALVE IAW AMM 32-32-10SDR REXA2012022000041Engine · contaminatedAFTER TAKEOFF, FLIGHT ATTENDANT SMELLED BURNING PLASTIC. PILOTS CONFIRMED AN ODOR. RETURN TO DEPARTURE. IDENTIFIED ODOR AS ENGINE WITH SOAP, RESIDUAL FROM ENGINE WASH ON RT ENGINE. RAN ENGINES TO 85 OIL TEMP WITH PACKS ON FULL HOT UNTIL ODOR DISSIPATED. SDR MALA110248Cover · missingFWD F/A NOTIFIED FLIGHT DECK ENROUTE, THAT THE EXIT COVER FOR THE EXIT SIGN ON THE FWD SERVICE DOOR (SMALL SIGN HALFWAY DOWN THE FRAME LT SIDE LOOKING AT DOOR) IS MISSING. INSTALLED NEW COVER FOR MISSING EXIT SIGN ON SERVICE DOOR, PN: BC5-0393-288. OK FOR SSDR MALA110121Light · dislodgedPART OF THE FLOOR TRACK LIGHTING IN FWD GALLEY WAS DISLODGED BY CATERING. INSTALLED SERVICEABLE FLOOR TRACK IAW MM 33-51.SDR MALA110119Light · unsecureEMERGENCY LIGHTING ON FLOOR FROM LAV NEEDS TO BE RESECURED. SECURED EMERGENCY LIGHTING FLOOR STRIP AS NEEDED.SDR MALA110038Unknown · odor"SMOKE" RIGHT AFTER T.O. THE FWD LAV WARNING MESSAGE CAME ON. STARTED GOING THROUGH THE NON NORMAL PROCEDURES PER THE POM AND THEN THE LIGHT WENT OUT. THERE WAS A STRONG UNNATURAL ODOR EMITTING FROM THE LAV PER FLT ATT. WHICH WE COULD ALSO SMELL IN COCKPIT.SDR MALA110009Skin · damagedRIVET CHAFED AT ES 916.00, STR 27 UNDER AFT BELLY FAIRING. R & R DAMAGED RIVET AT ES 916, STR27 UNDER AFT BELLY FAIRING IAW MODSUM NR IS670538200021 AND REO 670-53-00-014.SDR MALA110008Skin · chafedSKIN CHAFED AT FS 916.00 STR 27 UNDER AFT BELLY FAIRING. REPAIRED SKIN DAMAGE AT ES 916, STR27 UNDER AFT BELLY FAIRING IAW MODSUM NR IS670538200021 AND REO 670-53-00-014.SDR MALA110017Panel · crackedPAX DOOR FWD TOP STEP SIDE PANEL ZONE 2 CRACKED. REPAIRED DISCREPANT SIDE PANEL IAW REO 670-52-11-104.SDR MALA110016Panel · crackedPAX DOOR, AFT TOP STEP AND MID STEP SIDE PANEL CRACKED AT ZONE 2 AND 3. CUT AWAY DAMAGE FROM PAX DOOR STEP AFT SIDE PANEL AT ZONES 2 AND 3 AND INSTALLED REPAIR ANGLES AND DOUBLER IAW REO 670-52-11-104.SDR MALA100166Light · missingTHE FLOOR EMERGENCY STRIP BY FWD GALLEY IS MISSING. REPLACED GALLEY FLOOR EMERGENCY BASE STRIP P/N PL88-900LH00.
Back to N936XJ