N905XJ
Service difficulty reports · 235
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 = 'N905XJ' 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 = 'N905XJ' 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 REXA2016060601132Panel · corrodedPANEL 193AB HAS CORROSION ON THE RT L/E OF THE PANEL. R & R STRAP CC670-39052-4 AT PANEL 193AB IAW SRM 51-42-13-001-001-A01. NO FURTHER ACTION REQUIRED.SDR REXA2016060601131Channel · crackedPANEL 195DL HAS A CRACKED C-CHANNEL. R & R C-CHANNEL IAW SRM 51-40-11-001-001-A01, 51-42-01-001-001-A01 AND EO R53573.SDR REXA2016060601123Crossbeam · corrodedCORROSION FOUND ON LT CROSSBEAM FS 280. R & R LT FS 280 CROSSBEAM IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-42-22-001-001-A01 & 51-42-13-001-001-A01.
SDR REXA2016060601120Angle · corrodedFS 280 FORWARD J-ANGLE IS CORRODED. R & R J-ANGLE IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01 & 51-42-22-001-001-A01.
SDR REXA2016060601115Drag Angle · crackedRIGHT AFT DRAG ANGLE IS CRACKED APPROXIMATELY 1.5" LT AT FUSE TO VERTICAL CONNECTION. R & R RT AFT DRAG ANGLE IAW SRM 51-42-21-001-001-A01 AND 51-42-22-001-001-A01.SDR REXA2016033100447Knob · missingAFT MEGA PHONE MISSING VOLUME KNOB. INSTALLED NEW KNOB FROM SPARE PARTS KIT & PERFORMED OPERATIONS CHECK IAW AMM 25-67-14 GOOD.SDR REXA2016032500436Light · inoperativeEMERGENCY LIGHTS WILL NOT ILLUMINATE. CHARGED EMER LIGHTS & OPERATIONS CHECKED GOOD IAW AMM 33-51-00-710-802, NO DEFECTS NOTED. ACFT OK FOR SERVICE.SDR REXA2016031300403Glowstrip · missingEMERGENCY FLOOR PHOTO ILLUM TAPE MISSING IN FRONT OF 1ST CLASS. SECURED FLOOR TRACK LIGHTING IAW AMM 33-51-01.SDR REXA2016031300402Tape · missingEMERGENCY REFLECTIVE TAPE MISSING UNDER ROW 13AB & CD. SECURED FLOOR TRACK LIGHTING IAW AMM 33-51-01.SDR REXA2015081400798Light · brokenEMERGENCY FLOOR TRACK LIGHTING A SECTION BROKE OFF AT 12A. R & R EMER FLOOR TRACK LIGHTING IN ROW 12A IAW AMM 33-51-11.SDR REXA2015020500179Battery Pack · dischargedFLIGHT ATTENDANT REPORTS THAT THE FWD GALLEY FLASHLIGHT IS INOPERATIVE. ITEM DEFERRED IAW MEL 25-61-4A C. ENTERED IN MM02, MXC NOTIFIED. R & R BATTERY PACK. OPERATIONS CHECKED GOOD IAW CMM 25-60-02. CLEARED MM02 NR 3185104-1. PLACARD REMOVED.SDR REXA2015020100165Battery · dischargedFLASHLIGHT NOT FLASHING. FLASHLIGHT BATTERY REPLACED IAW CMM 25-60-02. OPERATIONS CHECKED OK.SDR REXA2015011300044Lock Pin · damagedTASK CARD 900-52-830-101 BOTH FWD & AFT MID & LOWER LOCK PINS ON PAX DOOR HAVE DAMAGE. R & R FWD & AFT MID LATCH PINS IAW AMM 52-11-02-000-803-A02 & 52-11-02-400-803-A02. CLEANED FWD & AFT LOWER LATCH PINS IAW AMM 51-26-00-110-801-A01. NO DAMAGE NOTED. PERFSDR REXA2015011100043Cowling · chafedTASK CARD 900-26-440-100 NR 2 ENG AFT CORE COWL CHAFED AT MATING SURFACE WITH PYLON. REPAIRED NR 2 AFT CORE COWL & REP STANDOFF & RUB PAD IAW SRM 54-13-00-201-006-A01.SDR REXA2015011000042Hinge Fitting · damagedTASK CARD 900-71-430-100 LT ENG FWD UPPER CORE COWL BLOW OUT DOOR LOWER HINGE ARM DAMAGED & LATCH STRIKE PLATE CHAFED. CLEANED HINGE ARM IAW SRM 51-26-00-001-001-A01 NO DAMAGE NOTED. R & R LATCH REINFORCING PLATE IAW SRM 51-40-11-001-001-A01, 51-42-13-001-00SDR REXA2015011000041Hinge Fitting · damagedTASK CARD LT ENG FWD LOWER CORE COWL BLOW OUT DOOR LOWER HINGE ARM DAMAGED & STRIKE PLATE CHAFED. R & R HINGE ARM LEVER IAW AMM 71-12-05-000-801-A01 & 71-12-05-400-801-A01. R & R LATCH REINFORCING STRIKER PLATE IAW SRM 51-42-06-001-001-A01 & 51-42-10-001-001SDR REXA2015011000040Plate · damagedTASK CARD 900-71-440-100 RT ENG UPPER FWD CORE COWL BLOW OUT DOOR UPPER HINGE ARM DAMAGED & LATCH STRIKER PLATE CHAFED. CLEANED LATCH ARM IAW SRM 51-26-00-001-001-A01 NO DAMAGE NOTED. R & R LATCH REINFORCING PLATE IAW SRM 51-40-11-001-001-A01, 51-42-13-001-0SDR REXA2015011000039Hinge Fitting · damagedTASK CARD 900-71-440-100 RT ENG LOWER FWD CORE COWL BLOW OUT DOOR UPPER HINGE ARM DAMAGED & LATCH STRIKER PLATE CHAFED. R & R RT ENG LOWER FWD CORE COWL BLOW OUT DOOR UPPER HINGE ARM & LATCH STRIKER PLATE IAW SRM 51-40-11-001-001-A01, 51-42-10-001-001-A01, 51SDR REXA2015010900038Transcowl · dentedTASK CARD 900-54-430-300 LT NACELLE, DENT ON LOWER TRANS COWLING. COMPLIED WITH EA 954-03188.SDR REXA2015010900037Panel · chafedTASK CARD 192 PANEL 684EB HAS CHAFING MARKS. REPLACED DAMAGED PANEL 684EB IAW SRM 51-40-11-001-001-A01. TO BE REINSTALLED ON 192 PANEL CARD TALLY 304. SEE ATTACHED COPY TALLY SHEET.SDR REXA2015010900036Seat Track · corrodedTASK CARD 90-53-900-101 LT SIDE INBD SEAT RAIL FWD END NEAR FS 379.00 CORRODED. MECH FOUND LT SIDE INBD SEAT RAIL TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R SEAT RAIL IAW AMM 53-00-49-000-801-A07 STEP 4 B & AMM 53-00-49-400-801-A07 STEP 4 B 1 & 20-21-0SDR REXA2015010800035Rack · tornWIFI RACK HAS TORN METAL AT UPPER RT SIDE, MECH REPAIRED WIFI RACK SIDE PANEL IAW ENDEAVOR AIR EA CRJ946-03189.SDR REXA2015010800034Cover · missingRT WING OTBD FLAP, OTBD LIGHTING HOLE COVER MISSING. INSTALLED MISSING COVER IAW RIL 3104.SDR REXA2015010700033Channel · looseMLG FAIRING RT VERTICAL CHANNEL IS LOOSE WHERE IT SECURES TO THE LOWER SUPPORT CHANNEL. R & R RT VERTICAL SUPPORT CHANNEL IAW SRM 51-42-20-001-001-A01.SDR REXA2015010700032Channel · looseMLG FAIRING LT VERTICAL SUPPORT CHANNEL IS LOOSE. R & R LT VERTICAL SUPPORT CHANNEL IAW SRM 51-42-20-001-001-A01.SDR REXA2015010700031Structure · crackedPAX DOOR CRACKED ON AFT WALL AT BOTTOM OF UPPER STEP SUPPORT BY HAND RAIL RETAINER CUP. REPAIRED IAW EO R52022.SDR REXA2015010700030Structure · crackedPAX DOOR CRACKED ON FWD WALL AT BOTTOM OF UPPER STEP SUPPORT BY HAND RAIL RETAINER CUP. REPAIRED IAW EO R52022.SDR REXA2015010600029Panel · chafedPANEL 584 ET CHAFED. BLENDED CHAFED AREA AND FOUND TO BE OUT OF LIMITS IAW SRM 57-52-01-101-001-A01. LOCATED AND DRILLED NEW PANEL IAW SRM 51-40-11-001-001-A01. PRIMED AND PAINTED PANEL IAW SRM 51-25-01-001-001-A01.SDR REXA2015010600028Floor Support · corrodedLIGHT CORROSION ON RT SIDE FLOOR SUPPORT FROM BS 280 - 310. REPAIRED IAW EO R53519SDR REXA2015010500027Seat Track · corrodedRT SIDE SEAT TRACK CORRODED. BLENDED AND FOUND TO BE WITHIN LIMITS IAW REO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND AMM 53-00-49-400-801-A07. ALODINED AND MARKED BLENDED AREA IAW REO 670-53-00-013.SDR REXA2015010500026Seat Track · gougedRT SIDE SEAT TRACK GOUGED IN FOUR PLACES BETWEEN BS 453 - 565. BLENDED AND FOUND TO BE WITHIN LIMITS. ALODINED AND MARKED IAW REO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND AMM 53-00-49-400-801-A07.SDR REXA2015010500025Seat Track · gougedLT SIDE SEAT TRACK GOUGED NEAR BS 661. BLENDED AND FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A07 AND AMM 53-00-49-400-801-A07.SDR REXA2015123000014Sign · crackedEXIT SIGN ON BACK OF WARDROBE IS CRACKED. MECH R & R EXIT SIGN ON BACK OF WARDROBE IAW AMM 33-51-05-000-801-A01 4D 1-6 AND AMM 33-51-05-400-801-A31, STEP 4D-1-4. OPS TEST OF EMERGENCY LIGHT GOOD IAW AMM 33-51-00-710-802-A16.SDR REXA2014091900964Battery · dischargedAFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED AFT EMER FLASHLIGHT BATTERY IAW AMM 25-60-01. OPERATIONS CHECKED GOOD.SDR REXA2014080500749Light · inoperativeRIGHT AFT EXTERIOR EMER LIGHT INOPERATIVE. R & R RT AFT EXTERIOR EMER LIGHT IAW AMM 33-51-15. OPERATIONS CHECKED GOOD PN 8GH005086-06.SDR REXA2013112402185Life Vest · missingTWO INFANT LIFE VESTS MISSING FROM LOWER WARDROBE AFT COMPARTMENT. INSTALLED TWO NEW INFANT LIFE VESTS TO LOWER AFT WARDROBE COMPARTMENT IAW TASK CARD EE-900. ALL CHECKED GOOD, PN ON P0640-101.SDR REXA2013071701411Skin · damagedPAX DOOR CUT OUT AT FS 349 UPPER CORNER SKIN OF FUSELAGE IS DAMAGED. REPAIRED PAX DOOR CUT OUT IAW REO 690-53-21-501, EO 53434.SDR REXA2013071701410Support · gougedAFT WING FUSELAGE SUPPORT STRUCTURE RT FRAME AT FS 847+32.00 GOUGED AND DEFORMED AT THE HYD SYS 3 BLEED/RELIEF VALVE. REMOVED GOUGE ON FUSELAGE SUPPORT STRUCTURE RT FRAME DENT IS ACCEPTABLE AS IS IN LIMITS IAW REO690-53-82-044.SDR REXA2013071601409Floor Support · crackedLEFT FLT DECK FLOOR PANEL LANDING CRACKED JUST FWD OF FS 280 CROSSBEAM. REPAIRED FLT DECK FLOOR PANEL LANDING IAW EO R53428 & SRM 51-40-11. CR3213-4-2, CR3212-4-2, CR3223-5-2, CR3523-5-2, CC670-33199-3.SDR REXA2013071601408Tab · brokenDURING INSTALLATION OF RT INBD SLAT DISCONNECT SENSOR, FOUND POSITIONING TAB BROKE OFF. REPAIRED RT INBD SLAT DISCONNECT SENSOR POSITIONING TAB IAW EO R57133.SDR REXA2013071101407Spacer · corrodedAT RADIO ALTIMETER TRANSMIT NR 1 ANTENNA FUSELAGE SPACER PITTED. REPAIRED NR 1 RADIO ALT SPACER.SDR REXA2013070601406Latch · damagedLT UPPER TRANSCOWL HAS TWO CHAFED LATCH PLATES. R & R LT UPPER TRANSCOWL LATCH PLATES IAW SRM 51-42-06.SDR REXA2013070501405Stiffener · bentFS 280 BULKHEAD, LT, AFT FACE, UPPER AND LOWER MOST STIFFENERS BENT. EDGE BLENDED FS 280 BULKHEAD LT AFT FAIRING UPPER AND LOWER MOST STIFFENERS IAW SRM 53-00-00 ORG. LENGTH 0.75 REMAINING 0.735 MATERIAL LOSS 0.015 FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00. SDR REXA2013070301404Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. REPAIRED PAX DOOR AFT DRAG ANGLE IAW SRM 52-11-04.SDR REXA2013070301403Panel · chafedPANEL 584EB IS CHAFED. LOCATED & DRILLED NEW PANEL IAW SRM 51-40-11.SDR REXA2013062801402Skin · dentedSMALL DENT BETWEEN BS 409-421 STRINGERS 16-17R. REMOVED DENT IAW EO R53423.SDR REXA2013062801401Unknown · corrodedFS 295 CORRODED AT STRINGER 27. REPAIRED IAW EO R53435.SDR REXA2013062801400Doubler · corrodedFWD TCAS ANTENNA DOUPLER CORRODED. R & R FWD TCAS ANTENNA DOUBLER IAW SRM 51-42-06.SDR REXA2013062801317Stringer · corrodedSTRINGER 26R AFT OF FS 333 CORRODED. R & R STRINGER IAW SRM 51-42-AND SRM 51-42-06.SDR REXA2013062801316Diaphragm · corrodedRIGHT INBD DIAPHAGM AFT OF FS 349 CORRODED. R & R CORRODED RT INBD DIAPHRAM IAW SRM 51-42-06 AND SRM 51-42-21.
Back to N905XJ