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 SIMA20190321003Light · inoperativeROW 12 OVERHEAD EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED ROW 12 AISLE EMERGENCY LIGHT LAMP IAW AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD NO DEFECTS NOTED. END.SDR DALA2019032101880Charger · inoperative(LOG 5766112) DURING INSPECTION FOUND EMERG. LIGHTS OUT,VARIES LOCATIONS IN CABIN. REPLACED BATTERY CHARGER AND BATTERIES PER B737-MM-33-51.CKS GOOD.SDR SWAA2019032230941Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER AMM.SDR SWAA2019032230940Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2019032230929Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R&R BATTERY PER AMM.SDR SWAA2019032230926Lens · unsecureRT OVERWING EMERGENCY EXIT LIGHT LENS FELL OFF. R&R LIGHT LENS PER AMM.SDR JJBA20190321009Light · unsecureEMERGENCY PATH LIGHTING PLASTIC COVER AND LIGHT BAR NEAR SEAT 1A BROKEN. SECURED EMERGENCY PATH LIGHT STRIP. NO OTHER DEFECTS NOTED AT THIS TIME.SDR JJBA20190321008Sign · inoperativeSERVICE DOOR EXIT SIGN INOPERATIVE. R&R SERVICE DOOR EXIT SIGN. OPS CHECK SAT.SDR KCSA201903211043Sign · crackedSELF ILLUMINATED EXIT SIGN AFT OF L1 HAS CRACK IN FRAME AND LENS.SDR SWAA2019041131618Charger · inoperativeR/H EXTERIOR OVERWING ESCAPE LIGHT INOP. / R&R CHARGER ASSEMBLY IAW AMM.SDR SWAA2019041131617Battery Pack · inoperativeR/H EXTERIOR OVERWING ESCAPE LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019041131616Battery Pack · inoperativeL/H EMERGENCY EXIT LIGHTS ON STOW BIN INOP BETWEEN ROW 9 TO ROW 11. R&R BATTERY PACK IAW AMM.SDR SWAA2019041131598Charger · inoperativeL/H EMERGENCY EXIT LIGHTS ON STOW BIN INOP BETWEEN ROW 9 TO ROW 11. / R&R BATTERY PACK CHARGER ASSEMBLY IAW AMM.SDR DALA2019032902013Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK M736 FAILED CAPACITY CHECK. MAINTENANCE REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR AALA201903287003Lens · missingEMERGENCY EXIT LIGHT FIXTURE, BOTTOM BRACKET BROKEN AND CLEAR LENS WAS MISSING AT THE R4 DOOR. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-13, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201903287002Bracket · brokenEMERGENCY EXIT LIGHT FIXTURE, BOTTOM BRACKET WAS BROKEN AND CLEAR LENS WAS MISSING AT THE R1 DOOR. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-13, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR DALA2019032001951Power Supply · failedFOUND EMERGENCY BATTERY POWER SUPPLY TEST FAILED AT CREW REST. MAINTENANCE REPLACED THE BATTERY POWER SUPPLY ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR YENA201903200144Battery · failedDURING HEAVY MAINTENANCE, CIDS EMERGENCY LIGHT BITE FAILS FOR 11WL AND 12WL; REF N/R 440542-43013 - REMOVED AND REPLACED 11WL + 12WL EPSU BATTERY IAW AMM 33-51-38-000-002A AND 33-51-38-400-002A. OPS TEST GOOD IAW AMM 33-51-38-700-002A SUBTASK 33-51-38-710-052-SDR YENA201903200143Battery · failedDURING HEAVY MAINTENANCE, CIDS EMEERGENCY LIGHT BITE FAILS FOR 11WL AND 12WL; REF N/R 440542-43013 - REMOVED AND REPLACED 11WL + 12WL EPSU BATTERY IAW AMM 33-51-38-000-002A AND 33-51-38-400-002A. OPS TEST GOOD IAW AMM 33-51-38-700-002A SUBTASK 33-51-38-710-052SDR SWAA2019032531055Lens · crackedG1 GALLEY EXIT LIGHT BASE AND LENS CRACKED. R&R LENS IAW AMM.SDR SWAA2019032531041Lens · crackedG1 GALLEY EXIT LIGHT BASE AND LENS CRACKED. R&R LIGHT IAW AMM.SDR SWAA2019032531040Battery Pack · inoperativeLT M1675 EMERGENCY BATTERY PACK WILL NOT CHARGE. R&R BATTERY PACK IAW AMM.SDR DALA2019032201897Lens · damaged(AIRCRAFT 7110, L/P 0993358) PLEASE CHECK CONDITION OF THE 3L PARTITION RED EMERGENCY LIGHT DUE TO CONDITION BEING REPORTED AS POOR DUE TO CARTS/PAX/BAGS. REPLACED LIGHT LENS AT 3R NOT FLIGHT ATTENDANT LEFT AS STATED. CHECKS GOOD.SDR HALA2019032100091Not Reported · missingFLOOR LIGHT STRIP IN AFT GALLEY IS MISSING PARTS. REPLACED EMERGENCY LIGHT STRIP IN AFT GALLEY. LP 5847373SDR ASAA2019032028711Unknown · malfunctionedEMERGENCY LIGHTS ARE TURNING ON WHEN COCKPIT EMER. LIGHT SWITCH IS SELECTED OFF. GROUNDED - YES. PERFORMED BITE TEST IAW AMM 33-51-00 PB 501 BLOCK EPSU. OPS CHECK IS GOOD.SDR ASAA2019032028710Battery · dischargedDURING EPSU BATTERY CAP TEST L1 DOOR EMER. LIGHT BATT FAILED (10WL) GROUNDED - YES. R/R L1 DOOR EPSU EMER LIGHT BATT IAW 33-51-38-00-002-A. OPS TST GOOD.SDR AALA201903229006Power Supply · inoperativeWHILE PERFORMING AN EMERGENCY LIGHT SYSTEM TEST, THE TEST FAULTED MID RIGHT EPSU 14WL. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED EPSU, OPS CHECKED GOOD.SDR SWAA2019032230939Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019032230938Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019032230935Lens · crackedAFT LT OF OVERWING EMERGENCY EXIT DOOR LIGHT LENS AND MOUNT CRACKED. R&R LIGHT IAW AMM.SDR SWAA2019032230934Lens · crackedAFT RT OF OVERWING EMERGENCY EXIT DOOR LIGHT LENS AND MOUNT CRACKED. R&R LIGHT IAW AMM.SDR SWAA2019032230921Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SIMA20190320006Light · inoperativeMAIN-DOOR EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED MAIN-DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-06-000-801-A AND AMM 33-50-06-400-801-A. OPS CHECK GOOD. NO MORE DEFECTS NOTED AT THIS TIME. END.SDR AALA201903219018Light · looseEMERGENCY LIGHT AT ROW 14 D WAS LOOSE. REPLACED THE EMERGENCY LIGHT. OPS CHECKED NORMAL IAW WORK CARD 2803.SDR AALA201903219012Sign · inoperativeEMERGENCY EXIT SIGN ON THE LEFT SIDE OF ROW 16. REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT ASSEMBLY. OPS CHECKED NORMAL IAW AMM 33-51-00.SDR AALA201903210004Battery Pack · inoperativeMAINTENANCE FOUND THE L2 DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK M33099.SDR AALA201903210002Battery · weakFOUND THE SEAT MOUNTED EMERGENCY LIGHTS FROM ROWS 10D - 25D VERY DIM. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-07, OPS OK.SDR AALA201903210001Charger · inoperativeFOUND THE SEAT MOUNTED EMERGENCY LIGHTS FROM ROWS 19D - 25D WERE VERY DIM. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-07, OPS OK.SDR 29GA2019032100003Light · inoperativeFLIGHT# 0123 FLL/FLL REPORT:F/A REPORTS ARM LIGHT BULB IS INOP. CORRECTIVE ACTION: REMOVED AND REPLACED LAMP AT F/A ARM LIGHT FOR EMERGENCY LIGHT IAW AMM 25-25-25-04 AND 33-50-00, OPERATIONAL CHECK NORMAL.SDR 29GA2019032100002Power Supply · failedFLIGHT# 0092 TPA/FLL REPORT: FWD RT EMERGENCY EXIT LIGHT IS NOT WORKING. CORRECTIVE ACTION: REMOVED AND REPLACED 21LN FWD RIGHT HAND EMERGENCY POWER SUPPLY IAW AMM 33-50-10--4. FWD RT EMERGENCY EXIT SIGN OPS CHECK GOOD IAW 33-50-00.SDR 29GA2019032100001Light · inoperativeFLIGHT# 0092 TPA/FLL REPORT: EMERGENCY PATH LIGHTING FROM ROW 3-5 IS NOT WORKING. CORRECTIVE ACTION: REMOVED AND REPLACED 42LN PROXSIMITY FLOOR LIGHT STRIP IAW AMM 33-50-20.SDR MASA2019032011767Light · inoperativeRIGHT AFT EMER LIGHT INOP. RELAMPED.SDR MASA2019032011766Light · inoperative12F FLOOR LEVEL EMER LIGHT 2 BULBS INOP. RELAMPED.SDR SWAA2019032030851Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2019032001827Power Supply · inoperativeEMERG. LIGHTS IN CEILING OUT STA 446-586. REPLACED PWR SUPPLY B5-101 IAW AMM 33-53. NOW CK GOOD. (LP5764876)SDR DALA2019032001953Battery Pack · dischargedEMERGENCY LIGHTS AT 38-45AB ARE INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR AALA201903219019Sign · missingR1 EMERGENCY EXIT SIGN WAS MISSING. REPLACED THE EXIT SIGN IAW AMM 33-51-13.SDR SWAA2019032130888Battery Pack · failedRT OVER WING EMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY BACK PER MM.SDR SWAA2019032130887Battery Pack · failedLT OVERWING EMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019032130885Cover · missingR2 DOOR EXIT SIGN MISSING (NOT THE BIG ONE OVERHEAD BUT THE SMALL ONE ON THE SIDE OF THE DOOR). INSTALLED COVER PER AMM.
Back to JASC 3350