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 SWAA2018071023354Lens · brokenRT OVERWING EXIT LOWER LIGHT LENS BROKEN. R&R LENS IAW AMM.SDR SIMA201807091004Light · inoperativeRT OVERWING FWD EMERGENCY LIGHT INOP. REMOVED AND REPLACED RT OVERWING FWD EMERGENCY LAMP IAW AMM 33-50-10 OPC GOOD.SDR AALA201807099046Lens · brokenSEAT MOUNTED EMERGENCY EXIT LIGHT LENS WAS FOUND BROKEN AT ROW 8R AND 21R. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-18. OPS CHECKED GOOD.SDR AALA201807099033Battery · unknownDURING A PS CHECK OF THE EMERGENCY LIGHTS, THE POWER SUPPLY BATTERY 10WL AT FORWARD LEFT FAILED. ACCOMPLISHED EMERGENCY POWER SUPPLY UNIT SYSTEM TEST IAW AMM 23-73-00. OPS CHECKED OK.SDR AALA201807099032Housing · brokenL4 WALL MOUNTED LED EMERGENCY LIGHT HOUSING BROKEN AND PULLED FROM WALL. REPLACED WALL MOUNTED EMERGENCY LIGHT HOUSING BY L4 DOOR. OPS CHECKED OK, IAW AMM 33-51-18.SDR AALA201807099031Bulb · looseEMERGENCY LIGHT BULB BY THE L2 DOOR 2L, IN FRONT OF LAVATORY H, WAS HANGING LOOSE. REPLACED THE WALL MOUNTED EMERGENCY LIGHT. OPS CHECKED OK IAW AMM 33-51-18.SDR AALA201807099030Lens · brokenSEAT MOUNTED EMERGENCY LIGHT LENS WAS FOUND BROKEN AT ROW 8R AND 21R. REPLACED THE EMERGENCY LIGHT ASSEMBLY AT SEAT ROW 8R AND 21R IAW AMM 33-51-18. OPS CHECKED GOOD.SDR DALA2018070704418Battery · dischargedCEILING EMER LIGHTS INOP. R&R BATTERIES IN B5-106. OPS CK SAT.SDR SWAA2018071623513Light · inoperativeL2 DOOR EVAC SLIDE LIGHT INOP. R&R LIGHT PER MM.SDR DALA2018071304474Battery Pack · dischargedMULTIPLE EMER. LIGHTS OUT IN CABIN. REPLACED EMER BATTERY PACKS M733 AND M736 REF AMM 33-51.SDR SWAA2018071123413Sign · unsecureRT LOWER OVERWING EMERGENCY EXIT LIGHT COVER LOOSE. SECURED SIGN IAW SIP.SDR SWAA2018071123377Sign · brokenRT EXIT ROW EMERGENCY LIGHT BROKEN OFF. R&R SIGN ASSEMBLY PER AMM.SDR YENA201807060282Light · inoperativeFT 202, FLL-JFK. ON CABIN INSPECTION R3 DOOR CABIN EVACUATION LIGHT NOT ILLUMINATED. REMOVED AND REPLACED CABIN EMERGENCY LIGHT AT POSITION 11WLREF AMM 33-51-38.SDR YENA201807060281Epsu · failedFLT 221, BOS-PBI. UPON INSPECTION FOUND NUMEROUS EMER EXIT LIGHTS THROUGHOUT CABIN NOT ILLUMINATING. FOUND EPSU & BATTERY FAULTING AT MID CABIN LEFT LOCATION. R&R W/SERVICEABLE ASSY PER AMM 33-51-38. TEST OK.SDR YENA201807060280Battery · faultedFLT 221, BOS-PBI. UPON INSPECTION FOUND NUMEROUS EMER EXIT LIGHTS THROUGHOUT CABIN NOT ILLUMINATING. FOUND EPSU & BATTERY FAULTING AT MID CABIN LEFT LOCATION. R&R W/SERVICEABLE ASSY PER AMM 33-51-38. TEST OK.SDR DALA2018070704442Cover · damagedSEAT 31ABC EMERGENCY LIGHT DAMAGED. INSTALLED NEW EMER LIGHT COVER AT 31ABC.SDR ASAA2018070625310Lens · detachedR2 LOWER EMERG EXIT LIGHT COVER CAME OFF. GROUNDED - YES. REPLACED COVER, OPS NORMAL.SDR 29GA2018070600003Power Supply · dischargedFLIGHT 0062 TPA/NAS REPORT: 11A EMERGENCY OVERHEAD LT INOP. R&R 24LN EMERGENCY POWER SUPPLY IAW AMM 33-50-10-04-1. OPS CHECKS GOOD.SDR 29GA2018070600002Power Supply · dischargedFLIGHT 0062 TPA/NAS REPORT: FWD 2 EMERGENCY OVERHEAD LTS COME ON FLASH ONCE THEN COME BACK ON FOR 3-5 SECONDS THEN GO OFF AND STAY OFF. R&R 20LN EMERGENCY POWER SUPPLY IAW AMM 33-50-10-04-1. OPS CHECKS GOOD.SDR 29GA2018070600001Power Supply · inoperativeFLIGHT 0062 TPA/NAS REPORT: BOTH EMERGENCY EXIT CABIN WALL LIGHTED PLACARDS DO NOT ILLUMINATE ON EITHER WALL. INSTALLED FWD AND REAR POWER SUPPLY UNITS 20LN 24LN. R&R 23LN EMERGENCY POWER SUPPLY IAW AMM 33-50-10-04-1.SDR DALA2018070604423Battery Pack · faultyEMERGENCY LIGHTS TEST L EPSU AFT FAULT. R&R EPSU BATT PACK.SDR MASA2018070613387Battery Pack · dischargedLAST THREE CEILING EMER FLOOD LIGHTS INOP. REPLACED BATTERY PACK.SDR REXA2018070600598Light · unsecureEMERGENCY FLOOR TRACK LIGHTING IN AFT MOST SECTION INOP. RESECURED AND OPS CHECKED AFT EMER FLOOR LIGHT SECTION IAW AMM 33-51-19. ALL CHECKS GOOD AT THIS TIME.SDR DALA2018070604389Power Supply · inoperativeON SVC CK, FOUND SEATS 31-36 EMERGENCY LIGHT AND AFT STAIRS EMERGENCY LIGHTS INOP. T/S PER AMM 33-50-00-001. FOUND EMERGENCY LIGHT BATTERY PACK B5-212 POWER SUPPLY INOP. REPLACED POWER SUPPLY ASSY IAW AMM 33-53. OPS CK NML. OK FOR SVC.SDR A8ZR20180831001Light · defectiveAFT RT EMERGENCY BETA LAMP FAILED BRIGHTNESS TEST. BETA LAMP ASSY REMOVED AND REPLACED REF AMM 33-51-00 REV 38 DATED MAY 15/17.SDR SWAA2018071823607Light · inoperativeOVERHEAD EMER EXIT LIGHT INOP ROW 4 ABC. RELAMPED PER MM.SDR DALA2018071204456Light · inoperativeONE SEAT MOUNTED EMER LIGHT INOP AT 14D. R&R AFT LIGHT ASSY OPS CHECK GOOD.SDR IPXA2018070531422Power Supply · inoperativeON PREFLIGHT; ''EMER LT BAT 1 LO''. R&R EMERGENCY POWER SUPPLY IAW MM 33-51-01. OPS CK GOOD.SDR SWAA2018071023353Lens · missingR2 DOOR LOWER EXIT SIGN MISSING. INSTALLED LENS IAW AMM.SDR AALA2018071099050Cover · missingL4 DOOR LIGHT UNDER EXIT SIGN IS MISSING THE COVER. INSTALLED THE LIGHT COVER IAW MM 33-51-11.SDR ASAA2018070525301Cover · missingL2 DOOR EXIT SIGN COVER MISSING. GROUNDED - YES. REMOVED AND REPLACED L2 DOOR EXIT SIGN LIGHT ASSEMBLY REFERENCE AMM 33-51-01.SDR YENA201807050279Battery · dischargedFLT 788, SXM-JFK. EMERGENCY LIGHT INOP IN A/C. INSPECTED CABIN EMERGENCY LIGHTS UNITS AND FOUND ALL CABIN EMERGENCY BATTERIES AT FAULT. REMOVED AND REPLACED ALL CABIN BATTERIES REF AMM 33-51-38. OPS CHECK GOOD AT THIS TIME. NO DEFECTS TO REPORT. SUPPLEMENTAL ISDR YENA201807050278Battery · dischargedFLT 788, SXM-JFK. EMERGENCY LIGHT INOP IN A/C. INSPECTED CABIN EMERGENCY LIGHTS UNITS AND FOUND ALL CABIN EMERGENCY BATTERIES AT FAULT. REMOVED AND REPLACED ALL CABIN BATTERIES REF AMM 33-51-38. OPS CHECK GOOD AT THIS TIME. NO DEFECTS TO REPORT. SUPPLEMENTAL ISDR YENA201807050277Battery · dischargedFLT 788 SXM-JFK. EMERGENCY LIGHT INOP IN A/C. INSPECTED CABIN EMERGENCY LIGHTS UNITS AND FOUND ALL CABIN EMERGENCY BATTERIES AT FAULT. REMOVED AND REPLACED ALL CABIN BATTERIES REF AMM 33-51-38. OPS CHECK GOOD AT THIS TIME. NO DEFECTS TO REPORT. SUPPLEMENTAL INSDR YENA201807050276Battery · dischargedFLT 788, SXM-JFK. EMERGENCY LIGHT INOP IN A/C. MULTILE CABIN LGHTS INOP. INSPECTED CABIN EMERGENCY LIGHTS UNITS AND FOUND ALL CABIN EMERGENCY BATTERIES AT FAULT. REMOVED AND REPLACED ALL CABIN BATTERIES REF AMM 33-51-38. OPS CHECK GOOD AT THIS TIME. NO DEFECTSSDR AALA2018070969021Lens · missingSEAT 23C EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA2018070969018Lens · missingSEAT 10C MISSING EMERGENCY EXIT LIGHT LENS. REPLACED THE LENS.SDR AALA201807099024Cover · missingSEAT 15C EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED THE LENS COVER ON EXIT LIGHT AT SEAT 15C IAW AMM 33-51-18. OK FOR SERVICE.SDR AALA201807096009Battery · no testEMERGENCY LIGHT, EXTERIOR GROUND ILLUMINATION, LEFT SIDE JUST FORWARD OF L4 DOOR FAILED 10 MINUTE CHECK PER T/C 0357. REPLACED BATTERY AND CHARGER, OPS CHECKED OK IAW AMM 33-50-00.SDR AALA201807096008Battery · no testAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHT AT L4 DOOR AREA, EXTERIOR SLIDE FAILED 10 MINUTE CHECK IAW T/C 0357. REPLACED THE BATTERY AND CHARGER, OPS CHECKED OK IAW AMM 33-50-00.SDR REXA2018070600597Light · inoperativeSECOND EMERGENCY LIGHT ON THE CEILING BY ROW 5 IS OUT. RELAMPED SECOND EMERGENCY LIGHT LAW AMM 33-51-16. OPS CHECK GOOD NO DEFECTS NOTED AT THIS TIME.SDR HNAA2018070600134Fuse · blownEMERGENCY LIGHT ON PAX DOOR INOP. REMOVED EMERGENCY BATTERY ASSY AND BOUGHT TO SHOP TO CHECK. FOUND NR 2 LIGHT CIRCUIT INOP. R&R F2 PICO FUSE. RE-INSTALLED BATTERY ASSY WITH RETAINED HARDWARE, PERFORMED SELF TEST ON THE BATTERY ASSY, SELF TEST GOOD.SDR HNAA2018070600132Battery · dischargedEMERGENCY LIGHT AT LT EMERGENCY DOOR INOP. INSTALLED EMERGENCY BATTERY ASSY 3 AND RE SECURED WITH RETAINED HARDWARE.SDR MASA2018070513386Battery Pack · dischargedROW 15 CEILING EMER FLOOD LIGHT INOP. REPLACED BATTERY PACK 3.SDR MASA2018070513385Battery Pack · dischargedFLOOR LEVEL EXIT LIGHTS 18 A INOP. REPLACED BATTERY PACK 3.SDR IPXA2018070531403Battery · dischargedDURING PDC FOUND EMERGENCY LIGHTS INOP. R&R BATTERY IAW AMM 33-51-07-02, AND -422. OPS CHK GOOD.SDR MASA2018070513384Light · inoperativeLAST THREE CEILING EMER FLOOD LIGHTS INOP. RELAMPED.SDR MASA2018070513383Sign · inoperativeEXIT SIGN AT ROW 3 INOP. PLACED ON MEL.SDR MASA2018070413382Light · inoperativeAFT OH EMER LIGHT INOP. PLACED ON MEL.SDR DALA2018071204461Power Supply · inoperativeDURING SVC CK, FOUND EXIT SIGN ON CEILING PANEL AT ROW 26 INOP DURING EMERGENCY LIGHTS TEST. REMOVED AND REPLACED POWER SUPPLY M10567 PER AMM 33-51.
Back to JASC 3350