N917XJ
Service difficulty reports · 245
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 = 'N917XJ' 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 = 'N917XJ' 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 REXA2013092501958Blowout Door · chafedNR 1 ENGINE, LOWER CORE COWL BLOW OUT DOOR, STRIKER PLATE IS CHAFED. R & R NR 1 ENG LOWER CORE COWL CLOWOUT DOOR LATCH STRIKER IAW SRM 51-42-06 AND 51-42-13.SDR REXA2013092501957Hinge · gougedPASSENGER DOOR HINGE IS GOUGED ON ACFT SIDE, AFT END OF HINGE. REMOVED GOUGE ON PASSENGER DOOR HINGE AT AFT END AND IS IN LIMITS IAW EA 953-01951 AND IS IN LIMITS IAW EO R53499.SDR REXA2013092501956Vane · damagedLT INBD FLAP INBD VANE L/E PANEL IS CHAFED. REPLACED LT INBD FLAP INBD VANE PANEL IAW SRM 51-40-11.SDR REXA2013092501955Skin · damagedSKIN AND ATTACHING FASTENER HAVE BEEN BLENDED AND HAS PIN HOLE AT STRINGER 17L, BETWEEN FS 394 AND 409. REPAIRED SKIN IAW EOR53504.SDR REXA2013092501954Arm · gougedMID CARGO DOOR, AFT LOWER HINGE ARM IS GOUGED. REMOVED GOUGE ON MID CARGO LOWER AFT HINGE ARM AND IS IN LIMITS IAW EA CRJ952-01960.SDR REXA2013092501953Web · chafedMID CARGO DOOR, INNER WEB IS CHAFED ON BOTH FWD & AFT LOWER CORNERS. BLENDED CHAFE MID CARGO INNER WEB AT FWD AND AFT CORNERS AND IS IN LIMITS IAW EA CRJ952-01960.SDR REXA2013092501952Retainer · bentMID CARGO DOOR, INNER LOWER SEAL RETAINER IS BENT. R & R RETAINER IAW AMM 52-35-07, REM MM 409 NR 362987. OPS CHECK IAW AMM 52-00-00 CHECK GOOD PN LE670-39647-1.SDR REXA2013092501951Retainer · gougedMID CARGO DOOR, LOWER OUTER SEAL RETAINER, IS GOUGED ON FWD & AFT LOWER CORNERS. R & R REAINER IAW SRM 51-42-06. OPS CHECKED IAW AMM 52-00-00, CHECKED GOOD.SDR REXA2013092501950Arm · gougedMID CARGO DOOR, LOWER FWD HINGE ARM IS GOUGED SM-82. REMOVED GOUGE ON MID CARGO LOWER FWD HINGE ARM AND IS IN LIMITS IAW EA CRJ952-01960.SDR REXA2013092501949Retainer · gougedMID CARGO DOOR, UPPER OUTER SEAL RETAINER IS GOUGED AND DENTED. R & R RETAINER IAW SRM 51-42-06. REF MM 409 362974. OPS CHECKED IAW AMM 52-00-00, CHECKED GOOD,SDR REXA2013092501948Web · chafedFWD CARGO DOOR INNER WEB IS CHAFED ON LOWER FWD & AFT CORNERS. BLENDED CHAFE ON FWD CARGO INNER WEB AND IS IN LIMITS IAW EA CRJ 952-01961, REF MESABA MM409 362971, PN CR3213-5-3.SDR REXA2013092501947Retainer · bentFWD CARGO DOOR, LOWER INNER SEAL RETAINER IS BENT ON FWD LOWER CORNER. R & R RETAINER IAW AMM 53-35-07, REF MM 409 363311. C/W OPS CHECK IAW AMM 52-00-00 CHECK GOOD, PN LE670-39647-1.SDR REXA2013092501946Retainer · gougedFWD CARGO DOOR, LOWER OUTER SEAL RETAINER IS GOUGED AND BENT ON LOWER FWD & AFT CORNERS. R & R RETAINER IAW SRM 51-42-06. REF MM 409 363310. C/W OPS CHECK IAW AMM 52-00-00 CHECK GOOD PN NAS1097AD4-4, LE670-39644-1.SDR REXA2013092501945Web · corrodedCORROSION FOUND ON PAX DOOR AFT WEB AT FASTENER HOLES UPPER HINGE STEP. REMOVED GOUGE ON FWD CARGO DOOR FWD LOWER HINGE ARM AND IS IN LIMITS IAW EA CRJ952-01959. REMOVED CORROSION IAW EA CRJ952-01952SDR REXA2013092501944Web · corrodedPASSENGER DOOR AFT WEB HAS CORROSION AROUND FASTENERS AT UPPER HINGED STEP. REMOVED CORROSION IAW EA CRJ952-01952.SDR REXA2013092501943Web · corrodedPASSENGER DOOR FWD WEB HAS CORROSION AROUND FASTENERS AT UPPER HINGED STEP. REMOVED CORROSION IAW EA CRJ952-01952.SDR REXA2013092501942Plate · chafedPASSENGER DOOR UPPER FWD GUIDE PLATE IS CHAFED. BLENDED CHAFE ON PAX DOOR UPPER FWD GUIDE PLATE IN LIMITS IAW EO R52097. GAP CHECK GOOD IAW MM 52-11-00. REF MM 409 363326 PN MM409 363326, PN MS20426AD6-8.SDR REXA2013092501940Plate · corrodedREPLACED RADAR ALTIMETER NR 1 TRANSMITTER ANTENNA BASE PLATE IAW SRM 51-42-06. BLENDED CHAFE UPPER AFT GUIDE PLATE AND IS IN LIMITS IAW EO R52097. GAP CHECKED GOOD IAW MM 52-11-00.SDR REXA2013092501939Plate · corrodedRADAR ALTIMETER NR 1 TRANSMITTER ANTENNA BASE PLATE CORRODED. REPLACED BASE PLATE IAW SRM 51-42-06, PN MM670-70326-003,SDR REXA2013092501938Drag Angle · crackedPASS DOOR AFT DRAG ANGLE IS CRACKED. REPAIRED & REPLACED DRAG ANGLE SRM 92-11-04.SDR REXA2013092501933Light · inoperativeRT FWD EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED RT FWD EXTERIOR OVERWING EMERGENCY EXIT LIGHT, INSTALLED GROUND TO GS846 AND REINSTALLED RT FWD EXTERIOR OVERWING EMERGENCY EXIT LIGHT IAW AMM 33-51-15 & WM 33-50-01. OPS CHECKED GOOD.SDR REXA2012123001601Life Vest · missing2 (TWO) INFANT LIFE VESTS MISSING. FROM DMR: MEL 2397676-1 2 INFANT VESTS MISSING. REPLACED INFANT VEST PER AMM 25-61-03.SDR MALA110246Light · unsecureEMERGENCY LIGHT IN GALLEY ARE COMING OFF OF FLOOR. R & R EMERGENCY STRIPS FRONT OF GALLEY IAW AMM 33-51-01.SDR MALA110200Glowstrip · missingFLOOR GLOWSTRIP IN FRONT OF FWD WASTE BASKET IS MISSING. INSTALLED SMALL SECTION OF GLOW STRIP ON FLOOR FRONT OF WASTE BASKET. PN PL88-900LH00 BASE; FILM PN PL88-930LH05 & CLIP PN PL88-910LH00.SDR MALA110193Handle · crackedPAX DOOR OUTER HANDLE CRACKED. REPLACED OUTER PAX DOOR HANDLE IAW EO R52027 AND SB 670BA-52-030, REV C.SDR MALA110195Coax · corrodedTCAS OMNI DIRECTIONAL ANTENNA COAXIAL CABLE IS CORRODED. REMOVED AND INSTALLED NEW CONNECTOR IAW ESPM 20-26-00. PERFORMED OPS TEST OF THE TCAS IAW AMM 34-43-00-710-801 (A02). OPS CHECKED GOOD.SDR MALA110194Antenna · corrodedTCAS OMNI DIRECTIONAL ANTENNA IS CORRODED. REMOVED AND INSTALLED NEW ANTENNA IAW AMM 34-43-02-000-801 IAW FORMED OPS CHECK. OPS CHECK GOOD.SDR MALA110211Track · misinstalledAFT CARGO DOOR TRACK INTERCONNECT STRUCTURE HAS BEEN CUT INTO BY THE DOOR CABLE IMPROPERLY INSTALLED ON PULLEY. REPAIRED AFT CARGO DOOR TRACK INTERCONNECT STRUCTURE IAW EO R53145 AND BBD REO 690-53-61-195.SDR MALA110210Drag Angle · gougedPAX DOOR AFT DRAG ANGLE UPPER CUT-LINE HAS GOUGE ON INNER SKIN. REPAIRED INNER SKIN TO IAW EO R52037 AND BBD REO 690-52-11-162.SDR MALA110209Fitting · corrodedGALLEY 2 FWD INBD FITTING CORRODED. R & R FWD INBD FITTING ON GALLEY 2 IAW CMM 25-34-12.SDR MALA110192Sill · corrodedRT FLOOR SILL PLATE BETWEEN 310-319 CORRODED FOUND DURING REMOVAL 232BRF FOR INSP. REPAIRED FLOOR SILL PLATE BETEEWN FS310-315 IAW EO R53143 AND BBD REO 690-53-21-218.SDR MALA110191Drag Angle · crackedASD AFT DRAG ANGLE CRACKED, MOTOR CABLE GUIDE. REPAIRED ASD AFT DRAG ANGLE IAW EO 52026 AND REO 670-52-11-072, REV E.SDR MALA110208Angle · corrodedSERVICE DOOR SILL UPPER CAP ANGLE HAS CORROSION. REMOVED UPPER ANGLE FROM THRESHOLD IAW SRM 51-42-06-001-001-A01. INSTALLED NEW ANGLE IAW SRM 51-42-06-001-001-A01.SDR MALA110207Angle · corrodedSERVICE DOOR ENTRY WAY SILL PLATE CORRODED FOUND DURING REMOVAL OF 232BRF FOR INSP. R & R SERVICE DOOR ENTRY WAY SILL PLATE ANGLE PN SH670-31996-3 IAW SRM 51-52-06-001-001, 51-42-21-001-001, AND 51-40-11-001-001.SDR MALA110206Hinge · corrodedFWD LAV SERVICE DOOR HINGES ON FUSELAGE CORRODED. REPLACED FWD LAV SERVICE DOOR HINGES IAW SRM 51-42-06-001-001-A01.SDR MALA110205Skin · corrodedFOUND SURFACE CORROSION AT STA 980-985 BETWEEN STR 24R AND 23R ON THE OUTER SKIN. REMOVED SURFACE CORROSION, ORIGINAL MATERIAL THICKNESS .110. REMOVED .012 MATERIAL REMAINING .098 WITHIN LIMITS IAW SRM 53-61-01, FIG 53-61-01-991-844. MINOR REPAIR.SDR MALA110204Skin · corrodedCORROSION IN BELLY JUST FWD OF FS 364.00 S27L. REMOVED CORROSION FROM BELLY SKIN AS REQUIRED IAW SRM 51-21-06-001-001-A01. MINOR REPAIR. REPLACED RIVETS REMOVED FOR CORROSION TREATMENT IAW SRM 51-42-06.SDR MALA110196Pin · damagedHORIZONTAL STAB PINS, BOTH OUTER AND 1 INNER HAVE FRICTION MARKS. REPLACE ALL 3. R & R BOTH OUTER AND INNER HORIZONTAL STAB PINS IAW REO 690-55-11-006. INNER PIN-AV670-53179-003; OUTER PIN-AV670-23178-003.SDR MALA110190Floor Panel · crackedFWD EQUIPMENT COMPARTMENT FLOOR PLATE CRACKED AT WL79.50 AT FS 193.0 ON RT SIDE UNDER ADG, RETRACTION PUMP. REMOVED ELECTRICAL BOX ATTACHING HARDWARE IAW AMM 24-41-01-000-801-A02. REMOVED PROTECTIVE PANEL IAW SRM 900 51-42-02-001-001, C/W REO 670-53-11-509 &SDR MALA110203Skin · corrodedCORROSION IN BELLY OF ACFT AT TCAS ANTENNA BETWEEN FS 295 - FS 310. REMOVED CORROSION ON TCAS ANTENNA DOUBLER IAW SRM 51-21-06-001-001-A01. REMOVED AND INSTALLED 6 STY RIVETS IAW SRM 51-42-06-01-001-A01.SDR MALA110202Floor Support · corrodedFLOOR PANEL 221ALF SUPPORT FRAME CORRODED. CLEANED CORROSION W/ MINIMAL MATERIAL LOSS TREATED, PRIMED & TOP COATED IAW SRM 51-21-06 AND SRM 51-21-11-001-A01.SDR MALA110201Skin · chafedBELLY OF FUSELAGE CHAFED AT APPROX FS 916.00. REPAIRED DAMAGE ON FUSELAGE AT FS 916.00 IAW REO670-53-00-014.SDR MALA100162Charger · defectiveDURING INITIAL CLIMBOUT FROM MSP "EMER LTS ON" WHILE STATUS MESSAGE ILLUMINATED AND WAS INTERMITTENT. BOTH F/A STATED THE OVERWING EMERGENCY EXIT LIGHTS (ALL 4) WERE FLICKERING. IN CRUISE FLIGHT ALL INDICATIONS WERE NORMAL. DURING DESCENT LIGHTS CAME ON ONCSDR MALA100149Glowstrip · damagedFOUND 2 SECTIONS OF GALLEY FLOOR EMERGENCY FLOOR TRACK GLOW STRIPS SEVERELY DAMAGED. REPLACED DAMAGED GALLEY FLOOR TRACK GLOW STRIPS IAW AMM 33-51-01.SDR MALA100011Strut · dischargedGEAR DISAGREE WARNING DURING RETRACTION. SERVICED STRUT; INSPECTED; GEAR SWINGS, NO FAULTS FOUND.
Back to N917XJ