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 SWAA2019061133485Bulb · inoperativeL/H STOW BIN EMERGENCY LIGHT INOP AT ROW 3. / R&R BULB IAW AMM.SDR SWAA2019061133484Light · inoperativeR/H STOW BIN EMERGENCY LIGHT INOP AT ROW 3. / R&R LIGHT IAW AMM.SDR SWAA2019053033175Lens · crackedPASSENGER CABIN SIDEWALL PANEL 242YAW EXIT LIGHT LENS CRACKED. R&R LENS IAW AMM.SDR IPXA2019043041601Battery · dischargedINSPECTION TYPE:N/A EMER LT TEST RECEIVED LVL 1 EMER LT BAT 1 LOW. ITEM TRANSFERRED TO M668740 IAW MEL 33-50-4. DMP ACCOMPLISHED PLACARD INSTALLED. **SUPPLEMENTAL SDR** REPLACED EMERGENCY POWER SUPPLY BATTERY PER AMM 33-51-01. TEST PASSED. NO ALERTS NOTED. THISDR DALA2019050102855Fuse · blownSHIP 676 EMERGENCY LIGHTS INOP BETWEEN SEAT ROWS 22-26. CORRECTIVE ACTION: REPLACED FUSE AT POWER SUPPLY M10567. EMERG LIGHTS CK GOOD. (5442838)SDR SWAA2019050632314Light · inoperativeRT EMERGENCY LIGHT AT STOW BIN INOP AT ROW 3. R&R LIGHT IAW AMM.SDR SWAA2019050632313Light · inoperativeLT EMERGENCY LIGHT AT STOW BIN INOP AT ROW 1. R&R LIGHT IAW AMM.SDR SWAA2019050632294Cover · unsecureR1 DOOR EXIT LIGHT COVER FELL OFF. SECURED COVER PER SIP.SDR AALA20190502010Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: ELP BATTERY PACK M33404 AT DOOR 3R INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06.SDR AALA20190502009Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: ELP BATTERY PACK M33094 AT DOOR 1R INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06.SDR AALA20190502008Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: ELP BATTERY PACK M33407 AT DOOR 4L INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06.SDR AALA20190502007Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: ELP BATTERY PACK M33098 AT DOOR 2R INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06.SDR AALA20190501003Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: ELP BATTERY PACK M33400 AT DOOR 3L INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06.SDR SWAA2019050332278Charger · abnormalR1 DOOR OVERHEAD EXIT SIGN LIGHT INOP. R&R CHARGER PER AMM.SDR SWAA2019050332220Battery Pack · dischargedR1 DOOR OVERHEAD EXIT SIGN LIGHT INOP. R&R BATTERY PACK PER AMM.SDR DALA2019043002787Light · unsecureEMERGENCY PATH LIGHT PUSHED INTO SEAT AT ROW 1, SECURED EMERGENCY LIGHT AT ROW 1.SDR ASAA2019043029210Sign · unsecureR1 EMERGENCY EXIT SIGN FELL OFF. GROUNDED - YES. RESECURED EXIT SIGN FOR R1 DOOR. OPS NORMAL.SDR SWAA2019050232221Light · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201905029011Power Supply · failedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS AFTER PERFORMING OPS TEST OF THE ESCAPE-FACILITIES MSG SHOWS BAT/EPSU (10WL) FWD L. MAINTENANCE REMOVED AND REPLACED 10WL FWD L EPSU POWER SUPPLY IAW AMM 33-51-38. OPS TEST OKAY.SDR HNAA2019050200133Light · inoperativeNDIS 608 33-51 0021800 30APR19 RIC CLOSE EMERGENCY EXIT AISLE ILLUMINATION LIGHT AT RT WING EXIT DOOR INOP. 36218 00 NGR FACT 30APR19 09:57 RIC R/R LAMP FOR PSU EMERGENCY LIGHT AT SEAT 12B AND 12C IN REF TO AMM 33-50-08-000/400-801-A. OPS CHECK GOOD.SDR HNAA2019050200131Inverter · inoperativeNDIS 642 33-51 0004570 30APR19 RIC CLOSE EMERGENCY EXIT SIGN WILL NOT ILLUMINATE_IN FRONT OF SEAT 3B. 28713 00 NGR FACT 0APR19 06:47 RIC R/R'D 300 EMERGENCY LIGHT DC/AC INVERTER IAW AMM 33-50-11-000/400-801-A. OK FOR SERVICE. P/N ON INVERTER_P/N SDR N6WA2019043003Light · inoperativeOVER EMER. LIGHT AT 21A INOP. DEFERRED OVER EMER. LIGHT* ON OCN # 70055007 PER MEL 33-51-01B CAT C. AUTHORIZED BY MXC.SDR SIMA20190430006Charger · failedLT AND RT OVER WING EMERGENCY LIGHTS INOP. C/A-REMOVED AND REPLACED NR 4 EPSU BATTERY AND CHARGER, OPC GOOD, IAW AMM 33-50-04. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 78160.SDR MASA2019043011836Bulb · inoperativeROW 15 OVERHEAD EMERG FLOOD LIGHT INOP
REPLACED BULBSDR SIMA20190430001Light · discolored2 EACH EMERGENCY FLOOR LIGHT STRIPS DISCOLORED INBD OF FWD CLOSET-C/A-REMOVED AND REPLACED EMERGENCY FLOOR LIGHT STRIPS INBD OF FWD CLOSET IAW EMB 175 AMM 33-50-21. OPS CHECK GOOD. PHOTOLUMINESCENTINDIC STRIP LIGHT P/N SG 9904-2128DSDR MASA2019043011833Light · inoperativeROW 6 CEILING LEVEL EMER FLOOD LIGHT INOP. PLACED ON MELSDR MASA2019043011832Bulb · inoperativeGALLEY EMERG EXIT SIGN 3 BULBS INOP. RELAMPEDSDR DALA2019043002735Battery Pack · inoperativeOVERWING EMER LIGHTS ABOVE DOOR AFT POS INOP. R/R BATTERIES IN EMER BATT PACK PER MD88 AMM 33-53. OPS CK GOOD.SDR REXA2019043000572Lamp · inoperativeDURING WAKE UP CHECK NOTED RH FWD OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED RH FWD OVERWING EMERGENCY LIGHT LAMP P/N 1317. OPS CHECK OF EMERGENCY LIGHTS GOOD IAW CRJ 200 AMM 33-51-00.SDR SWAA2019053033172Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT BULB BURNED OUT. RELAMPED BULB PER AMM.SDR SWAA2019053033164Light · inoperativeRT OVERWING EMERGENCY EXIT FORWARD LIGHT BULB BURNED OUT. RELAMPED BULB IAW AMM.SDR SWAA2019050332274Power Supply · inoperativeM1668 MID EMERGENCY POWER SUPPLY INOP AT BS. 603, LBL 67. R&R POWER SUPPLY PER AMM.SDR SWAA2019050332273Power Supply · inoperativeM1673 AFT EMERGENCY POWER SUPPLY INOP AT BS. 952, LBL 13. R&R POWER SUPPLY PER AMM.SDR SWAA2019050332272Power Supply · inoperativeM1674 FORWARD EMERGENCY POWER SUPPLY INOP AT BS. 322, RBL 7. R&R POWER SUPPLY PER AMM.SDR SWAA2019050332261Battery Pack · dischargedM1674 FORWARD EMERGENCY POWER SUPPLY INOP AT BS. 322, RBL 7. R&R BATTERY PACK PER AMM.SDR SWAA2019050332260Battery Pack · dischargedM1673 AFT EMERGENCY POWER SUPPLY INOP AT BS. 952, LBL 13. R&R BATTERY PACK PER AMM.SDR SWAA2019050332259Battery Pack · dischargedM1668 MID EMERGENCY POWER SUPPLY INOP AT BS. 603, LBL 67. R&R BATTERY PACK PER AMM.SDR YENA201904290251Battery · failedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES FIN 10WL AND 13WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT FIN 10WL AND 13WL PER AMM 33-51-38.SDR YENA201904290250Battery · failedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES FIN 10WL AND 13WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT FIN 10WL AND 13WL PER AMM 33-51-38.SDR AALA201905019025Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT BROKEN AT SEAT ROW 20ABC. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201905019024Lens · brokenAIRCRAFT WAS NOT GROUNDED: RED EMERGENCY LIGHT LENS BROKEN AT SEAT 22D. MAINTENANCE REPLACED SEAT MOUNTED EMERGENCY LIGHT AT SEAT 22D PER AMM 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20190430001Power Supply · failedAIRCRAFT WAS NOT GROUNDED: BATTERY FAILED CIDS 1 TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AT 10WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR SWAA2019050132160Cover · missingRT OVERWING SIDEWALL EXIT SIGN MISSING. SECURED EXIT COVER PER SIP.SDR SWAA2019050132122Sign · brokenRT OVERWING EXIT SIGN BROKEN. R&R SIGN PER AMM.SDR AALA201904309022Battery Pack · weakAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND EMERGENCY EXIT SIGNS AT L5 DOOR SHUT OFF WITHIN 2 MIN. REPLACED BATTERY PACK IAW AMM 33-29-12. OPS CHECKS OK.SDR DALA2019043002768Shroud · damagedEMERGENCY LIGHT IS BROKEN AT SEAT 33F. FOUND SEAT SHROUD DAMAGED. REPLACED SHROUD AND LIGHT ASSEMBLY.SDR SWAA2019050132100Battery Pack · dischargedOVER L2 DOOR EMERGENCY EXIT LIGHT INOP. CHARGED PACK IAW AMM.SDR DALA2019043002764Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED LOCATIONS:23C, SECURED SAME.SDR DALA2019050102763Battery Pack · inoperativeMAINTENANCE FOUND SEVERAL EMERGENCY LIGHTS OUT IN THE CABIN DURING THE TURN AROUND CHECK. TROUBLE SHOOTING PER MD88 SSM 33-51 FOUND THE BATTERIES B5-123, B5-259, B5-118, B5-121, AND B5-119 TO BE BAD AND REPLACED THEM PER B717 AMM 33-52. ALL OPERATIONS ARE NOW SDR AALA201904309023Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 32D EMERGENCY LIGHT OUT. MAINTENANCE REPLACED SEAT 32D EMERGENCY LIGHT ASSEMBLY PER AMM 33-60-98.
Back to JASC 3350