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 KCSA201701201003Light · inoperativeL1 DOOR FWD SILL LIGHT INOP.SDR MASA2017012012816Bulb · inoperativeLOWER LEFT EMERGENCY EXIT ROW 13 SIGN HAD ONE BULB INOPERATIVE . REPLACED THE BULB.SDR JJBA20170120016Light · not reportedEMERGENCY LIGHT OVER CABIN DOOR HALF ILL. R & R THE BULBS, OPS CHECK SAT.SDR SWAA2017020811744Lens · brokenFORWARD GALLEY AREA EMERGENCY EXIT LENS BROKEN. R&R LENS IAW AMM.SDR SWAA2017012411431Light · crackedCENTER AISLE MID CABIN EXIT LIGHT ASSEMBLY CRACKED. R&R LIGHT ASSEMBLY PER AMM.SDR N6WA2017011902Light · unsecureEMERGENCY LIGHTING STRIP FOUND LOOSE. SECURED THE EMERGENCY LIGHT STRIP IAW AMM 25-25-01.SDR YENA201701190040Light · unknownDURING WEEKLY CHECK, EMERGENCY LIGHTING SYSTEM TEST FAILED. EPSU BATTERY AFT L FAULT DISPLAYED ON CIDS PANEL AFTER TEST. CONDUCTED OPERATIONAL CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00-710-001A SEVERAL TIMES, UNABLE TO DUPLICATE FAULT.SDR SWAA2017012311323Structure · brokenAFT EMERGENCY EXIT LIGHT BASE BROKEN. R & R BASE ASSEMBLY IAW AMM.SDR ASAA2017011919498Lens · missingL1 DOOR EMERGENCY EXIT IDENTIFIER LENS MISSING. GROUNDED - YES. REPLACED LENS. OPS NORMAL REF AMM 33-51-01.SDR DALA2017012000547Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROW 10-12. REMOVED AND REPLACED THE BATTERY AND CHARGER M33098 IAW AMM 33-51.SDR AALA201701209007Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT SYSTEM, TEST RIGHT EMERGENCY POWER SUPPLY UNIT BATTERY, FAULT RESULT AT PROGRAMMING AND TEST PANEL. REPLACED BATTERY PER JOB CARD 26L20025014. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR RAIA201701190001Light · inoperativeLT EMERGENCY DOOR FLOOD LIGHT NR 21 INOP. R&R LT EMERGENCY DOOR FLOOD LIGHT NR 21 BULB, OPS CHECK GOOD.SDR CALA2017012000137Light · inoperativeEPL AT O/H BIN 3BA IS INOP. RELAMPED EMERGENCY AREA LIGHT AT SEAT ROW 3AB IAW AMM 31 -51-03-960-801. OPS CHECK TO BE ACCOMPLISHED ON N/R 6187470SDR CALA2017012000136Battery Pack · dischargedEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1675 WILL NOT STAY ILLUMINATED. REMOVED AND REPLACED BATTERY PACK AND POWER SUPPLY AT M1675 IAW AMM 33-51-06-960-805, 33-51-06-960-806, AND WDM 33-51-12 . OPS CHECK GOOD IAW AMM 33-51-06-960-806.SDR AALA20170120024Lens · missingEMERGENCY EXIT SIGN ON THE GALLEY WALL FOR THE AFT LEFT SERVICE DOOR IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170120017Sign · detachedEMERGENCY EXIT SIGN FORWARD OF R3 DOOR IS DETACHED. SECURED EXIT SIGN IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201701209002Light · faultedL3 DOOR ESCAPE SLIDE EMERGENCY LIGHT FAULT INDICATED DURING EMERGENCY POWER SUPPLY UNIT OPERATIONAL CHECK. MAINTENANCE REPLACED THE THE SLIDE.SDR AALA201701209001Battery · no testEMERGENCY LIGHTS FAULTED DURING OPS TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY.SDR AALA201701199036Battery · no testEMERGENCY LIGHTS FAULTED DURING OPS TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY.SDR AALA201701199035Battery Pack · no testEMERGENCY LIGHTS FAULTED DURING OPS TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY.SDR AALA201701199034Battery · no testEMERGENCY LIGHTS FAULTED DURING OPS TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY.SDR AALA201701199033Battery · no testEMERGENCY LIGHTS FAULTED DURING OPS TEST. REPLACED THE EMERGENCY LIGHT POWER SUPPLY BATTERY.SDR AALA201701199032Battery · no testAIRCRAFT IN BASE MAINTENANCE. FAULTED DURING EMERGENCY LIGHTS OP'S TEST, EMERGENCY POWER SUPPLY UNIT AT 1R (12WL). REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY.SDR SIMA20170119001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-09-000-801-A AND 33-50-09-400-801-A. OPS CHECKED GOOD.SDR DALA2017012000519Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROWS 37 THRU 40. REMOVED AND INSTALLED A NEW BATTERY PACK IAW MM 33-51-07, OPS CHECKED GOOD.SDR 7C7A2017011900275Battery Pack · inoperativeCENTER EMERGENCY LIGHTS INOPERATIVE, REPLACED THE BATTERY PACK.SDR MASA2017011912815Light · inoperativeROW 11 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017011912814Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED BATTERIESSDR R61A201701180113Light · crackedMAINTENANCE REPORTED THE EMERGENCY LIGHTS ARE CRACKED AND STAINED THROUGHOUT CABIN. MAINTENANCE REMOVED AND REPLACED THE LIGHTS IAW AMM 33-50-10.SDR SWAA2017012311398Battery Pack · failedAFT RT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER DWG.SDR SWAA2017012311342Connector · disconnectedR1 DOOR EXTERIOR EMERGENCY SLIDE LIGHT INOPERATIVE. RECONNECTED THE CONNECTOR IAW AMM & WDM.SDR ASOA201701181076Lamp · burned outPAX CALL INDICATOR LIGHT ON CABIN OVERHEAD EXIT SIGN INOPERATIVE. REMOVED AND REPLACED THE EXIT SIGN INDICATION LIGHTS IAW AMM 33-51-14. OPS CHECKED GOOD.SDR AALA20170120013Module · inoperativeSEAT MOUNTED EMERGENCY LIGHTS IN ROWS 9DEF THROUGH 15DEF ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND CONTROL MODULE IAW AMM 33-51-07. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170120012Sign · detachedRIGHT OVERWING EMERGENCY EXIT SIGN IS DETACHED. SECURED EXIT SIGN. OPS CHECKED GOOD.SDR AALA20170118010Power Supply · no testEMERGENCY EXIT LIGHT AT OVERHEAD BIN 14DEF FAILED CARD 2904. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20170118001Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT ROWS 9DEF THROUGH 15DEF ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CONTROL MODULE IAW AMM 33-51-07. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201701199004Lens · missingMISSING EXIT LENS AT THE L2 DOOR. REPLACED LENS AND ACCOMPLISHED SATISFACTORY OPS CHECK.SDR REXA2017011800068Bulb · inoperativeWARDROBE BOTTOM EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED THE EMERGENCY LIGHT BULBS IAW AMM 33-51-13-400-801. OPS TESTED GOOD IAW AMM 33-51-00-710-801.SDR SIMA20170118001Charger · failedBULKHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND BATTERY CHARGER1 IAW MM 33-51-17. OPS CHECKED GOOD.SDR ASAA2017011819450Sign · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN BROKEN AT L2 DOOR. GROUNDED. REMOVED, REPLACED, AND TESTED L1190 EXIT SIGN IAW AMM 33-51-01-960-802. OPS NORMAL.SDR ASAA2017011819442Battery Pack · inoperativeEMERGENCY LIGHTS FAILED FUNCTIONAL TEST. GROUNDED. REMOVED & REPLACED THE BATTERIES. OPS GOOD IAW AMM 33-51-06-960-805.SDR HALA2017011900010Light · looseEMERGENCY LIGHT LOOSE AT ROW 22 AB. SECURED THE EMERGENCY LIGHT.SDR AALA201701199009Lens · detachedAIRCRAFT IN BASE MAINTENANCE. RED LENS FOR LIGHT ON AISLE SIDE OF BULKHEAD BETWEEN ROW 8 AND 9 AIRCRAFT LEFT TO BE REATTACHED. MAINTENANCE REATTACHED LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701199005Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY LIGHT LENS COVER AT L37. REPLACED LENS COVER PER AMM 33-51-11.SDR SWAA2017011911317Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2017011911316Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017011911315Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2017011911314Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2017011911313Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2017011911312Sign · brokenRT OVERWING EMERGENCY EXIT SIGN MOUNTING BRACKET BROKEN. R&R SIGN ASSEMBLY PER MM.
Back to JASC 3350