JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, 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 jasc_code = '3350' 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 jasc_code = '3350' 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 SWAA2019051332557Cover Plate · missingOVERWING EXIT SIGN MISSING A COVER PLATE ON AFT SIDE. R&R COVER PLATE PER AMM.SDR DALA2019051202968Light · shortedEMERGENCY POWER SUPPLY 10WL FAILS SELF TEST, INTEGRAL EMERGENCY LIGHT ON 1R DOOR (7501MM) IS SHORTED. REPLACED SLIDE AT DOOR 1R (7501MM).SDR VNAA2019051111101Battery · dischargedEMER LIGHTS INOP DURING TEST. FERRIED AIRCRAFT TO CLT. REMOVED AND REPLACE ALL EMERGENCY POWER SUPPLY BATTERIES.SDR REXA201906120864Light · inoperativeLAST AFT EMERGENCY CEILING FLOOD LIGHT INOP. REMOVED/REPLACED AFT EMERGENCY CEILING FLOOD LIGHT IAW CRJ 200 AMM 33-51-16 OPS TEST ACCOMPLISHED ON W/O 1017193 2000 0017 SN7119046 AAR R RE 13SDR SWAA2019051532722Housing · crackedAFT EMERGENCY EXIT SIGN HOUSING CRACKED. R&R SIGN HOUSING IAW AMM.SDR SWAA2019051532709Light · inoperativeLT OVERWING EXIT FLUORESCENT LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2019051532685Lens · crackedAFT EMERGENCY EXIT SIGN HOUSING CRACKED. R&R LENSES IAW AMM.SDR SWAA2019051532651Power Supply · defectiveAFT UPPER L/H LIGHTING EMERGENCY CHARGER FORWARD CIRCUIT BREAKER AT P18-3 FOUND POPPED ON PREFLIGHT. R&R POWER SUPPLY IAW AMM.SDR SWAA2019051432679Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER MM.SDR SWAA2019051432678Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER MM.SDR SWAA2019051432677Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM.SDR SWAA2019051432642Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER MM.SDR SWAA2019051432602Lens · missingRT BULLNOSE EMERGENCY LIGHT COVER MISSING AT ROW 16. INSTALLED LENS PER AMM.SDR MYWA2019F00202Light · inoperativeR1 DOOR EMERGENCY EXIT EXTERIOR LIGHT WAS INOPERATIVE. IT WAS RELAMPED. REFERENCE MAI LOGPAGE 253871.SDR AALA201905129002Light · missingAIRCRAFT WAS NOT GROUNDED: SEAT 3C EMERGENCY LIGHT CAP MISSING. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 3C PER AMM 33-51-19.SDR AALA20190511005Battery Pack · failedAIRCRAFT WAS GROUDNED: WHILE ACCOMPLISHING CARD 2908 MID CABIN M1670 BATTERY PACK FAILED. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201905129015Battery · dischargedAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS SEAT ROW 20 HJ SIDE MARKER EMERGENCY LIGHT 2 EA. INOP. REMOVED AND REPLACED BATTERY SUPPLY AT M1209 STA 871 RIGHT IAW MM 33-51-07 OPS CHECKED NORMAL.SDR AALA201905129016Battery · dischargedAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS SEAT ROW 21 HJ SIDE MARKER EMERGENCY LIGHTS 2 EA. INOP. MAINTENANCE REMOVED AND REPLACED BATTERY SUPPLY AT M1209 STA871 RIGHT IAW AMM 33-51-07. OPS CHECKED NORMAL.SDR DALA2019051302990Battery · dischargedTHE AFT EXIT AND EMERGENCY LIGHTS IN THE CATWALK ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND CHARGED IT AT B-5260. LIGHTS NOW CHECK NORMAL PER AMM 33-51. (LP #5664562)SDR SWAA2019051332558Light · looseRT EMERGENCY EXIT LIGHT LOOSE AT ROW 8. REATTACHED LIGHT ASSEMBLY IAW AMM.SDR MASA2019051011852Light · inoperative13AC EMER SIGN ONE BULB INOP. PLACED ON MEL.SDR MASA2019051011851Light · inoperative12AC EMER SIGN ONE BULB INOP. PLACED ON MEL.SDR FDEA201905101023Warning System · false activationPDIS 620 33-50 3316 10MAY19 MEM FACT U LOGPAGES:2999948 DURING PREFLIGHT EMER LT TEST LEVEL 1. "EMER LT BAT 1 LO" ALERT DISPLAYED. FACT 10MAY19 19:42 MEM U ACCOMPISHED "EMERGENCY LIGHT TEST" AS PER AMM 24-34-00-5, TEST PASSED, OK FOR SERVISDR MASA2019051011850Light · inoperativeROW 11 CEILING LVL EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR AALA20190509004Battery Pack · dischargedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPL LIGHTING ON CENTER PARTITION FORWARD OF SEAT 17D-H DID NOT OPERATE WHEN TESTED. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IAW AMM. OPS TEST GOOD.SDR AALA201905109008Panel · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND EMERGENCY LIGHT/PASS OXY PANEL LIGHT PLATE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT/PASS ON PANEL LIGHT PLATE AND TEST IS GOOD IAW AMM 33-13-01-404-006.SDR SWAA2019051332568Light · inoperativeLOWER FORWARD R/H OVERWING EMERGENCY EXIT LIGHT BURNED OUT. R&R LIGHT IAW AMM.SDR R61A201905090474Battery · dischargedFLIGHT DECK EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT POWER UNIT BATTERY 1. OPS CHECK GOOD.SDR DALA2019050902956Printed Ckt Board · faultyAT CRUISE, SOME OF THE EMERGENCY LIGHTS ILLUMINATED. RESET NBR 1 CIDS, NO HELP. DEFERRED PER ER/A 577980-14-LAX REPLACED PCB FROM SECONDARY POWER DISTRIBUTION BOX SPDB-3 (3XY). LP 4799320SDR SWAA2019051032545Power Supply · inoperativeLT FORWARD ENTRY ESCAPE SLIDE LIGHT INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019051032544Power Supply · inoperativeLT AISLE LIGHTS INOP BETWEEN ROW 1 TO ROW 4. R&R POWER SUPPLY IAW AMM.SDR SWAA2019051032543Battery Pack · dischargedLT FORWARD ENTRY ESCAPE SLIDE LIGHT INOP. R&R EMERGENCY BATTERY PACK IAW AMM.SDR SWAA2019051032542Battery Pack · dischargedR1 DOOR EXIT SIGN INOP. R&R EMERGENCY BATTERY PACK IAW AMM.SDR SWAA2019051032541Battery Pack · dischargedLT AISLE LIGHTS INOP BETWEEN ROW 1 TO ROW 4. R&R EMERGENCY BATTERY PACK IAW AMM.SDR SWAA2019051032540Power Supply · inoperativeR1 DOOR EXIT SIGN INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019051032539Power Supply · inoperativeFORWARD ENTRY EXIT LOCATOR SIGN INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019051032538Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2019051032517Light · inoperativeLT OVERWING ESCAPE HATCH LIGHT INOP. RELAMPED LIGHT PER WDM.SDR SWAA2019051032516Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2019051032515Battery Pack · dischargedFORWARD ENTRY EXIT LOCATOR SIGN INOP. R&R EMERGENCY BATTERY PACK IAW AMM.SDR S9BA20190509001Light · inoperativeEMERGENCY LIGHT ABOVE 2A SEAT INOP.SDR MASA2019050911849Battery · dischargedCABIN EMER LIGHTS INOP. ALLOWED BATTS TO CHARGE.SDR DALA2019050902914Light · inoperative15 D SEAT EMERGENCY LIGHT INOP. R&R LIGHT ASSY AT SEAT 15D OPS NML REF AMM 33-52. (LP5654544)SDR DALA2019050902913Light · inoperativeSEAT 29DE EMERGENCY LIGHT INOP. RELAMPED EMERGENCY PATH LIGHT AT 29DE & OPS CK GOOD. (LP5653546)SDR DALA2019050902912Light · damagedEMERGENCY LIGHT ASSY DAMAGED AT 32D. REPLACED LIGHT ASSY AT 32D OPS NL REF AMM 33-52. (LP5800382)SDR XMXR20191211017Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR DALA2019051403064Holder · not reportedEMERGENCY SEAT MOUNTING AT SEAT 34F. REPLACED EMERGENCY SEAT MOUNTED LIGHT HOLDER. SYSTEM OPERATION.SDR SWAA2019051032546Battery Pack · dischargedFORWARD RT AISLE LIGHTS SIGN INOP. R&R POWER SUPPLY BATTERY PACK AT M1674 PER AMM.SDR SWAA2019051032522Battery Pack · dischargedFORWARD SERVICE EMERGENCY EXIT SIGN INOP. R&R POWER SUPPLY BATTERY PACK AT M1674 PER AMM.SDR AALA201905099005Light · inoperativeAIRCRAFT WAS NOT GROUNDED: L3 DOOR OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK, COMPLIED WITH EA 293890, PER AMM 33-51-00-710-007.
Back to JASC 3350