N934XJ
Service difficulty reports · 221
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 = 'N934XJ' 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 = 'N934XJ' 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 REXA2013033100471Seat Track · corrodedLEFT SIDE SEAT TRACK NR 7 CORRODED. REMOVED AND REPLACED LEFT 7 SIDE SEAT TRACK IAW CRJ900 AMM 53-00-49. P/N SH670-36260-5.SDR REXA2013033100470Seat Track · corrodedRIGHT SIDE SEAT TRACK NR 7 CORRODED. REMOVED AND REPLACED RIGHT 7 SIDE SEAT TRACK IAW CRJ900 AMM 53-00-49. P/N SH670-36260-5.SDR REXA2013033100469Seat Track · corrodedRIGHT SIDE SEAT TRACK NR 6 CORRODED. REMOVED AND REPLACED RIGHT 6 SIDE SEAT TRACK IAW CRJ900 AMM 53-00-49. P/N SH690-36284-1.SDR REXA2013033100468Seat Track · corrodedRIGHT SIDE SEAT TRACK NR 5 CORRODED. REMOVED AND REPLACED RIGHT 5 SIDE SEAT TRACK USING T/W 521962 DD 07-25-2013 IAW CRJ900 AMM 53-00-49. P/N SH690-36284-1.SDR REXA2013033100467Skin · corrodedEXTERNAL FUSELAGE - SKIN AND RIVETS CHAFED AT S-27 BETWEEN STA 913-927. REPAIRED FUSELAGE SKIN IAW EO R53325.SDR REXA2013033100466Angle · corrodedPAX DOOOR FLOOR LANDING CORRODED. REMOVED AND REPLACED LANDING ANGLE IAW CRJ900 SRM 53-21-23 AND CRJ900 SRM 51-41-02. P/N SH670-31825-9S.SDR REXA2013033100465Angle · corrodedPAX DOOR SILL KICKPLATE ANGLE CORRODED. REMOVED AND REPLACED KICKPLATE ANGLE IAW CRJ900 SRM 51-42-06.SDR REXA2013033100464Web · crackedRBL 12 WEB IS CRACKED JUST FWD OF 280 BEAM BELOW WL 72.50. REPAIRED CRACKED RBL 12 BEAM IAW EO R53318.SDR REXA2013033100463Web · crackedLBL 12 WEB IS CRACKED JUST FWD OF 280 BEAM BELOW WL 72.50. REPAIRED CRACKED LBL 12 BEAM IAW EO R53318.SDR REXA2013033100462Fairing · brokenLEFT ENGINE UPPER HINGE FAIRING BROKE. FABRICATED REPAIR PANEL FOR LEFT ENGINE UPPER AFT HINGE LINE FAIRING IAW CRJ900 SRM 51-90-11.SDR REXA2013033100461Skin · damagedCOMPLETE REPAIR DAMAGE AT LOWER WING CENTER PANEL AT FS 710.0 AND LBL 22.5 AND LOWER FUSELAGE SKIN AT FS 517 AND STR 26L WITHIN 2100 FLT HRS. COMPLIED WITH PERMANENT REPAIR TO FUSELAGE SKIN LEFT SIDE FROM FS 500 - 517 STR 26L-27 IAW EO R53321 AND PERMANENT RESDR REXA2012122801598Charger · inoperativeFWD EMERGENCY LIGHT STAYS LIT. REMOVED AND REPLACED BATTERY CHARGER ASSY. OPS CHECK GOOD IAW AMM 33-51-17. BATTERY CHARGER ASSY P/N ON/OFF 11-0049, S/N ON 22194, S/N OFF 23214.SDR REXA2012111101561Relay · faultyEMERGENCY LIGHTS ON, EICAS STATUS MESSAGE COMES ON OCCASIONALLY THEN DOES OUT. LIGHTS COME ON TOO. REPLACED RELAY K198 P/N M83536/17-002L. RELAY K135 P/N YAD4F IAW ESPM 20-39-09 PERFORMED OPS CHECK IAW AMM 24-06-11 AND 24-51-00, OPS CHECK GOOD.SDR REXA2012101700980Light · looseEMERGENCY PATH LIGHTING STRIP 13A/B NEEDS TO BE RE-SECURED. REPLACED EMERGENCY PATH LIGHTING STRIP ON 13 A/B PER AM 20-00-0.SDR MALA110188Light · intermittentIN FLIGHT, EMERGENCY LIGHTS CAME ON TWICE, RESET AT F/A STATION OK. PERFORMED OPS CHECKS OF EMERGENCY LIGHTING SYSTEM IAW AMM 33-51. ALL CHECKS GOOD.SDR MALA110187Unknown · malfunctionedEMERGENCY LIGHTS ON STATUS MESSAGE DISPLAYED WHEN EMERGENCY LIGHTS ARE NOT ON - ALSO WHEN EMERGENCY LIGHTS ARE SELECTED TO OFF CAUTION MESSAGE EMERG LIGHTS OFF IS NOT ON. CYCLED POWER AND CYCLED EMERGENCY LIGHT SWITCH. OPS CHECK GOOD. REF AMM 33-51-00. SWISDR MALA110186Battery Pack · failedFWD GALLEY AND EXIT EMERGENCY LIGHTS REMAINED ON, EVEN AFTER RESET PROCEDURES. R & R ESPU BATTERY PACK AT PS35 LOCATION IAW JOB CARD 33-900-701.SDR MALA110159Battery Pack · inoperativeWHEN DEPOWERING THE ACFT, THE EMERGENCY LIGHTS COME ON. REPLACED EMERGENCY LIGHT BATTERY AND CHARGER AT PS35 POSITION. BATTERY, PN 2013-1A, SN ON 102620. CHARGER, PN11-0049, SN ON 23214. REF AMM CH 33-51-00. ALL CHECKS GOOD.SDR MALA110158Light · inoperativeEMERGENCY LIGHTS/SIGNAGE REMAINS ILLUMINATED AFTER DE-POWERED IN FWD EXITS. CYCLED CB M12 AND PERFORMED OPS CK OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS CK GOOD. RELEASED ACFT FOR SERVICE.SDR MALA110004Skin · chafedCHAFE DAMAGE FOUND IN 3 PLACES AT FS 913,00 AND FS 927,00 STR 27 FIRST AREA IS .3750 X 0,014" DEEP SECOND AREA .1250 X .1250 X 0.030 DEEP THIRD AREA IS .1250 X .1250 X 0.009 DEEP. REPAIRED CHAFE DAMAGE BY BLENDING AREA AND APPLYING A TOP COAT TO THE FUSELAGE SDR MALA100181Battery Pack · dischargedEMERGENCY LIGHTS STAY ON, WITH SWITCH IN OFF POSITION WITH POWER AND BATT IN OFF POSITION. NOTED ONLY FWD EMERGENCY LIGHTS STAYING ON. REPLACED FWD EMERGENCY LIGHTS BATTERY PACK PN ON/OFF 20113-1A SN ON 95493 SN 101252 OPS CHECK GOOD.
Back to N934XJ