N937XJ
Service difficulty reports · 187
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 = 'N937XJ' 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 = 'N937XJ' 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 REXA2015041700415Light · defectiveLIGHT CLUSTER, LED, DS439 ON CEILING PANEL NR 9 CAUSING 3 SETS OF OVERHEAD EMER LIGHTS TO BE INOPERATIVE, SHORTED AMP. REPLACED CTR CEILING FLOOD LIGHT ASSEMBLY, INCL DS439, IN CEILING PANEL NR 9. SYS CHECKED GOOD IAW 33-51-00-710-802.SDR REXA2015041400405Light · detached13 C/D EMERGENCY ROW FLOOR STRIP LIGHTING CAME LOOSE. REINSTALLED EMERGENCY FLOOR STRIP ROW 13 C/D IAW AMM 33-51-01. NO FURTHER ACTIONS REQUIRED.SDR REXA2015020400176Flashlight · inoperativeCAPTAIN`S EMER FLASHLIGHT IS INOPERATIVE. PLACED CAPTAIN`S EMER FLASHLIGHT ON DEFERRAL IAW MEL 25-61-4A CAT C. PLACED IN MM02 & PLACARD INSTALLED. PROCEDURES COMPLIED WITH. REPLACED CAPTAIN`S EMER FLASHLIGHT BATTERY IAW AMM 25-60-4A. CLEARED CONT 3192410-SDR REXA2014112401149Light · looseEMERGENCY FLOOR PATH LIGHTING STRIP KICKED LOOSE AT SEAT 12AB FWD PORTION. INSTALLED SEAT 12AB EMER FLOOR PATH LIGHTING IAW AMM 20-00-00. NO DEFECTS NOTED.SDR REXA2014111801141Light · missingEXIT ROW 12 FLOOR STRIP MISSING. INSTALLED AN EMER FLOOR STRIP IN EXIT ROW 12 IAW AMM 33-51-01. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR REXA2014110701114Light · inoperativeRIGHT WING OVERWING EMER EXIT AFT EXTERIOR LIGHT INOPERATIVE. OK TO DEFER IAW MEL 33-51-2A CAT C, DAY OPERATIONS ONLY IAW MOC 96579. MM02 UPDATED & PLACARD INSTALLED. R & R RT AFT EMER OVERWING LIGHT ASSEMBLY IAW AMM 33-51-15. PLACARD REMOVED. MM02 UPDATESDR REXA2014101501054Access Panel · unknownTASK CARD 900-54-430-301 NUMBER 1 ENG LOWER FWD CORE COWL STARTER DRAINS ACCESS PANEL. R & R NR Q ENG CORE COWL STARTER DRAIN ACCESS PANEL IAW SRM 51-40-11-001-001-A01, AMM 71-12-09-000-801-A01 & 71-12-09-400-801-A01. PANEL REQUIRES TOP COAT TRANSFERRED TO PSDR REXA2014101301053Switch · dirtyTASK CARD 900-52-840-111 RIGHT FWD OVERWING EMER EXIT INDICATION SLOW TO APPEAR ON EICAS, DOOR OPEN LEGEND. CLEANED RT OVERWING EMER EXIT SWITCH TOGGLE IAW AMM20-70-00-140-801-A01. OPERATIONS CHECKED GOOD IAW AMM 52-21-00-710-801-A02.SDR REXA2014101301037Door · lack of lubeTASK CARD 900-52-840-111 LEFT FWD OVERWING EMER KIT FAILS PULL CHECK, SHOULD BE 40LBS FORCE & PULLED 46. LUBED LT FWD OVERWING EMER EXIT IAW AMM 12-20-52-640-815-A01. PULL TESTED GOOD AT 40 LBS IAW AMM 52-21-00-720-802-A01.SDR REXA2014101301036Door · lack of lubeTASK CARD 900-52-840-111 RIGHT FWD OVERWING EMER EXIT FAILS PULL CHECK, SHOULD BE 40LBS FORCE & PULLED 46. LUBED RT FWD OVERWING EMER EXIT IAW AMM 12-20-52-640-812-A01. PULL TESTED GOOD AT 40 LBS IAW AMM 52-21-00-720-802-A01.SDR REXA2014101201052Structure · dentedTASK CARD CR DAMAGE LOG 2463257 REQUIRES MAPPED & RECORDED IAW CUST REVISED SCRATCH DENT LOG PROGRAM, RAMP REPORTS DENT BELOW AFT CARGO DOOR. MAPPED & RECORDED DENT IAW CUST REVISED SCRATCH DENT PRO EO R51011. REPAIRED AREA IAW EA 953-02994 PANEL 281JLF TO BSDR REXA2014101201051Structure · dentedTASK CARD CR POSSIBLE PREVIOUS BLEND OUT, DENT 3 INCHES BELOW AFT CARGO DOOR PROTECTOR PLATE. REPAIRED AREA IAW EA CRJ953-02993. TAPPED & RECORDED AREA IAW CUSTOMER. REVISED SCRATCH & DENT PROGRAM EO R51011 PANEL 281JLF TO BE INSTALLED ON PANEL TALLY 454. SDR REXA2014101201050Boss · crackedTASK CARD 900-53-140-508 AVIONICS DOOR OUTER HANDLE BOSS APPEARS TO BE CRACKED NEEDS NDT. R & R IAW 52-52-00-000-801-A01, 52-52-00-400-801-A01 & 52-42-00-710-801-A01. OPERATIONS TESTED GOOD.SDR REXA2014101101049Fireshield · peelingTASK CARD 900-54-440-301 RIGHT ENG LOWER FWD CORE COWL FIRE SHIELD PEELING UP, TYPICAL LOCATION. REPAIRED RT ENG LOWER FWD CORE COWL IAW EO R54090.SDR REXA2014100901048Access Panel · chafedTASK CARD CRJ900 C1 RT WING INBD FLAP ACCESS PANEL 684EB SHOWS CHAFE DAMAGE. RT WING INBD FLAP PANEL 684EB CHAFE FOUND TO BE OUT OF LIMITS IAW SRM 57-52-01-101-001-A01. RECEIVED NEW PANEL FROM STOCK & PREPARED HOLES SRM 51-40-11-0001-001-A01. PANEL WILL BE SDR REXA2014100901047Escape Rope · frayedTASK CARD 900-25-260-100 LEFT OVERWING DOOR SAFETY LINE IS STARTING TO FRAY. REMOVED LT OVERWING DOOR SAFETY LINE IAW AMM 25-63-04-000-801-A01 & REPLACED LT OVERWING DOOR SAFETY LINE IAW AMM 25-63-04-400-801-A01. TQ WRENCH T001721-02.SDR REXA2014100801046Cowling · wornTASK CARD CRJ900 C1 NR 2 ENG AFT CORE COWL SHOWS WEAR DAMAGE AT PYLON INTERFACE AREA. REPAIRED NR 2 ENG AFT CORE COWL AT PYLON INTERFACE IAW SRM 54-13-00-201-006-A01 BY INSTALLATION OF RUB STRIPS.SDR REXA2014100801045Cowling · wornTASK CARD CRJ900 C1 NR 1 ENG AFT CORE COWL SHOWS WEAR DAMAGE AT PYLON INTERFACE AREA. REPAIRED NR 1 ENG AFT CORE COWL AT PYLON INTERFACE IAW SRM 54-13-00-201-006-A01.SDR REXA2014100801044Block · wornTASK CARD NR 2 ENG AFT CORE COWL ALIGNMENT STANDOFF BLOCK AT 9 O'CLOCK POSITION SHOWS WEAR DAMAGE TO ALIGNMENT TAB. R & R STANDOFF BLOCK IAW SRM 54-13-00-201-0025-A01.SDR REXA2014100801043Block · wornTASK CARD CRJ900 C1 NR 1 ENG AFT CORE COWL ALIGNMENT STANDOFF BLOCK AT 3 O'CLOCK POSITION SHOWS WEAR DAMAGE TO ALIGNMENT TAB. R & R NR 1 ENG AFT COWL ALIGNMENT BLOCK IAW SRM 54-13-00-201-002-A01.SDR REXA2014100801042Access Panel · chafedTASK CARD CRJ900 C1 RIGHT WING INBD FLAP VANE ACCESS PANEL 684ET SHOWS CHAFE DAMAGE. EVALUATED FOUND CHAFE MARK ON PANEL TO BE OUT OF LIMITS. REPLACED PANEL, MATCH DRILL, & INSTALLED CLIPS. PAINTED IAW SRM 57-52-01-101-001-A01, 51-40-11-001-001-A01, 5142-06-SDR REXA2014100801041Access Panel · chafedTASK CARD CRJ900 C1 LEFT WING INBD FLAP VANE ACCESS PANEL 584ET SHOWS CHAFE DAMAGE. EVALUATED FOUND CHAFE MARK ON PANEL TO BE OUT OF LIMITS. REPLACED PANEL, MATCH DRILLED & INSTALLED CLIPS. PAINTED IAW SRM 57-52-01-101-001-A01, 51-40-11-001-001-A01, 51-42-0SDR REXA2014100801040Hand Rail · crackedTASK CARD 900-52-830-500 PASSENGER DOOR FWD HANDRAIL IS CRACKED. R & R FWD HANDRAIL ON PAX DOOR IAW AMM 52-11-05-000-801-A01 & AMM 52-11-05-400-801-A01.SDR REXA2014100801039Rivet · unknownTASK CARD 900-52-830-500 PASSENGER DOOR FWD HANDRAIL HAS RIVETS IN UPPER ARM. R & R FASTENERS IN PAX DOOR HANDRAILS IAW REO 670-52-11-043.SDR REXA2014100801038Panel · damagedTASK CARD 900-25-280-101 WI FI RACK FILTER GUARD PANEL DAMAGED ON UPPER CORNERS. REPAIRED GUARD PANEL ON WI FI RACK IAW EA CRJ 946-02984.SDR REXA2013040800485Structure · crackedLBL 12 IS CRACKED JUST FWD OF THE 280 BEAM, IN THE VERY FWD E & E BAY. REPAIRED LBL 12 BEAM IAW EO R53326.SDR REXA2013040800484Structure · chafedLEFT L/E BLEED LOOP CHAFED STRUCTURE BETWEEN WS 128.00 AND WS 148.01. REPAIRED LEFT L/E BLEED LOOP STRUCTURE BETWEEN WS 128 AND WS148.01 IAW REO 690-57-41-099 AND EO R57098.SDR REXA2013040500483Structure · crackedRBL 12 IS CRACKED JUST FWD OF THE 280 BEAM, IN THE VERY FWD E & E BAY. REPAIRED RBL 12 BEAM IAW EO R53326.SDR REXA2013040200482Structure · corrodedFLT DECK FLOOR LANDING AT FS 280.00, HAS CORROSION ON THE BOTTOM SIDE, IN THE VERY FWD E & E BAY. 900-53-900-300. REMOVED AND REPLACED FLT DECK FLOOR LANDING AT FS 280 IAW CRJ 900 SRM 51-42-06.SDR REXA2013040100481Beam · corrodedLEFT FS 280 CORRODED. 900-53-140-509. REMOVED AND REPLACED LEFT FS 280 BEAM IAW EO R53327 & R53117.SDR REXA2013032100480Beam · corroded900-53-140-509, RIGHT FS 280 CORRODED. REMOVED & REPLACED RIGHT FS 280 BEAM IAW EO R53327 & R53117 & R53127. P/N CC670-34094-2S.SDR REXA2013032100479Doubler · corroded900-53-140-300, ANTENNA DOUBLER HAS CORROSION AT A/C BELLY BETWEEN FRAMES 310 AND 295, IN THE FWD E & E BAY. REPAIRED ANTENNA DOUBLER AT FS 295 & 310 FWD E & E BAY IAW CRJ 900 SRM 51-42-06.SDR MALA110142Relay · malfunctionedEMERGENCY LIGHTS CAME ON RANDOMLY IN FLIGHT AND ON THE GROUND. EMERGENCY LIGHTS ARE ON WITH BOTH FLT DECK AND CABIN SWITCHES IN ARMED POSITION. UNABLE TO TURN EMERGENCY LIGHTS OFF. CYCLED SWITCH. NO HELP. REPLACED RELAY K135, PN YAD4F IAW AMM 20-42-00. SDR MALA110139Relay · malfunctionedSITTING AT GATE WITH EXTERNAL POWER HOOKED UP, EMERGENCY LIGHTS TURNED ON, CYCLED SWITCH EMERGENCY LIGHTS ILLUMINATE WHENEVER SWITCH IS IN THE ARMED POSITION. CIRCUIT BREAKER "CBP2 M17" IS POPPED. INSPECTED ACFT AND FOUND SAFE FOR ONE TIME FERRY FLIGHT FOR FSDR MALA110131Charger · inoperativeUPON ATTEMPTING TO PERFORM RESTORATION AND OPS TEST OF THE ESPU BATTERY PACK, FOUND CHARGER ASSY TO BE BAD. REPLACED ESPU BATTERY CHARGER IAW TASK CARD 33-900-701, AMM 33-51-17, PN 11-0049, SN OFF 23423, SN ON 23214.SDR MALA110024Riser · crackedROUTINE CHECK, AFT PAX DOOR STAIR RISER CRACKED AT RADIUS 2ND STEP FROM TOP. REPAIRED AFT PAX DOOR STAIR RISER AT RADIUS 2ND STEP FROM TOP IAW REO 670-52-11-104.SDR MALA110023Riser · crackedROUTINE CHECK, FWD PAX DOOR STAIR RISER CRACKED AT RADIUS ON 2ND STEP FROM TOP. REPAIRED FWD PAX DOOR STAIR RISER 2ND STEP FROM TOP IAW REO 670-52-11-104. OK FOR SERVICE.
Back to N937XJ