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 JJBA20190105018Battery Pack · dischargedEMERGENCY SIDEWALL AND AFT CEILING LIGHTS AT EMERGENCY ROW INOPERATIVE. R&R EMERGENCY BATTERY POWER SUPPLY 3. OPS CHECK SAT.SDR YENA201901050010Battery · failedFLT 225, JFK-TPA. EMERG LIGHT BATTERY 12WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERY 12WL IAW AMM 33-51-38.SDR YENA201901050009Battery · failedFLT 225, JFK-TPA. EMERG LIGHT BATTERY 13WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERY 13WL IAW AMM 33-51-38.SDR SWAA2019010928264Cover · brokenL2 DOOR EMERGENCY EXIT SIGN PLASTIC COVER BROKEN. R&R SIGN PER AMM.SDR AALA2019010979019Battery Pack · inoperativeLEFT OVERHEAD EMERGENCY EXIT SIGN ATSEAT ROW 20 IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07.SDR JJBA20190105004Sign · unsecureEMERGENCY EXIT SIGN AT ROW 18 IS DANGLING. REATTACHED ROW 18 EMERGENCY EXIT SIGN. NO OTHER DEFECTS NOTED AT THIS TIME.SDR DALA2019010700095Battery · dischargedAISLE EMERGENCY EXIT SIGN AT DOOR 2L WILL NOT ILLUMINATE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AND CHARGER B5-231 IAW AMM 33-51-03. CKS GOOD. (LP# 5053029)SDR DALA2019010600093Housing · brokenFOUND EMERGENCY LIGHT AT SEAT 22DEF HOUSING BROKEN OFF. REMOVED AND REPLACED HOUSING. OPERATION CHECKS GOOD.SDR AALA201901079014Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER MISSING ON LAVATORY 4L WALL. MAINTENANCE REPLACED LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR QXEA2019010700008Lens · unsecureEXIT SIGN BY TYPE II/III DOOR POPPED OFF. REMOVED FROM SERVICE. REINSTALLED EXIT DOOR LIGHT LENS. AIRCRAFT RETURNED TO SERVICE.SDR AALA201901079026Lens · detachedEXIT SIGN LENS NEAR THE FORWARD SERVICE DOOR CAME OFF. SECURED THE EXIT SIGN LENS IAW STANDARD PRACTICES. OK FOR SERVICE.SDR DALA2019010700073Lens · unknown(LOG 0891962) DURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. REINSTALLED OVERHEAD EXIT SIGN AT 22CD.SDR DALA2019010700055Power Supply · inoperativeDURING SVC CHECK FOUND CEILING EMER. LIGHTS FROM SEAT ROW 27-36 INOP. REMOVED AND REPLACED POWER SUPPLIES B5-106 AND B5-107 AND REPLACED BATTERIES REF AMM 33-53. OPS CK GOOD. (LP5000059)SDR MASA2019010511642Light · inoperativeROW 9A EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2018010511640Light · inoperativeROW 3/9 FLOODLIGHTS INOP. PLACED ON MEL.SDR SIMA20190104008Fitting · damagedALL LT EMERGENCY LIGHT FLOOR EXTRUSIONS DAMAGED (EXCLUDING RAMP). R&R ALL LT EMERGENCY LIGHT FLOOR EXTRUSIONS (EXCLUDING RAMP) IAW AMM 33-50-12-04.SDR SWAA2019011528436Lens · looseRT EMERGENCY LIGHT ASSEMBLY LENS LOOSE AT ROW 8. SECURED LENS IAW AMM.SDR SWAA2019011528435Lens · looseRT EMERGENCY LIGHT ASSEMBLY LENS LOOSE BETWEEN AT ROW. SECURED LENS IAW AMM.SDR SWAA2019010928311Lens · brokenFORWARD ENTRY EMERGENCY LIGHT LENS COVER BROKEN. R&R COVER PER MM.SDR SWAA2019010928301Lens · looseOVERHEAD AISLE EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER SIP.SDR SWAA2019010928282Ballast · inoperativeRT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. R&R LIGHT BALLAST PER AMM.SDR SWAA2019010928266Charger · inoperativeLT FORWARD CABIN CEILING AISLE EXIT LOCATOR SIGN INOP. R&R BATTERY PACK CHARGER ASSEMBLY PER AMM.SDR SWAA2019010928253Battery Pack · failedONE EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST (M10669). R&R BATTERY PACK PER AMM.SDR AALA2019010959008Light · inoperativeRIGHT FORWARD OVERWING EMERGENCY LIGHT WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-00. OPS CHECKED NORMAL.SDR YENA201901040006Battery · failedFLT 2828, MCO-EWR. EPSU EMERG L ON PTP TEST; R & R EPSU L EMERG BATTERY IAW AMM 33-51-38. OPS CHECK GOOD.SDR YENA201901040005Battery · failedFLT 2828, MCO-EWR. EPSU BATT AFT L ON PTP TEST; R & R AFT L EPSU BATTERY IAW AM 33-51-38. OPS CHECK GOOD.SDR AALA201901079030Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: LEFT HAND (SEE AALA20190105001) AND RIGHT HAND OVERHEAD EMERGENCY EXIT SIGNS AT SEAT ROW 8 WERE INTERMITTENT. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07-422-012 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901059009Light · inoperativeAIRCRAFT WAS GROUNDED: LEFT FORWARD OVERWING EMERGENCY LIGHT INOPERABLE. MAINTENANCE RELAMPED OVERWING LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA20190105002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: LEFT HAND OVERHEAD EMERGENCY EXIT LIGHT SIGN AT ROW 20 INOPERABLE. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07-422-012 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20190105001Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: LEFT HAND AND RIGHT HAND (SEE AALA201901079030) OVERHEAD EMERGENCY EXIT SIGNS AT SEAT ROW 8 WERE INTERMITTENT. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07-422-012 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2019010700086Light · inoperativeSHIP 6803 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:31D. CORRECTIVE ACTION: REINSTALLED EMERG PATH LIGHT PER AMM 33-52. (0890631)SDR IPXA2019010437517Light · inoperativeINSPECTION TYPE:N/A LAV LIGHT AUX EMERGENCY INOP. RELAMPED GROUND CHECKED GOOD REF MM 33-51-00.SDR HNAA2019010700010Sign · inoperativePDIS 642 33-51 1861662 04JAN19 CLT CLOSE EMERGENCY EXIT SIGN AT ROW 2 IS INOP. FACT 04JAN19 10:19 CLT. REINSTALLED SIGN ON AFT GALLEY WALL, RESEATED CONNECTOR ON NR 2 BATTERY. OPS CHECK GOOD OK FOR SERVICE.SDR HNAA2019010700009Light · inoperativeNDIS 634 33-51 0019600 04JAN19 RIC CLOSE MAIN DOOR EMERGENCY LIGHT WILL NOT ILLUMINATE. FACT 04JAN19 10:12 RIC. R/R THE EMERGENCY LIGHT ASSEMBLY IAW AMM TASK 33-30-01-000/400-801-A. OPS CHECK GOOD. OK FOR SERVICE. P/N ON: LIGHT ASSY 136245-305 S/N: - P/N OFF: SDR SIMA20190104001Light · inoperativeAFT 2 CEILING WHITE EMERG LIGHT INOP. C/A-REMOVED AND REPLACED 2 AFT AISLE EMERGENCY LIGHT IAW AMM 33-50-08. OPS CHECK GOOD IAW AMM TASK 33-50-00.SDR SIMA20190104003Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED SERVICE DOOR EXTERNAL EMERGENCY LAMP IAW AMM 33-50-10-000-801-A/33-50-10-400-801-A OPC GOOD.SDR MASA2019010411637Light · inoperativeROW 3 EMER FLOODLIGHT INOP. REPLACED BULB.SDR DALA2019010400034Fuse · blownON SERVICE CHECK FOUND AFT SIX SEAT ROWS WITH EMERGENCY LIGHTS INOP. REMOVED BATTERY PACK NO HELP CHECKED SEAT WIRING NO PROBLEMS FOUND . REPLACED BATTERY PACK BASE FUSES PER AMM 33-53 LIGHTS CHECK NORMAL REINSTALLED ORIGINAL BATTERY PACK . CHECKS NORMAL. (LP4SDR REXA2019010300010Light · inoperativeSUPPLEMENTAL INFORMATION. AFT OVERHEAD EMER LIGHT INOP. DEFERRED OVERHEAD EMERGENCY FLOODLIGHT IAW MEL 33-51-1B MOC NOTIFIED #99295 MMO2 UPDATED PLACARD INSTALLED. *****RELAMPED AFT CABIN EMERGENCY FLOODLIGHT IAW AMM 33-51-16 OPS CHECK GOOD THIS CLEARS DM 3532SDR SWAA2019010928314Cover · unsecureAISLE CEILING EXIT SIGN COVER FELL OFF. SECURED COVER IAW AMM.SDR SWAA2019010928278Lens · missingAFT OVER WING EXIT LENS COVER MISSING. INSTALLED LENS IAW SIP.SDR AALA2019010949017Lens · missingFOUND EXPOSED WIRES BETWEEN THE RIGHT OVERWING EMERGENCY EXIT DOORS. LENS AND HARDWARE ARE MISSING. ATTACHED THE LENS AND HARDWARE IAW AMM 33-20-00. OK FOR SERVICE.SDR SWAA2019010728229Lens · looseRT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR AALA201901059007Battery · dischargedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING BATTERY AT ROW 20 OVERHEAD BIN, LOW VOLTAGE ON LOWER BATTERY. MAINTENANCE REPLACED LOWER BATTERY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2019010400080Lens · missingSHIP 5811 EMERGENCY EXIT SIGN LENS MISSING AT ROW 38. CORRECTIVE ACTION: REPLACED LENS, CKS OK PER AMM 33-51. (5280258)SDR SIMA20190103002Charger · inoperativeEMERGENCY LIGHTING BATTERY NR 2 WILL NOT HOLD A CHARGE. C/A-T/S EMERGENCY LIGHTING AND FOUND NR 2 EPSU CHARGER INOP. REMOVED AND REPLACED NR 2 EMERGENCY CHARGER OPS CHECK GOOD IAW W/C 33-700-19.SDR SWAA2019010428218Lens · brokenOVERWING EXIT CEILING SIGN LENS BROKEN. R&R LENS PER MM.SDR SWAA2019010428208Lens · looseL1 DOOR EXIT SIGN LENS LOOSE. R&R LENS PER MM.SDR SWAA2019010428178Lens · missingR1 DOOR LOWER EXIT LIGHT LENS DIRECTIONAL ARROW MISSING. R&R LENS PER MM.SDR SWAA2019010428177Lens · missingL1 DOOR LOWER EXIT LIGHT LENS DIRECTIONAL ARROW MISSING. R&R LENS PER MM.
Back to JASC 3350