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 VNAA2019090311103Light · inoperativeEMERGENCY FLOOD LIGHT IN FRONT OF LAV INOP. REMOVED/REPLACED EMERGENCY FLOOD LIGHT NUMBER 4, IAW AMM 33-51-16-000/400-801. OP-CHECKS GOOD.SDR FDEA201909032083Battery · out of positionDURING SERVICE CHECK FOUND EMERGENCY LIGHT ABOVE R1 DOOR AND EXTERIOR R1 DOOR LIGHT INOP. PROPERLY INSTALLED BATTERIES IN BOTH FWD CHARGER UNITS M730, M731 PER MM 33-51-07-2. FWD LEFT AND RIGHT EMERG LIGHTS CHECK NORMAL PER MM 33-51-00-5.SDR DALA2019090905233Light · broken(LOG 6004526) DURING INSPECTION FOUND WHITE EXIT LIGHT 31D BROKEN. R/R EMERGENCY PATH LIGHT AT 31D IAW AMM 33-51. OPS CK NML.SDR HNAA2019090600250Battery · dischargedEMERGENCY LIGHTS OVERWING ON LT AND RT SIDES AND EMERGENCY LIGHTS ON FLOOR STRIPS FROM SEATS 12A BACK TO 18A WILL NOT TURN ON. FIX: REMOVED AND REPLACED #400 BATTERY ASSY IAW AMM 33-50-04-04. OPS CHECK GOOD.SDR SWAA2019090536610Cover · looseEXIT SIGN AT OVERWING PLASTIC COVER LOOSE. SECURED SIGN PER AMM.SDR SWAA2019090536605Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT BULBS INOP. RELAMPED BULBS PER AMM.SDR SWAA2019090536604Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT BULBS INOP. RELAMPED BULBS PER AMM.SDR DALA2019090305177Lens · missing(LOG 5658980) DURING INSPECTION FOUND 1 LEFT EMERGENCY EXIT LENS MISSING ON FORWARD GALLEY. REPLACED SAME OK FOR SVC.SDR SWAA2019090436579Battery Pack · dischargedLT 156 AFT EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR HALA2019090300362Battery · dischargedEXTERIOR EMERGENCY LIGHTS (L AND R) INOP. REMOVED AND REPLACED OVER WING EMERGENCY EVACUATION BATTERY PER AMM 33-51-06. OPS CHECK GOOD.SDR IPXA2019090346306Light · inoperativeINSPECTION TYPE:N/A EMERGENCY LIGHT ASSY HAS FOUR LAMPS OUT. RELAMPED FOUR LIGHTS BULBS PER AMM 33 51 01 2.SDR QXEA2019090300338Sign · unsecureTHE EXIT SIGN ON THE CEILING IN THE REAR OF THE CABIN IS HANGING DOWN. REMOVED FROM SERVICE. RESECURED AFT EXIT SIGN ON THE CEILING IN THE AFT GALLEY, WITH THE EXSISTING HARDWARE. RETURNED TO SERVICE.SDR DALA2019090305107Battery · dischargedINTERIOR EMERGENCY EXIT OVERWING LIGHTS INOP. R/R BATTERIES IN BATTERY PACK PER AMM 33-53. NOW OPS NML. (LP6121960)SDR DALA2019090305106Battery Pack · dischargedCOCKPIT EMER LIGHTS STA 140 NOT ILLUMINATE WHEN DOING EMER LIGHT CHECK. REPLACED B5-23 BATTERY PACK PER AMM 33-50-00 FIG 1. SYSTEMS CHECK NORMAL. (LP4634454)SDR HALA2019090300135Sign · looseDOOR 3R EXIT SIGN IS LOOSE. RE-INSTALLED AND SECURED DOOR 3R EXIT SIGN. LP 4974885SDR SWAA2019090936732Lens · defectiveAFT EMERGENCY EXIT DOOR RT SIDE LENS INOP. R&R EMERGENCY EXIT LENS IAW MM.SDR DALA2019090305178Lens · out of position(LOG 1253114) DURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. FOUND COVER AND REINSTALLED.SDR SWAA2019090436594Battery · dischargedLT AFT EMERGENCY LIGHT CHARGER CIRCUIT BREAKER WILL NOT RESET AT BS 603. R&R BATTERY PER AMM.SDR SWAA2019090436580Charger · inoperativeLT AFT EMERGENCY LIGHT CHARGER CIRCUIT BREAKER WILL NOT RESET AT BS 603. R&R LIGHT CHARGER PER AMM.SDR SWAA2019090436577Lens · looseOVERWING EXIT SIGN ON CEILING FELL OFF (LOOSE). INSTALLED LENS PER SIP.SDR DALA2019090305134Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED RIGHT OVERWING EMERGENCY LIGHT BULB IAW AMM 33-51. (LP# 5833520)SDR SWAA2019090336556Battery Pack · dischargedRT AFT ESCAPE SLIDE EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019090336522Power Supply · inoperativeRT AFT ESCAPE SLIDE EMERGENCY LIGHT INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2019090336520Light · inoperativeL2 DOOR OUTSIDE EMERGENCY EXIT LIGHT INOP. R&R LIGHT BULB PER AMM.SDR DALA2019090305121Power Supply · inoperativeTHE THREE (3) AFT ACCESSORY SIDEWALL EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY POWER SUPPLY B5-116 PER AMM 33- 51 AND RELAMPED AS NEEDED. OPERATIONAL CHECK WAS GOOD. (LP #6140483)SDR DALA2019090305120Power Supply · inoperativeTHE AFT EMERGENCY LIGHT ABOVE AFT F/A SEAT IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY POWER SUPPLY B5-116 PER AMM 33- 51 AND RELAMPED AS NEEDED. OPERATIONAL CHECK GOOD. (LP #6140482)SDR AALA201909039002Battery Pack · dischargedAIRCRAFT WAS GROUNDED: FOUND CABIN E LIGHT BATTERY PACKS DEAD. REMOVED AND REPLACED B5-23, B5-27, B5-28, B5-100, B5-101, B5-102, B5-103, B5-104, B5-105, B5-106, B5-107, AB5-1, AB5-2, AB5-3, AB5-4 IAW AMM 33-53-00, OPS CHECKS GOOD. SEE SDR AALA201909039001SDR AALA201909039001Battery Pack · weakAIRCRAFT WAS GROUNDED: FOUND EMERGENCY LIGHTS DIM BUT ACCEPTING CHARGE. REMOVED AND REPLACED ALL CABIN BATTERY PACK AS PER AMM 33-53-00 OPS CKS GOOD. SEE SDR AALA201909039002.SDR REXA2019090201281Light · inoperativeWHILE PERFORMING ROUTINE-900 FOUND RT FWD EMERGENCY LIGHT ON TOP OF WING OUT. RELAMPED RT FWD EMERGENCY LIGHT IAW AMM 33-51-15 P/N: 8GH005123-06.SDR N6WA2019090101Light · inoperativeEMERGENCY CEILING LIGHT OUT #2.DEFERRED EMERGENCY CEILING FLOOD LIGHT #2 ON OCN 70060776 PER MEL 33-51-01B-2A CAT C CLEARED DMI 9/1/19: R/R BULB IN CABIN CEILING EMER LIGHT CC#C135678.SDR DALA2019090200133Epsu · inoperativeLEFT SIDE FIRST CLASS EMERGENCY LIGHTS ILLUMINATED DURING FLIGHT. REPLACED EPSU 11 WL AND AND SECURED PINS ON CONNECTOR 11WLA. LP 1250922SDR DALA2019090205170Housing · brokenROW 11 ABC EMERGENCY LIGHT BROKEN OFF, REPLACED EMERGENCY LIGHT HOUSING & PAN AT SEAT 11 ABC.SDR DALA2019090305139Lens · missing(AIRCRAFT 7007, L/P 1250584) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:904 / ACARS TEXT: FRC 335102904 / INTERIOR. REPLACED MISSING EMERGENCY EXIT LENS COVER IN CREW REST AREA PER CMM 33-21-89. OPS CHECK GOOD.SDR AALA201909049001Battery · faultedAIRCRAFT NOT GROUNDED: DURING ROUTINE CHECK, FOUND EPSU BATTERY (10WL) ABOVE L1 DOOR FAULTING. REMOVED AND REPLACED EPSU BATTERY ABOVE L1 DOOR (10WL) IAW AMM 33-51-00, OP CHECK GOOD,SDR HALA2019090300359Lens · damaged1ST CLASS EXIT SIGN COVER DAMAGED. ( EMERGENCY EXIT LIGHT ). REPLACED EXIT SIGN LENS.SDR SWAA2019090336557Light · inoperativeFORWARD SERVICE DOOR EMERGENCY EXIT SIGNS LAMPS INOP. RELAMPED LAMP IAW AMM.SDR SWAA2019090336548Light · inoperativeL1 DOOR EMERGENCY THRESHOLD LIGHT HAD SEVERAL LAMPS INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019090336527Light · inoperativeFORWARD RECESSED LIGHT, EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019090336508Light · inoperativeAFT SERVICE DOOR EMERGENCY EXIT SIGNS LAMPS INOP. RELAMPED LAMP IAW AMM.SDR SWAA2019090336507Sign · brokenAFT GALLEY EXIT SIGN BROKEN OFF CEILING. REINSTALLED SIGN PER MM.SDR SWAA2019090336464Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP EXTERIOR. RELAMPED LIGHT IAW AMM.SDR HNAA2019090300248Light · inoperativeNDIS 642 33-51 0007420 01SEP19 RIC CLOSE EMERGENCY FLOOR LIGHT @ ROW 1/GALLEY INOP. FACT 01SEP19 10:18 RIC R&R EMERGENCY FLOOR LIGHT AT ROW 1/GALLEY IN REF TO AMM 33-50-12-000/400-A OPS CHECK GOOD OK FOR SERVICE P/N ON 1013196 EME FLOOR LIGHT P/N OSDR HNAA2019090300247Sign · inoperativeNDIS 642 33-31 0007470 01SEP19 RIC CLOSE EMERGENCY EXIT SIGN ABOVE SERVICE DOOR INOP FACT 01SEP19 10:25 RIC R&R EMERGENCY EXIT SIGN ABOVE SERVICE DOOR IAW AMM 33-50-14-000/400-801-A R&R #200 EMER LIGHT DC/AC INVERTER IAW AMM 33-50-11-000/400-801-A SDR SIMA20190901001Inverter · inoperativeDURING PS-1 CHECK FOUND FWD EXIT LIGHT ABOVE FA SEAT INOP. C/A-THROUBLESHOT FWD EXIT LIGHT IAW FIM 33-50-00-810-804-A FOUND TO BE INVERTER #1 REMOVED AND REPLACED INVERTER #1 IAW AMM 33-50-11 OPS CHECK GOOD.SDR SIMA20190901002Light · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED SERVICE DOOR EVTERNAL EMERGENCY LIGHT IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A OPC GOOD.SDR MASA2019090112029Sign · inoperativeRT FWD EMERGENCY EXIT LIGHT INOP. PLACED ON MEL.SDR MASA2019090112028Sign · inoperativeLT FWD EMERGENCY EXIT LIGHT INOP. PLACED ON MEL.SDR MASA2019090112027Sign · inoperativeCENTER OVERHEAD EXIT SIGN INOP. PLACED ON MEL.SDR VNAA2019100231101Light · inoperativeLH AFT EXTERIOR EMERGENCY LIGHT IS INOP. REMOVED AND REPLACED LH AFT EXTERIOR EMERGENCY LIGHT IAW CRJ 900 AMM 33-51-15-000/400-801-A05 OPS CHECK GOODSDR DALA2019090305145Bezel · broken(AIRCRAFT 658, L/P 6149422) EMERGENCY LIGHT BEZEL BROKEN AT ROW 22 DEF. R/R LIGHT BEZEL AS NEEDED.
Back to JASC 3350