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 REXA2014052000518Liner · gougedLEFT ENG LOWER COWL INNER LINER GOUGED. REPAIRED LT ENG LOWER COWL INNER LINER IAW EA CRJ954-02572. NO FURTHER DAMAGE FOUND.SDR REXA2014052000517Cowling · chafedLEFT ENG CORE COWL HAS CHAFE DAMAGE TO THE PYLON INTERFACE. MECH REPAIRED CHAFE DAMAGE ON LT ENG CORE COWL IAW SRM 54-13-00-201-006-A01.SDR REXA2014051900516Cowling · chafedRIGHT ENG CORE EXH COWL HAS CHAFE DAMAGE TO THE PYLON INTERFACE. REPAIRED CHAFE DAMAGE ON RT CORE COWL IAW SRM 54-13-00-201-000-A01.SDR REXA2014051600515Cowling · crackedPOSSIBLE CRACK ON NR 1 ENG INLET COWL FWD OF FADEC. THERE IS A ROUND PANEL WITH 4 BOLTS THE CRACK LOOKS LIKE IT STARTS HERE. REMOVED FADEC UNIT NR 1 ENG TO FOM IAW AMM 73-21-01-000-801-A01. REPAIRED CRACK ON #1 ENGINE INLET COWL AS PER EA CRJ954-02561 REV SDR REXA2014051600514Drain Mast · damagedTASK CARD 900-71-440-100 RT ENG LOWER NACELLE DRAIN MAST PAN HAS DAMAGE. REPAIRED DAMAGED AREA IAW EO R54090.SDR REXA2014051600513Skin · crackedMAIN PAX DOOR AFT TOP SIDE SKIN HAS POSSIBLE CRACK IN CORNER. REPAIRED PAX DOOR SIDE SKIN IAW EO R52024.SDR REXA2014051400512Rack · crackedWIFI RACK SIDE IS BENT & CRACKED AT 2 PLACES. REPAIRED DAMAGED SECTION OF WIFI RACK IAW EO CRJ 946-02552.SDR REXA2014051400511Bracket · damagedLEFT MLG SIDE STAY BRACKET FOR WIRE BUNDLES HAS SCREW HOLE ELONGATED. R & R CHANNEL LT MLG SIDE STAY IAW SRM 51-42-21-001-001-A01 & 51-42-06-001-001-A01.SDR REXA2014040900371Glowstrip · missingFLOOR LEVEL PHOTO LUMINESCENT ESCAPE PATH MARKING AT 12 A & B, MISSING A STRIP THAT POINTS TOWARD THE EXIT. INSTALLED STRIP OF PHOTO LUMINESCENT STRIP AT 12 AB IAW AMM 33-51-01, OK FOR SERVICE.SDR REXA2013120202204Life Vest · missingMISSING THREE INFANT LIFE VEST. INSTALLED THREE INFANT LIFE VEST PN P0640-101.SDR REXA2013080901463Light · brokenEMERGENCY LIGHT FROM ROW 12 BROKEN OFF. SECURED EMERGENCY LIGHT AT ROW 12 A/B IAW AMM 33-51-00. NO DEFECTS NOTED AT THIS TIME.SDR REXA2013040500477Ground Wire · damagedRIGHT EXTERIOR FORWARD OVERWING EMERGENCY LIGHT INOPERATIVE. REPAIRED GROUND WIRE ON RH FWD ER LIGHT. OPS CHECKED GOOD IAW 33-51-15.SDR REXA2013012000026Panel · crackedL1 DOOR, AFT SIDE PANEL IS CRACKED IN CORNER BELOW TOP STEP HINGE. REMOVED AND REPLACED PAX DOOR AFT SIDE PANEL IAW CRJ 900 SRM 51-42-06.SDR REXA2013012000025Panel · crackedL1 DOOR, AFT SIDE PANEL IS CRACKED IN CORNER BELOW TOP STEP HINGE. REMOVED AND REPLACED PAX DOOR AFFT SIDE PANEL IAW CRJ 900 SRM 51-42-06.SDR REXA2013011900024Stringer · corrodedSTGR HAS CORROSION BETWEEN FRAMES 333 AND 280, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 24R FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06.SDR REXA2013011900023Beam · crackedLBL 12 BEAM IN THE FWD SECTION OF THE FWD E & E BAY, IS CRACKED. REMOVED AND REPLACED RBL 12 BEAM IAW CRJ 900 EO R53276.SDR REXA2013011800022Stringer Splice · corrodedSPLICE ON STGR 25R HAS CORROSION AT FRAME 333, IN THE FWD E & E BAY. REMOVED AND REPLACED SPLICE ON STGR 25R FRAME STATION 333 IAW CRJ 900 SRM 51-42-06.SDR REXA2013011700021Longeron · corrodedLONGERON AT STGR 25R HAS CORROSION BETWEEN FRAMES 364 AND 333, IN THE FWD E & E BAY. REMOVED AND REPLACED LONGERON AT STGR 25R IAW CRJ 900 SRM 51-42-06.SDR REXA2013011700020Frame · corrodedFRAME 333 HAS CORROSION BETWEEN STGR 26L AND 25R, IN THE FWD E & E BAY. REMOVED CORROSION FROM FRAMES 333 BETWEEN STGR 25R: FRAME FOUND TO BE WITHIN LIMITS IAW CRJ 900 REO 690-53-21-421 EO R53280.SDR REXA2013011700019Stringer · corrodedSTGR 26R HAS CORROSION BETWEEN FRAMES 349 AND 333, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 26R AT FS 364 TO FS 333 IAW CRJ 900 SRM 51-42-00.SDR REXA2013011700018Diaphragm · corrodedLEFT I/B DIAPHRAGM, JUST TO THE LEFT OF STGR 27, HAS CORROSION, BETWEEN FRAMES 364 AND 349, IN THE FWD E & E BAY. REMOVED AND REPLACED LEFT I/B DIAPHRAGM IAW CRJ 900 SRM 51-42-06 AND 51-42-21.SDR REXA2013011700017Diaphragm · corrodedRIGHT I/B DIAPHRAGM, JUST TO THE RIGHT OF STGR 27, HAS CORROSION, BETWEEN FRAMES 364 AND 349, IN THE FWD E & E BAY. REMOVED AND REPLACED RIGHT I/B DIAPHRAGM IAW CRJ 900 SRM 51-42-06 AND 51-42-21.SDR REXA2013011700016Stringer · corrodedSTGR 21R HAS CORROSION BETWEEN FRAMES 379 AND 333, IN THE FWD E & E BAY. REPAIRED STGR 21R IAW CRJ 900 REO 690-53-21-418 & EO R53281.SDR REXA2013011700015Stringer · corrodedSTGR 25R HAS CORROSION BETWEEN FRAMES 333 AND 280, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 25R FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06.SDR REXA2013011700014Stringer · corrodedSTGR 23R HAS CORROSION BETWEEN FRAMES 333 AND 280, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 23R FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06.SDR REXA2013011700013Structure · corrodedFORWARD OF SERVICE DOOR PANEL LANDING CORRODED. REPAIRED CORROSION ON PANEL LANDING IAW EO R53284.SDR REXA2012122401634Cowling · dentedLEFT LOWER FAN COWL HAS DENT APPROX 14" AFT OF FWD EDGE APPROX 6 O'CLOCK POSITION. PERFORMED REPAIR ON LEFT LOWER FAN COWL IAW EO 54070 & REO 670-54-14-1012.SDR REXA2012122401633Cowling · dentedLEFT LOWER FAN COWL HAS DENT APPROX 4" FROM FWD EDGE AT APPROX 6 O'CLOCK POSITION. PERFORMED REPAIR ON LEFT LOWER FAN COWL IAW EO R54070 & REO 670-54-14-1012.SDR REXA2012122401632Bulkhead · corrodedWHILE WORKING LEFT FS 280 BEAM LOWER BULKHEAD WEB FOUND TO BE CORRODED. REMOVED AND REPLACED LEFT FS 280 BEAM LOWER BULKHEAD WEB IAW EO #R53283.SDR REXA2012122401631Stringer · corrodedSTGR 23R HAS CORROSION BETWEEN FRAMES 379 AND 364, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 23R FROM FS 33 TO FS 379 IAW CRJ 900 SRM 51-42-06. P/N SH670-31380-1.SDR REXA2012122401630Stringer · corrodedSTGR 26R HAS CORROSION BETWEEN FRAMES 333 AND 280, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR BETWEEN FS 280 AND FS 333 IAW CRJ 900 SRM 51-42-06. P/N SH670-31634-2.SDR REXA2012122401629Stringer Splice · corrodedSPLICE AT 23R HAS CORROSION AT FRAME 333, IN THE FWD E & E BAY. REMOVED AND REPLACED STGR 23R SPLICE FS.333 IAW CRJ 900 SRM 51-42-06. P/N SH670-32429-1. AAR SM-10.SDR REXA2012122401628Doubler · corrodedANTENNA DOUBLER HAS CORROSION AT A/C BELLY BETWEEN FRAMES 310 AND 295, IN THE FWD E & E BAY. REMOVED AND REPLACED ANTENNA DOUBLER BETWEEN FS 295 AND FS 310 AT STGR 27 IAW CRJ 900 SRM 51-42-06. AAR SM-10.SDR REXA2012091100967Strip · missingFLOOR STRIP LIGHTING ROW 13 IN FRONT OF SEAT C IS MISSING. REPLACED PHOTO LIGHT STRIP AT ROW 13 IAW AMM 33-51-01. A/C OK FOR RETURN TO SERVICE.SDR MALA110267Reservoir · leakingIN CRUISE FLT HYDRAULIC SYS 3 HIGH TEMP FOLLOWED ABNORMAL PROCEDURE TURNED 3B OFF AND TEMP STABILIZED AND DECREASED TO 85. HYD 3 LOW PRESS CAUTION. FOLLOWED ABNORMAL PROCEDURES. SUBSEQUENTLY ACCUMULATOR PRESSURE DEPLETED TO ZERO. TURNING PUMP 3B BACK ON DISDR MALA110003Light · missingLT FWD GALLEY EMERGENCY FLOOR PATH LIGHTING STRIP, 2FT SECTION MISSING. INSTALLED NEW FLOOR PATH LIGHTING STRIP 2FT SECTION PN PL88-900LH00, FILM PN PL88-930LH05, AND COVER PN PL88-910LH00 AMM 33-51-01.SDR MALA100194Acoustic Liner · damagedDURING INSP OF ENGINE FWD CORE COWL, FOUND DAMAGE TO ACOUSTIC LINER AT FWD AREAS OF 6 O'CLOCK POSITION. DAMAGE (2 OFF DENTS WITH 1 OFF CRACK) ON NR1 ENGINE LWR FWD CORE COWL. R & R LT LOWER COWL ASSY AND REPAIRED IAW REO 690-54-23-125 FOR PN 624-0102-003, SN SDR MALA100090Light · unsecureEMERGENCY STRIP CAME OFF INFRONT OF GALLEY CART. INSTALLED NEW STRIP OF EMERGENCY LIGHTING STRIP ON LT GALLEY.SDR MALA100089Light · missingFLOOR TRACK LIGHTING STRIP IN FRONT OF FWD GALLEY CART MISSING. REPLACED MISSING FLOOR TRACK LIGHTING STRIP.SDR MALA090122Relay · malfunctionedCABIN EMERGENCY LIGHTS CYCLING ON AND OFF. REPLACED RELAY.SDR MALA090121Light · malfunctionedCABIN EMERGENCY LIGHTS CYCLING ON AND OFF. RESET POWER ON ACFT; NO FAULTS FOUND.SDR MALA090120Relay · malfunctionedCABIN EMERGENCY LIGHTS FLASHING ERRATICALLY. REPLACED AC ESS BUSS RELAY.SDR MALA090062Selector Valve · malfunctionedGEAR DISAGREE MESSAGE, ATB. REPLACED LG SELECTOR VALVE.
Back to N927XJ