N903XJ
Service difficulty reports · 234
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 = 'N903XJ' 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 = 'N903XJ' 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 REXA2013060500961Doubler · corrodedANTENNA DOUBLER CORRODED AT FS 300 & S27. R & R TCAS DOUBLER IAW SRM 51-42-06.SDR REXA2013060500960Stringer · corrodedFWD EQUIPMENT BAY STRINGER 26R FS 349 CORRODED. R & R STRINGER 26R BETWEEN FS 333 AND FS 364 IAW SRM 51-42-06.SDR REXA2013060500959Support · cutAFT CARGO BAY DOOR TRACK SUPPORT CROSSBEAM CUT BY AFT COUNTERBALANCE CABLE. REPAIRED IAW EO R53377.SDR REXA2013060400958Structure · chafedLT AILERON LOWER L/E CHAFED. REPAIRED AILERON IAW EO R57117.SDR REXA2013060400957Structure · corrodedMAIN ENTRY DOOR PANEL LANDING CORRODED. R & R PANEL LANDING IAW SRM 51-41-02.SDR REXA2013060400956Skin · gougedLOWER FUSELAGE SKIN PANEL AND RIVET GOUGED AT S27 BETWEEN FS 913 AND 927. REPAIRED SKIN PANEL IAW EO R53383.SDR REXA2013060400955Fitting · chafedRT WHEEL WELL AFT OTBD WING TO BODY FITTING CHAFED. REPAIRED CHAFED AREA ON RT WING TO BODY FITTING IN WHEEL WELL IAW REO 690-57-11-021 AND EO R57119.SDR REXA2013060400954Fitting · chafedLT MLG WHEEL WELL AFT OTBD WING TO BODY FITTING CHAFED. REPAIRED CHAFED AREA ON OTBD WING TO BODY FITTING IN LT WHEEL WELL IAW REO 690-57-11-021 AND EO R57119.SDR REXA2013060400953Stringer · corrodedFWD EQUIPMENT BAY, RT STRINGER SPLICE 25R FS 333 CORRODED. R & R STRINGER IAW SRM 51-42-06.SDR REXA2013060400952Stringer · corrodedON REMOVAL OF CORRODED STRINGER SPLICE, CORROSION FOUND ON STRINGER 25R FROM FS 280 - 333. R & R STRINGER IAW SRM 51-42-06.SDR REXA2013060300951Angle · corrodedSERVICE DOOR OTBD SEAL ANGLE CORRODED. R & R SERVICE DOOR OTBD SEAL ANGLE IAW SRM 51-42-06.SDR REXA2013060300950Angle · corrodedSERVICE DOOR FOUR MOUNTING BRACKET ANGLES CORRODED. R & R MOUNTING BRACKET ANGLES IAW SRM 51-42-20.SDR REXA2013060300949Crossbeam · corrodedFS 280 CROSSBEAM TOPCAP BLIND FASTENERS CORRODED. R & R RT FS 280 CROSSBEAM IAW EO R53381 & R53117 & R53127.SDR REXA2013060300948Floorbeam · corrodedLEFT FS 280 FLOORBEAM CORRODED AT INBD FLOORBOARD NUTPLATE HOLE. R & R LT FS 280 FLOORBEAM IAW EO R53381 & R53117 & R53127.SDR REXA2013060200947Bulkhead · crackedON REMOVAL OF LT FS 280 BEAM CORROSION FOUND ON BULKHEAD WEB. REPAIRED BULKHEAD WEB IA EO R53382.SDR REXA2013053000946Angle · corrodedSERVICE DOOR INBD FLOOR ANGLE CORRODED. R & R SERVICE DOOR INBD FLOOR ANGLE IAW SRM 51-42-06.SDR REXA2013052900945Panel · crackedPASSENGER DOOR AFT PANEL IS CRACKED AT BOTTOM CORNER OF TOP RISER. REPAIRED CRACK ON PAX DOOR AFT RISER PANEL AT BOTTOM CORNER OF TOP RISER IAW REO 670-52-11-104.SDR REXA2013052800944Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE IS CRACKED. REPAIRED CRACK ON PAX DOOR AFT DRAG ANGLE IAW SRM 52-11-04.SDR REXA2013052600943Panel · chafedPANEL 584ET CHAFED. BLENDED FOUND TO BE IN LIMITS REFINISHED IAW SRM 57-52-01.SDR REXA2013052600942Skin · damagedHINGE LINE FAIRING 432BB HAS DEEP GOUGE. REPLACED SKIN ON HINGE LINE FAIRING 432BB IAW SRM 51-24-16.SDR REXA2013052600941Fairing · crackedHINGE LINE FAIRING 442BB CRACKED AT FASTENER HOLE AND GOUGED. FABRICATED REPLACEMENT FAIRING 442BB IAW SRM 51-40-11 + SRM 51-21-16.SDR REXA2013042200517Light · defectiveFORWARD GALLEY AREA EMERGENCY FLOOR PATH LIGHTING MISSING FILM ON LT & RT SIDES. REMOVED & REPLACED GALLEY LT & RT EMERGENCY FLOOR PATH LIGHTING, P/NS ON & OFF PL88-900LH00, PL88-930LH05, & PL88-910LH00, IAW CRJ900 AMM 33-51-01. PHOTO LUMINESCENCE OPS CHECKSSDR REXA2012122901600Light · looseFLOOR TRACK LIGHTING AT 12 A/B IS LOOSE. SECURED EMERGENCY FLOOR TRACK LIGHT IAW AMM 33-51-01.SDR REXA2012121201580Flashlight · inoperativeDURING FLIGHT ATTENDANT PREFLIGHT DISCOVERED TAN EMERGENCY FLASHLIGHT BY SPARE FLIGHT ATTENDANT JUMP SEAT IS NOT WORKING (BY SERVICE DOOR). DEFERRED GALLEY RIGHT FLASHLIGHT IAW MEL 25-61-4A REPAIR CATEGORY C. ENTERED IN DMR MXC NOTIFIED 1390. REMOVED AND RESDR REXA2012050700080Light · missingF/A REPORTS AN AREA OF FLOOR TRACK LIGHTING IS MISSING NEAR LAV AREA (FORWARD LAV). REQUEST INSPECTION. MXC/DISPATCH NOTIFIED. REPLACED EMERGENCY FLOOR PATH LIGHTING IN THE FORWARD GALLEY AREA IAW AMM 33-51-02. MXC NOTIFIED.SDR REXA2012032900056Charger · failedEMERGENCY LIGHTS FAIL OPS CHECK. REMOVED AND REPLACED EPSU BATTERY CHARGER 1 IN THE AVIONICS COMPARTMENT AT FS 310.00 IAW AMM 33-51-17. REFERENCE CONTINUATION FOR DETAILS.SDR MALA110132Structure · crackedCRACKED FLOOR PLATE AT WL 79.50, RT SIDE 193.00 INSIDE FORWARD EQUIPMENT COMPARTMENT. REPAIRED CRACKED FLOOR PLATE AT WL79.50, RT SIDE 193.00 IAW EO R53122, REV 02, JUN 11.SDR MALA110146Floorbeam · corrodedFS280 BEAM HAS CORROSION AT SEAM BETWEEN IT AT FLOORBEAM ANGLE AT COCKPIT THRESHOLD. R & R FS 280 CROSSBEAM LT & RT SIDES PN CC670-34094-1 S(LT) & PN CC670-34094-2S (RT) IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-11-001-001-A01,51-42-13-001-001SDR MALA110145Seat Track · corrodedFOUND DURING REMOVAL OF PANEL 231ALF, RBL9.0 SEAT TRACK CORRODED SEVERELY AT APPROX FS 364.00. REMOVED SEAT TRACK LBL9.0, FS 364.00 IAW AMM TASK 53-00-49-000-8 01. REPLACED SEAT TRACK LBL9.0 FS 364.00 IAW AMM TASK 53-0049-400-801.SDR MALA110144Seat Track · corrodedFOUND DURING PANEL 231ALF REMOVAL, RBL 9, SEAT TRACK CORRODED SEVERELY FROM FS349.00-FS379.00. R & R RT SEAT TRACK IAW AMM 53-00-49-000-801 AND 53-00-49-400-801.SDR MALA110143Floor Support · corrodedFLOOR PANEL 221ALF AFT FLOOR SUPPORT IS CORRODED. R & R AFT FLOOR SUPPORT ANGLE PN CC670-34307-3 IAW SRM 51-42-06.SDR MALA110147Skin · chafedLOWER FWD COR COWL (RT) IS HEAVILY CHAFED ON INNER SIDE 4" FWD OF SUPPER DRAIN. COMPLIED WITH EO R54071 AND REO 690-54-23-137 FOR REPAIR OF RT LOWER CORE COWL CHAFE ON FWD SIDE OF SCUPPER DRAIN.SDR MALA110097Light · damagedNOTED EMERGENCY FLOOR PATH LIGHTING IS DAMAGED IN GALLEY ON LT AND RT SIDES, AND AT SEATS 9CD TO 11CD. R & R EMERGENCY FLOOR PATH LIGHTING AT LEFT AND RIGHT GALLEY, AND BETWEEN SEATS 9-11CD. ALL CHECKS GOOD. ALL WORK IAW AMM 33-51SDR MALA100178Light · missingEMERGENCY LIGHTING STRIP IN GALLEY MISSING 16 INCHES. REPLACED EMERGENCY FLOOR TRACK LIGHTING IN GALLEY.
Back to N903XJ