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 HALA2019020700040Light · unsecureGALLEY EMERGENCY FLOOR LIGHTING LIFTING UP FROM THE FLOOR. SECURED GALLEY EMERGENCY FLOOR LIGHTING.SDR SIMA2019021107005Light · malfunctionedLH OVER-WING EMERGENCY LIGHT IS INOP.-C/A-COMPLIED WITH OPERATIONAL CHECK OF LH OVERWING EMERGENCY LIGHT. OPERATIONAL CHECK GOOD. NO DEFECT NOTED.SDR SWAA2019021129501Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM.SDR SWAA2019021129488Battery Pack · failedLT AFT EMERGENCY BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2019021129487Battery Pack · failedRT AFT EMERGENCY BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2019021129481Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM.SDR SWAA2019021129473Lens · missingMISSING EMERGENCY EXIT LENS COVER IN AFT GALLEY FIRST OFFICERS SIDE. INSTALLED LENS PER AMM.SDR SIMA201902087002Lamp · inoperativeAISLE EMERGENCY LIGHT ROW 3 INOP-C/A-REMOVED AND REPLACED AISLE EMERGENCY LIGHT ROW 3 LAMP, OPC GOOD IAW EMB AMM 33-50-08SDR SIMA201902087004Lamp · inoperativeLH FWD OVER WING EMERGENCY LIGHT INOP-C/A-RAR LH FWD OVER WING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND EMB AMM 33-50-400-801-A. OPS CHECK GOOD. END.SDR SWAA2019020829418Battery Pack · dischargedFORWARD RT EMERGENCY LIGHT INOP AT ROW 3. R&R BATTERY PACK PER AMM.SDR SWAA2019020829417Battery Pack · dischargedFORWARD RT EMERGENCY LIGHT INOP AT ROW 6. R&R BATTERY PACK PER AMM.SDR SWAA2019020829416Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020829415Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020829414Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020829413Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020829412Charger · brokenBATTERY CHARGER AT POSITION M01669 BATTERY PACK RETAINING CLIP BROKEN. R&R BATTERY CHARGER PER AMM AND DWG.SDR SWAA2019020829411Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020829408Lens · missingEMERGENCY EXIT SIGN LOCATED OVERHEAD THE AISLE AT THE OVERWING MISSING ITS FORWARD PORTION. REINSTALLED LENS IAW AMM.SDR SWAA2019020829407Sign · inoperativeRT AFT GALLEY EMERGENCY EXIT SIGN INOP. RELAMPED SIGN PER AMM.SDR SWAA2019020829406Battery Pack · dischargedFORWARD L1 EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR DALA2019020700827Battery Pack · inoperativeOVERHEAD EMERGENCY ESCAPE PATH LIGHTING INOP FROM ROWS 14-22. REPL BATTERY PACK REF MD88 AMM 33-53. OPS CHECK GOOD. (LP4702230)SDR SIMA20190206005Light · inoperativePCR: EMERGENCY LIGHT FLOOR STRIPS INOP AT 1A, FWD CLOSET, AND 1FD. C/A-COMPLETE:REMOVED AND REPLACED EMERGENCY LIGHT FLOOR STRIPS AT 1A, FWD CLOSET, AND 1FD IAW AMM 33-50-21. OCK GOOD. SEE WIPS AND TASK FOR DETAILS.SDR DALA2019022291130Selector Switch · failedCHECK PED 4R RIGGING. DUE TO CONFIRMED REPORTS OF EMERGENCY LIGHTS ILLUMINATING AT 4R / PED WITH EMERGENCY LIGHT SW ON P5 ARMED AND 4R DOOR MODE SELECT HANDLE IN DISARMED POSITION AND DOOR HANDLE TO THE FULL OPEN POSITION. CORRECTIVE ACTION: WRANG OUT S52121 PSDR SWAA2019021129508Power Supply · inoperativeRT EMERGENCY EXIT LIGHTING FAILED TO ILLUMINATE BETWEEN ROW 3 TO 4. R&R POWER SUPPLY IAW AMM.SDR SWAA2019021129507Power Supply · inoperativeL1 DOOR EXIT LIGHT EGRESS LIGHT FAILED TO ILLUMINATE. R&R POWER SUPPLY M1675 IAW AMMSDR SWAA2019021129506Power Supply · inoperativeG1 GALLEY EXIT LIGHT EGRESS LIGHT FAILED TO ILLUMINATE. R&R POWER SUPPLY M1675 IAW AMMSDR SWAA2019021129505Battery · dischargedOVER WING EXIT UPPER PANEL AND SIDE WALL EXIT LIGHT EXIT LIGHT FAILED TO ILLUMINATE. R&R BATTERY IAW AMM.SDR SWAA2019021129504Power Supply · inoperativeLT EMERGENCY EXIT LIGHTING FAILED TO ILLUMINATE BETWEEN ROW 9 TO 11. R&R POWER SUPPLY IAW AMM.SDR SWAA2019021129503Power Supply · inoperativeR1 DOOR EXIT LIGHT EGRESS LIGHT FAILED TO ILLUMINATE. R&R POWER SUPPLY M1675 IAW AMMSDR SCNA20190206026Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP. TROUBLESHOT, REMOVED AND REPLACED M1674 BATTERY PACK AND PERFORMED OPS CHECK. OPS CHECK GOOD.SDR AALA20190207003Light · damagedEVAC ANNUNCIATOR LIGHT AT THE R2 DOOR, ATTENDANT PANEL DIMMED., REMOVED AND REPLACED EVAC ANNUNCIATOR LIGHT CAP ASSY IAW AMM 33-22-06-960-804, OPS CHECKED GOOD.SDR IPXA2019020878761Lamp · inoperativeINSPECTION TYPE:SDRBATTERY LIGHT INOPERATIVE. SW OK.RELAMPED BATTERY SWITCH. OPS GOOD.SDR SIMA20190206003Battery · dischargedBOTH LT AND RT AFT OVERWING EXTERIOR EMERGENCY LIGHTS FAILED FUNCTIONAL CHECK IAW MTX WC 33-700-17. REMOVED AND REPLACED EMERGENCY LIGHT CHARGER AND BATTERY AT POSITION NR 4 IAW MTX WC 33-700-19, OPC GOOD IAW MTX WC 33-700-17. BATTERY CHARGER ASSY 11-0049 S/NSDR HALA2019020700049Lens · brokenETOPS SIGNIFICANT SYSTEM - EMERGENCY EXIT LIGHT 3R DOOR CRACKED AND BROKEN. RE-INSTALLED LENS COVER, NO DAMAGE NOTED OK FOR SVC.SDR SWAA2019020729372Power Supply · failedRT AFT EMERGENCY LIGHTING FAILED CAPACITY CHECK AT LOCATION M1672. R&R POWER SUPPLY PER AMM.SDR SWAA2019020729370Power Supply · failedLT AFT EMERGENCY LIGHTING FAILED CAPACITY CHECK AT LOCATION M1673. R&R POWER SUPPLY PER AMM.SDR SWAA2019020729367Light · inoperativeRT EMERGENCY EGRESS LIGHT FUSE BEHIND FLAP INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019020729362Light · inoperativeR2 EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SIMA20190206001Battery Pack · dischargedUPON PS-1 INSPECTION CHECK PART 11-C FOUND EXTERNAL EMERGENCY LIGHT LT-RT TOP INOP. R&R BATTERY PACK AND BATTERY CHARGER ON NR 4 REF AMM 33-50-04. OPS CHECK GOOD. MEL ITEM RESTORED. BATTERY CHARGER ASSY P/N 11-0049 S/N 19285SDR SWAA2019020629296Cover · missingRT EMERGENCY EXIT LIGHT COVER MISSING AT ROW 6. R&R COVER IAW AMM.SDR QXEA2019020600062Light · malfunctionedFWD EXIT LIGHT INOP. REMOVED FROM SERVICE. PERFORMED OPS CHECK OF THE EMERGENCY LIGHT SYSTEM, NEXT GENERATION AIRCRAFT IAW Q400 AMM TASK 33-51-00-710-802, OPS CHECK GOOD, NO OTHER DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR DALA2019020600811Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS OUT 22, 23, 24, 25 ROWS. R/R BATTERY SET AT BATTERY PACK B5-104 IAW MD88 AMM 33-53. OPS CK GOOD. (LP5319148)SDR SWAA2019040331309Lens · missingCABIN SIDEWALL PANEL 231YHW MISSING ESCAPE LENS. R&R SIGN LIGHT ASSEMBLY IAW AMM.SDR SWAA2019031330589Housing · damagedEXIT LIGHT HOUSING DAMAGED COMMON TO CEILING PANELS ON OVERWING EMERGENCY AREA. R&R LIGHT HOUSING PER AMM.SDR SWAA2019020529263Lens · missingLT EMERGENCY AISLE LIGHT LENS MISSING AT ROW 8. R&R LENS ASSEMBLY PER SIP.SDR YENA201902085057Lens · missingFT # 65, ROW 11 DEF RED EMERG. LIGHT LENS MISSING OUTBOARD SEAT; REPLACED RED EMERG. LIGHT LENS AS REQ'D. OPS CHECKS GOOD.SDR DALA2019020600839Fuse · defectiveR2 EMERGENCY SLIDE ILLUMINATION LIGHT IS INOPERATIVE. FOUND FUSE OF M733 POWER SUPPLY DEFECTIVE. REPLACED FUSE AND DOOR SLIDE LIGHT. SYSTEM OPERATION IS NORMAL.SDR SWAA2019020729366Battery Pack · failedRT EMERGENCY EXIT LIGHT BATTERY PACK M1675 FAILED TEST. R&R BATTERY PACK PER AMM.SDR SWAA2019020729365Battery · failedLT AFT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2019020729364Battery · failedRT AFT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.
Back to JASC 3350