DC Jet Services
Service difficulty reports · 42
Reports filed under designator 3J7R by a repair station, 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 submitter_designator = '3J7R' AND submitter_type_code = 'B' ORDER BY difficulty_date DESC, sdr_id 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 submitter_designator = '3J7R' AND submitter_type_code = 'B' ORDER BY difficulty_date DESC, sdr_id 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 3J7R0615202600001Lamp · failedEXTERIOR WINDOW EMERGENCY EXTT LAMP WILL NOT ILLUMINATE.SINGLE LAMP IS AFT OF THE EMER WINDOW EXITSDR 3J7R2026050400001Light Sys · dimRH OVER WING EMERGENCY LIGHT DIMSDR 3J7R2025120500001Power Supply · inoperativeEXIT SIGN ON FWD BULKHEAD IN THE CABIN ABOVE SEAT 1 INOPERATIVE.SDR 3J7R2025011300001Light · inoperativeON THE RIGHT SIDE MOST AFT EMERGENCY OVERWING LIGHT IS OUT.SDR 3J7R2025090800001Light · dimFORWARD EMERGENCY EXIT LIGHT (SHARK LIGHT) UNDER THE RIGHT WING IS EXTREMELY DIM.SDR 3J7R2025090400001Light · inoperativeTHE DROPPED-AISLE EMERGENCY LIGHTS BETWEEN SEAT 8 AND SEAT 6 ARE INOPERATIVE.SDR 3J7R2025072800525Battery · dischargedWHEN THE EMERGENCY LIGHTS SWITCH IS SET TO ARM, THE LAVATORY SEAT OVERHEAD LIGHT, EXIT SIGN FOR THE BULKHEAD BEHIND SEAT SEVEN, EXIT SIGN BELOW THE LAVATORY SEAT, AND THE EVACUATION PATH LIGHTS UNDER THE LAVATORY SEAT DO NOT COME ON.SDR 3J7R2025062400001Battery Pack · faultedFORWARD EMERGENCY LIGHTS ASSOCIATED WITH #1 BATTERY PACK STAY ILLUMINATED AFTER SWITCH IS PLACED IN OFF POSITION.SDR 3J7R2025061400001Light · dimEXTERIOR EMERGENCY EXIT LIGHT NEAR MAIN CABIN DOOR VERY DIM. ALSO DIM WHEN BEING USED AS PAX SAFETY LIGHT.SDR 3J7R0909202400001Light · dimENTRY DOOR EMERGENCY LIGHT IS DIMSDR 3J7R2024083000001Light · dimDURING MAINTENANCE CHECKLIST FOUND RH OVERWING EMERGENCY LIGHT DIMSDR 3J7R2024082600001Light · dimCABIN DOOR EMERGENCY EXIT LIGHT DIMSDR 3J7R2024081200001Lamp · inoperativeFOUND FWD RH EMERGENCY LIGHT INOP DURING SERVICE CHECK.SDR 3J7R2024072200001Light · inoperativeMOST FORWARD OVER WING EMERGENCY EXIT LIGHT INOPSDR 3J7R2024071500001Lamp · inoperativeAFT RH EXTERNAL EMERGENCY LIGHT NEAR EMERGENCY EXIT IS INOP.SDR 3J7R2024071000001Lamp · inoperativeDURING MX CHECKLIST FOUND RH/FORWARD EXTERIOR EMERGENCY LIGHT INOP.SDR 3J7R2024062800001Power Supply · defectiveDURING THE CHECKLIST WE FOUND THE FWD OVER WING EMERGENCY LIGHT AND EMERGENCY LIGHT UNDER THE WING EXIT IN THE INTERIOR INOP. WE HAVE FOUND THAT BOTH LIGHTS WORK WHEN TESTING THE ELPS3. BOTH LIGHTS INOP WHEN ELPS3 NOT IN TEST MODE.SDR 3J7R2024060300001Power Supply · inoperativeEMERGENCY EXIT LIGHT WILL NOT ILLUMINATE, LEFT UPPER AFT 2ND CABIN PARTITION AT FS 595.20SDR 3J7R2024005220001Battery Pack · no testDURING MAINTENANCE CHECK FOUND MAIN ENTRY EXIT LIGHTED SIGN INOPERATIVE.SDR 3J7R2024050900001Wire Splice · looseEMERGENCY LIGHTS FLASHING ON AND OFF AT FORWARD RIGHT OVERWING POSITION AND FLOOR LEVEL EMERGENCY EXIT DIVAN POSITIONS. AFTER CHARGING FOR ONE HOUR BOTH LIGHTS HAVE FAILED ENTIRELY.SDR 3J7R2024040200001Light · inoperativeMIDDLE OVER WING EMERGENCY EXIT LIGHT INOPSDR 3J7R2024031400001Battery · dischargedDURING MXC NOTED ALL EMERGENCY LIGHTS POWERED BY BATTERY PACK #3 DO NOT ILLUMINATE WITH BATTERY PACK POWERSDR 3J7R2023012060001Light · burned outDURING MXC NOTED FWD EXTERIOR EMERGENCY LIGHT RETAINING WATER AND SEVERAL LEDS INOPSDR 3J7R2023011150001Battery Pack · dischargedFORWARD EMERGENCY LIGHTS DO NOT TEST WITH THE MAIN BATTERY TURNED OFF, BUT WORK NORMALLY WITH THE BATTERY TURNED ON. CHARGED THEM FOR 1.5 HOURS WITH NO CHANGE. SUSPECT THE FORWARD BATTERY HAS FAILEDSDR 3J7R2023010100001Light · dimDURING THE PFI NOTED THE EXTERIOR FORWARD OVER WING EMERGENCY LIGHT HAS ONE LED INOP AND REMAINING LED’S ARE DIM.SDR 3J7R2023091100001Battery · dischargedDURING THE MAINTENANCE CHECK, THE FORWARD EMERGENCY LIGHTS WERE FOUND INOPERATIVE ON EMER. BATT POWER.SDR 3J7R202302800001Impact Switch · activatedFOUND THE FWD EMERGENCY LIGHTS ON WITH THE SWITCH BEING IN THE "OFF" POSITION.SDR 3J7R2023071700001Bulb · blownDURING MAINTENANCE CHECKLIST FOUND EXTERNAL EMERGENCY LIGHT ON RH SIDE IS INOP (POS:FWD)SDR 3J7R2023071400001Channel · crackedDURING INSPECTION FOUND THE CARGO DOOR FWD HINGE AND U CHANNEL CRACKED.SDR 3J7R2023061300001Battery Pack · dischargedEXTERIOR EMERGENCY LIGHTS AND AFT LEFT BULKHEAD EXIT SIGN ARE INOP WHEN THE MAIN BATTERY IS OFF. CHARGED FOR 1.5 HOURS AND HAD THE SAME RESULT.SDR 3J7R2023052200001Battery Pack · dischargedFOUR LIGHTS OF THE EMERGENCY LIGHTING SYSTEM FAIL TO ILLUMINATE. THE LAV OVERHEAD LIGHT, THE TABLE OVERHEAD LIGHTS OF SEATS 5 AND 9, AND THE EMERGENCY EXIT FORWARD WING LIGHT.SDR 3J7R2023051900001Battery Pack · dischargedTHE FORWARD EMERGENCY EXIT LIGHTS AT THE CABIN DOOR DO NOT ILLUMINATE WHEN THE MAIN BATTERY IS OFF AND THE AFT EMERGENCY LIGHTS ARE DIM.SDR 3J7R2023050300001Light · dimAFT EMERGENCY LIGHT OVER RIGHT WING IS DIMMER THAN THE OTHER EMERGENCY LIGHTSSDR 3J7R2023040500001Battery Pack · dischargedEMERGENCY LIGHTS INADVERTENTLY LEFT ON BY THE CREW. CREW ASKED FOR THE BATTERIES TO BE CHARGED AND THE SYSTEM TO BE OP CHECKED. FOUND LIGHTS IN THE OFF POSITION WHEN ARRIVED AT AIRCRAFT. FOUND FORWARD EXIT SIGNS AT CABIN DOOR INOP WHEN AIRCRAFT POWER IS OFF.SDR 3J7R2023032400001Bulb · burned outTECHS NOTED THE RH AFT OUTSIDE EMER LIGHT TO BE INOP.SDR 3J7R2023021700001Battery Pack · depletedREAR CABIN AND EXTERIOR EMERGENCY LIGHTS INOP WHEN MAIN BATTERY IS OFF. LIGHTS WORK NORMALLY WHEN MAIN BATTERY IS ON.SDR 3J7R2023020800001Lamp · blownTHE AFT OVER WING EMERGENCY LIGHT IS INOP.SDR 3J7R2023020600001Battery Pack · depletedTHE AFT EMERGENCY LIGHTS ARE INOPERATIVE ON EMERGENCY BATTERY PACK. THEY DO OPERATE WHEN POWERED BY MAIN AIRCRAFT POWER.SDR 3J7R2023020600002Not Reported · not reportedPERFORMING THE EMERGENCY LIGHT BATTERY OPS CHECK, FOUND THAT THE EMERGENCY LIGHT SWITCH , WORKS INTERMITTENTLY. REMOVED OVERHEAD CONTROL PANEL AND INSPECTED THE SWITCH AND FOUND EMERGENCY LIGHT SWITCH WIRING CONNECTOR THAT WASNT LOCK DUE TO WORN OUT CLIP.SDR 3J7R2023011200001Power Supply · blownTHE FORWARD EMERGENCY LIGHTS IN THE CABIN AT THE CABIN DOOR ARE INOP, AT LEAST THREE SIGNS ARE OUT. THESE INCLUDE THE EXIT SIGN IN THE OVERHEAD AND THE EXIT SIGNS AT KNEE LEVEL IN THE DOOR WAY.TROUBLESHOT AND FOUND THE FUSE BLOWN ON THE #1 POWER SUPPLY. ISOLATSDR 3J7R2023010400001G Switch · activatedDURING MX CHECK FOUND EMER LIGHTS STAY ON WITH SWITCH IN ARM POSITIONSDR 3J7R2023010300001Light · dimDURING MX NOTED RH OVERWING EMERGENCY EXIT LIGHT HAS INOP/DIM LED'S.
Back to DC Jet Services