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 IPXA2019010337491Light · inoperativeINSPECTION TYPE:SDR EMERGENCY EXIT LIGHT HAS THREE INOP BULBS. RELAMPED THREE BULBS IN THE EMERGENCY LIGHT PER AMM 33-51-01-2.SDR AALA201901049011Light · brokenEXIT ROW LIGHT FOUND BROKEN AT SEAT 9D. MAINTENANCE SECURED LIGHT IAW CMM 25-21-22, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR QXEA2019010300005Light · looseEMERGENCY LIGHTING STRIP BY SEATS 1A &1B COMING UP. REMOVED FROM SERVICE. REATTACHED EMERGENCY LIGHT STRIP ON FLOOR IN FRONT OF SEATS 1A & B. OKAY FOR SERVICED. AIRCRAFT RETURNED TO SERVICE.SDR JJBA20190103003Power Supply · inoperativeBOTH OVER WING EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY POWER SUPPLY FOR OVER WING EXTERIOR EMERGENCY LIGHTS. OPS CHECK SAT.SDR MASA2019010311633Light · inoperativeROW 15 EMERG CEILING LIGHT INOP. PLACED ON MEL.SDR DALA2019010300017Battery · dischargedAFT OVER WING EXIT SIGN LIGHTS ON BOTH LEFT AND RIGHT SIDE ARE INOP. FOUND NO VOLTAGE AT BATTERY PACK IN OVERHEAD BIN 25E,D. REPLACED BATTERY IN BATTERY PACK. PER AMM 33-53. BOTH LEFT AND RIGHT EXIT SIGNS WORK GOOD. LP5057498)SDR IPXA2019010437511Battery · dischargedINSPECTION TYPE:SDR EMER LT BAT 1 LOW ON EMER LIGHTS TEST. DEFERRED IAW MEL 33-50-4. DMP C/W. PLACARD INSTALLED. DI LOG INSTALLED. **SUPPLEMENTAL SDR** R/R EMER LIGHT BATTERY ASSY IAW AMM 33-51-01-401. OPS CK GOOD. THIS CLEARS M658265.SDR DALA2019010300045Light · damagedSHIP 6803 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:31D. CORRECTIVE ACTION: RESECURED 31D EMERGENCY PATH LIGHT. (0887768)SDR DALA2019010300043Panel · delaminatedSHIP 6703 R2 DOOR UPPER EXIT LIGHT PANEL DISLODGED, DELAMINATED FROM FRAME. CORRECTIVE ACTION: INSTALLED NEW EXIT PANEL. (4865262)SDR SWAA2019010428223Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010428217Lens · missingAFT CABIN EXIT LIGHT LENS MISSING. R&R LENS PER MM.SDR SWAA2019010428185Lens · brokenR2 DOOR ABOVE EXIT LIGHT LENS BROKEN. R&R LENS PER MM.SDR SWAA2019010428160Battery · failedEMERGENCY LIGHT BATTERY M1670 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR AALA201901049018Lens · missingLENS AND HARDWARE WERE MISSING, EXPOSING WIRES BETWEEN THE RIGHT OVERWING EMERGENCY EXIT DOORS. MAINTENANCE REPLACED THE LENS AND HARDWARE IAW AMM 33-20-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR ASAA2019010227653Battery Pack · dischargedLT OVERWING EMERGENCY LIGHT DOES NOT COME ON. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1694 S/N 35160 AND OPS CK GOOD.SDR ASAA2019010227652Battery Pack · dischargedL1 DOOR EMERGENCY LIGHT DOES NOT COME ON. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1675 S/N 76392 AND OPS CK GOOD.SDR QXEA2019010300004Battery Pack · dischargedEMERGENCY LIGHTS BY RT FWD EMERGENCY EXIT AND FWD CABIN CEILING FAIL TO ILLUMINATE WITH EMERGENCY LIGHT SWITCH SELECTED ON. REPLACED BOTH EPSU BATTERY PACKS IN NR 2 EMERGENCY LIGHTS POWER SUPPLY PER AMM TASK 33-51-00-820-801. OPS CHECK IS GOOD.SDR SIMA20190102003Inverter · inoperativeDURING COURTESY CHECK FOUND EMERGENCY EXIT MARKING SIGN ABOVE FLIGHT ATTENDANT SEAT INOP. REMOVED AND REPLACED EMERGENCY LIGHT DC/AC INVERTER IAW AMM 33-50-11 OPC GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR SIMA20190102002Light · inoperativeTHE EMERGENCY LIGHT ON THE DOOR COVER IS INOP. REMOVED AND REPLACED EXTERNAL EMERGENCY LIGHT IAW AMM 33-50-10. OPC GOOD.SDR DALA2019010300016Battery · dischargedEMERGENCY LIGHTS INOP ROW 24LEFT AND RIGHT OVERWING EXITS THROUGH ROW 30. REPLACED BATTERY'S & PACK B5-212 ROW35 OVERHEAD REPLACED FUSES OF PACK OPS CKS PER AMM 33-53-00. (LP5236894)SDR SIMA20190102001Light · inoperative12BC OVER HEAD EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED SEAT 12BC AISLE EMERGENCY LGHT LAMP IAW AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD, NO FURTHER DEFECTS NOTED. END.SDR SCNA20190102001Battery Pack · dischargedROWS 7-11 ABC EMER LIGHTS INOP. R/R M1676 BATTERY PACK. OPS CHK GOOD.SDR SWAA2019011528081Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT AFT INOP. RELAMPED LIGHT IAW AMM.SDR JJBA20190101017Inverter · inoperativePASSENGER CABIN FWD CEILING EMERGENCY LIGHT INOPERATIVE REAR EMERGENCY EXIT. R&R EMERGENCY LIGHT INVERTER NR 6. OPS CHECK SAT.SDR SWAA2019010928097Lens · brokenFORWARD BULKHEAD EXIT SIGN BROKEN. R&R LENS PER AMM.SDR CALA2019010200012Battery Pack · dischargedON CHK FND ZONE C AISLES EMERGENCY LT INOP R3 EMERGENCY POWER PACK M33404 REPLACED AND CHKD OK. DOOR R3 EMERGENCY POWER PACK M334404 REPLACED AND OPS CHECKS OK IAW AMM 33-51-00.SDR IPXA2019010137399Battery · dischargedINSPECTION TYPE:N/A EMER LT BAT 1 LO MESSAGE DISPLAYED. ITEM DEFERRED IAW MEL 33-50-4 DMP C/W PLACARD INSTALLED. **SUPPLEMENTAL SDR** R/R EMER LIGHTS BATTERY IAW FIM 33-51-02-00. OPS CK GOOD. THIS CLEARS M658181.SDR DALA2019010300042Battery Pack · dischargedSHIP 5648 FOUND EMERGENCY LIGHTS AT SEATS 4,5,15,16 INOP. CORRECTIVE ACTION: FOUND BATTERY PACK M732 WOULD NOT TEST. R/R BATTERY PACK M732 PER AMM 33-51, NOW OPS GOOD. (5107338)SDR DALA2019010100024Epsu · faultedEMERGENCY LIGHT CHECK FAULTS AFT L EPSU 13WL, REPLACED EPSU 13WL.SDR JJBA20190101001Sign · unsecureEMERGENCY EXIT SIGN AT ROW 18 FELL OFF. RE SECURED EMERGENCY EXIT SIGN. NO DEFECTS NOTED AT THIS TIME.SDR SWAA2019010328171Battery · failedEMERGENCY LIGHT BATTERY PACK M1674 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328170Battery · failedEMERGENCY LIGHT BATTERY PACK M1674 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328169Battery · failedEMERGENCY LIGHT BATTERY PACK M1673 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328168Battery · failedEMERGENCY LIGHT BATTERY PACK M1670 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328167Battery · failedEMERGENCY LIGHT BATTERY PACK M1669 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328166Battery · failedEMERGENCY LIGHT BATTERY PACK M1668 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328150Battery · failedEMERGENCY LIGHT BATTERY PACK M1675 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR ASAA2019010127640Light · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO RIGHT AFT OVERWING EXIT IS INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-01-960-801 - OPS NORMAL.SDR MASA2019010111627Battery · dischargedNUMEROUS EXIT LTS INOP. ALLOWED BATTERIES TO CHARGE.SDR SWAA2019010328149Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT 12F. INSTALLED LENS PER MM.SDR AALA201901039020Ballast · inoperativeL1 DOOR LIGHT WAS INOPERATIVE. REPLACED LIGHT BALLAST IAW AMM 33-22-03.SDR ASAA2018123127634Light · inoperativeR1 SLIDE LIGHT INOP. GROUNDED - YES. RELAMPED PER AMM 33-51-04 OPS CHECK GOOD.SDR AALA201901029037Lens · detachedEXIT SIGN LENS, LEFT FORWARD OVERWING CAME OFF. REPLACED THE LT OVERWING EXIT SIGN LENS.SDR AALA201901029036Light · inoperativeEMERGENCY EXIT LIGHT AT THE LEFT AFT DOOR WAS INOPERATIVE. MAINTENANCE REPAIRED THE LIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20190102001Battery Pack · inoperativeSEAT EMERGENCY LIGHTS WERE INOPERATIVE AT SEAT ROWS 32 HJ TO 41 HJ. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACK, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901021002Sign · brokenEXIT SIGN OVER THE AFT DOOR WAS BROKEN. MAINTENANCE REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019010228147Battery Pack · dischargedSEVERAL INTERIOR EMERGENCY EXIT LIGHTS INOP. R&R RT STA 952 BATTERY PACK PER MM.SDR SWAA2019010228146Battery Pack · dischargedEXTERIOR EMERGENCY EXIT LIGHTS INOP. R&R RT STA 952 BATTERY PACK PER MM.SDR SWAA2019010228145Battery Pack · dischargedSEVERAL INTERIOR EMERGENCY EXIT LIGHTS INOP. R&R LT STA 952 BATTERY PACK PER MM.SDR SWAA2019010228073Battery Pack · dischargedEXTERIOR EMERGENCY EXIT LIGHTS INOP. R&R LT STA 952 BATTERY PACK PER MM.
Back to JASC 3350