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 SWAA2017040612995Battery · failedAFT RT BATTERY FAILED TIME TEST. R&R BATTERY PER AMMSDR SWAA2017040612988Nut Plate · brokenEXTERNAL EMERGENCY WING LIGHT NUT PLATE BROKEN AT BS 470, BETWEEN STR 15R TO STR 14R. R&R LIGHT IAW SRM.SDR SWAA2017040612985Sign · damagedOVERWING CEILING EMERGENCY EXIT SIGN DAMAGED. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017040612983Battery · failedAFT LT BATTERY FAILED TIME TEST. R&R BATTERY PER AMMSDR AALA20170403002Battery Pack · dischargedFOUND M33404 BATTERY PACK BELOW LIMITS. REMOVED AND REPLACED M33404 BATTERY PACK IAW AMM 33-51-06. GOOD FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170403001Battery Pack · dischargedFOUND M33097 BATTERY PACK BELOW LIMITS, REMOVED AND REPLACED M33097 BATTERY PACK IAW AMM 33-51-06. GOOD FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR REXA2017040300427Light · inoperativeSECTIONS OF THE EMERGENCY FLOOR LIGHTS ARE INOP. FOUND EMERGENCY FLOOR LIGHT CONNECTOR DISCONNECTED AT LAV DOOR, RECONNECTED IAW AMM 33-51-01. OPS CK GOOD.SDR IPXA2017040515845Battery Pack · no testEMERGENCY LIGHT SYS TEST FAILED. R & R THE BATTERY PACK IAW AMM 33-50-01. OPS CHECKED GOOD.SDR SWAA2017040512964Battery Pack · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040512936Lamp · inoperativeLEFT FORWARD OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR HNAA2017040500108Light · inoperativeFLOOR EMERGENCY LIGHTS ARE INOPERATIVE AT ROWS 1 AND 6. R & R THE EMERENCY LIGHTS.SDR HNAA2017040500107Bulb · inoperativeFORWARD MOST FLOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR AALA201704049008Lens · brokenEMERGENCY LIGHT LENS BROKEN NEAR L4. REPLACED THE LENS.SDR AALA201704049007Lens · looseEMERGENCY LIGHT AT SEAT 9E FOUND LOOSE. SECURED THE LIGHT IAW 51-42-11SDR AALA201704049016Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT BOTTOM OF SEAT 4E HAS A DETACHED LENS COVER. REPLACED LENS COVER IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR SWAA2017040412869Light · damagedCEILING OVERWING EMERGENCY EXIT SIGN DAMAGED. R & R THE EMERGENCY LIGHT ASSEMBLY IAW MM.SDR SWAA2017040412868Cover · missingRIGHT WINDOW EXIT EMERGENCY LIGHT COVER MISSING. REPLACED THE COVER IAW AMM.SDR SIMA20170403001Light · defectiveINTERIOR EMERGENCY LIGHTS, SERVICE DOOR EXTERIOR LIGHT, AND GALLEY AFT BULKHEAD EMERGENCY LIGHT WILL NOT ILLUMINATE. FOUND A DEFECTIVE SERVICE DOOR EXTERNAL EMERGENCY LIGHT ASSEMBLY. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA201704049003Light · damagedEMERGENCY LIGHT AT SEAT 23R DAMAGED. REPLACED THE LIGHT ASSEMBLY.SDR DALA2017040402719Lamp · inoperativeEXIT LIGHTS INOPERATIVE. REPLACED THE LAMPS AND CHECKED OK.SDR JJBA20170403001Light · malfunctionedEMERGENCY LIGHTS AT EXIT ROW, LT AND RT SIDES INOPERATIVE. PERFORMED POWER RESET. OPS CHECKED SAT.SDR MASA2017040112713Light · inoperativeEMER FLOOD LIGHT INOP AT ROW 15. REPLACED BULB.SDR QXEA2017040300210Sign · detachedEMERGENCY EXIT SIGN AT 2E IS DETACHED. REPLACED EXIT SIGN FIXTURE IAW CMM 25-23-25 AND WM 20-17-24-401. OPERATIONAL CHECK OF EMERGENCY LIGHT SYSTEM IAW AMM 33-51-00-710-803. CHECKS GOOD. RETURNED TO SERVICE.SDR DALA2017040302635Battery Pack · inoperativeFWD UPPER EMERGENCY EXIT LIGHT IS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR SWAA2017042613397Light · brokenFORWARD LAVATORY EMERGENCY EXIT LIGHT BROKEN. R & R THE LIGHT IAW AMM.SDR SWAA2017041713109Housing · crackedAFT LOWERED CEILING EMERGENCY EXIT LIGHT HOUSING CRACKED. R & R THE LIGHT IAW SOPM.SDR IPXA2017040215740Power Supply · inoperativeON PREFLIGHT LEVEL 1 ALERT "EMER LT BAT 1 LO" MX NOTIFIED. PERFORMED DMP IAW MEL 33-50-4. PULLED CB'S, DISCONNECTED CAP'S OF EMER BAT PACK. R&R BATTERY EMER PWR SUPPLY, TESTS ALL PASSED PER AMM 33-51-01.SDR AALA201704049019Cover · unsecureR1 DOOR 1L EXIT SIGN COVER FELL OFF. REMOVED AND REPLACED R1 DOOR EXIT SIGN IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170402002Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT POWER SUPPLY BATTERY PACK M33098 AT R2 DOOR FAILED WORK CARD 2735. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170402001Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT POWER SUPPLY BATTERY PACK M33097 AT R2 DOOR FAILED WORK CARD 2735. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201704049018Light · inoperative13G FLOOR EMERG LT INOP. REPLACED FLOOR EMERG LIGHT IAW AMM 33-51-00. OK FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704039037Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER L1 DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR ASAA2017040220335Sign · looseF/A FOUND MID-CABIN OVERHEAD EXIT SIGN HANGING LOOSE. GROUNDED - YES. REATTACHED OVERHEAD EXIT SIGN IAW AMM 33-51-01.SDR DALA2017040402726Battery Pack · separatedEMERGENCY LIGHTS INOPERATIVE SEAT 10-17 CENTER ROW BOTH SIDES. FOUND BATTERY PACK HAD SEPARATED FROM POWER SUPPLY. REINSTALLED, AND OPS CHECKED GOOD IAW AMM 33-51.SDR DALA2017040302708Lens · missingEMERGENCY LIGHT LENS MISSING, IN THE OVERHEAD ABOVE ROW 1. REPLACED THE LENS, CHECKED GOOD.SDR SIMA20170402004Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT ASSEMBLY IAW AMM 25-23-04. OPC GOOD IAW AMM 33-50-00.SDR SIMA20170402003Sign · abnormalDURING PS-1 INSPECTION, FOUND LT EMERGENCY EXIT MARKING SIGN INOP. REMOVED AND REPLACED LT EMER EXIT MARKING SIGN IAW EMB145 AMM 33-50-14. OPS CHECK GOOD.SDR AALA201704039004Power Supply · inoperativeEMERGENCY LIGHT EPSU AFT LEFT INOPERATIVE. REPLACED THE EPSU.SDR AALA201704039003Cover · brokenEMERGENCY LIGHT COVER BROKEN. REPLACED THE COVER.SDR DALA2017040302698Lamp · inoperativeEMERGENCY LIGHT AT SEAT 39F INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD.SDR YENA201704020238Battery Pack · no testDURING AN EMERGENCY LIGHT TEST, THE EPSU BATTERIES FOR FWD AND AFT, FAULTED. R & R THE FWD AND AFT EPSU BATTERIES IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201704020237Battery Pack · no testDURING EMERGENCY LIGHT TEST, THE EPSU BATTERIES FOR FWD AND AFT, FAULTED. R & R FWD AND AFT EPSU BATTERIES IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201704020234Battery Pack · no testDURING A HEAVY CHECK, AFT CABIN EMERGENCY LIGHTS FAILED TO ILLUMINATE WITH THE SWITCH IN ARM AND THE 1WEL AND 2WL CIRCUIT BREAKERS PULLED. R & R THE BATTERY PACK 13WL IAW AMM 33-51-38-000-002-A, AND 33-51-38-400-002-A. OPS CHECKED GOOD IAW AMM 33-51-00-710-0SDR SIMA20170401005Light · damagedEMERGENCY FLOOR LIGHTING ON LT 10 AND RT 3 AND 4 ARE DAMAGED. INSTALLED NEW EMERGENCY FLOOR LIGHTING ON LT 10 AND RT 3 AND 4 IAW AMM 33-51-01.SDR SIMA20170401004Light · inoperativeLT FWD OUTSIDE EMERGENCY LIGHT DOES NOT COME ON, JUST AFT OF PAX DOOR. R&R THE LIGHT BULB ON THE LT FWD OUTSIDE EMERGENCY LIGHT IAW AMM 33-51-15, OPS CHECK GOOD.SDR DALA2017041703124Light · inoperativeEMERGENCY LIGHT DAMAGED. REPLACED EMERGENCY LIGHT IAW AMM 33-51. OPS CHECKED GOOD.SDR SWAA2017040512943Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017040512902Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR AALA201704039035Light · defectiveLATCH MECHANISM ON FWD BULKHEAD EXIT LIGHT NEEDS ADJUSTING. REPLACED LIGHT ASSY L-1 DOOR. PERFORMED REQD TESTS, ALL CK GOOD REF AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR ASAA2017040120324Battery Pack · failedWHILE PERFORMING T/C 78233001, EMERGENCY LIGHT BATTERY PACK M1695 FAILS TEST. GROUNDED - YES. REPLACED EMERGENCY EXIT LIGHT BATTERY PACK M1695, REF AMM 33-51-06. TESTED - OPS NORMAL.
Back to JASC 3350