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 U2RA201703250001Light · inoperativeEMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 34 DOES NOT ILLUMINATE. RELAMPED EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 34 IN ACCORDANCE WITH AMM 33-51-11 LIGHT TESTS GOOD.SDR ASAA2017032520260Battery Pack · inoperativeEMERGENCY EXIT LIGHT AFT OF R1 DOOR INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW WDM 33-51-12 AND AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201703279037Lens · missingEMERGENCY LIGHT HAS A MISSING LENS COVER. INSTALLED THE LENS. OPERATIONAL CHECK GOOD.SDR AALA201703279036Lens · missingFLOOR PROXIMITY EMERGENCY EXIT FLOODLIGHT IN THE FORWARD GALLEY HAS A MISSING LENS COVER. REPLACED LENS . OPERATIONAL CHECKED GOOD.SDR AALA201703279018Light · unsecureEXIT LIGHT AFT OF L4 DOOR, OUT OF POSITION. INSTALLED AND SECURED THE LIGHT IAW AMM 33-51-00.SDR IPXA2017032715582Bulb · burned outFLT DECK EMERGENCY LIGHT SWITCH HAS A BURNED OUT BULB. REPLACED THE BULB, OPS CHECKED GOOD IAW AMM 33-13-00.SDR ASOA201703254012Battery Pack · dischargedMAINTENANCE REPORTED THAT THE NR 1 & 2 OVERWING EMERGENCY LIGHTS AND AFT INTERIOR EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOTESDR ASOA201703254011Power Supply · inoperativeMAINTENANCE REPORTED THAT THE NR 1 & 2 OVERWING EMERGENCY LIGHTS AND AFT INTERIOR EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOTSDR SIMA20170325002Inverter · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 1 INVERTER IAW AMM 33-50-11 OPS CHECKED GOOD.SDR CALA2017032500724Lens · missingEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN OFF 20C LIGHT WORKS, COVER MISSING. SECURED LENS COVER. OPS CHK OK.SDR CALA2017032500721Light · broken"A" & "B" ZONE PARTITION L & R 4EA LWR EMER LIGHTS FOUND BROKEN. REPLACED THE CABIN M/D ''A'' & ''B'' ZONE PARTITION L & R. TOTAL 4EA EMERGENCY LIGHTS AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 79.SDR MASA2017032512690Light · inoperative1 LAMP INOP SERVICE DOOR LOWER EXIT SIGN. PLACED ON MEL.SDR 2DYA20170412001Battery Pack · dischargedDURING A3 INSPECTION FOUND EMERGENCY ESCAPE PATH LIGHTING INOP AT SEATS 1AB THROUGH 8AB. REMOVE AND REPLACE BATTERY PACK AND CHARGER ASSY OP CHECK NORMAL REF AMM 33-51-07. CHARGER P/N 2012-1, S/N 27284 REMOVED.SDR AALA201703289034Cover · unsecureEMERGENCY EXIT LIGHT COVER FELL OFF DURING FLIGHT BY DOOR 1L. SECURED EMERGENCY LIGHT COVER BY L1 DOOR / IAW GPM TECH REF, MAINT OR REPAIR DONE IN PREVIOUS UPDATE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703289033Lens · missingEMERGENCY LIGHT LENS CAP MISSING LOCATION- RIGHT SIDE 1ST CLASS AISLE INSIDE 1L DOOR. INSTALLED 1ST CLASS EMER LIGHT, RIGHT SIDE PER 33-51-14. CK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703289032Lens · unsecureEXIT LIGHT LENS COVER AT FWD GALLEY DOOR WILL NOT STAY IN PLACE. REPLACED LIGHT ASSY L01186 AT FWD GALLEY DOOR IAW AMM 33-51-01. OP CK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703279047Lens · missingAIRCRAFT WAS GROUNDED. LEFT AFT LAVATORY SMALL EXIT LIGHT PANEL FALLEN OFF. RESTORED EMERGENCY LIGHT COVER IN AFT LT LAVATORY.SDR AALA201703279042Lens · crackedAIRCRAFT IN BASE MAINTENANCE. LT FUSELAGE AFT DOOR, TOP EMERGENCY EXIT SIGN LENS CRACKED. REPLACED LT FUSELAGE AFT DOOR TOP EMERGENCY EXIT SIGN.SDR AALA201703279041Lens · crackedAIRCRAFT IN BASE MAINTENANCE. LT FORWARD ENTRY DOOR EMERGENCY EXIT TOP SIGN LENS CRACKED. REPLACED LT FORWARD ENTRY DOOR EMERGENCY EXIT SIGN.SDR AALA201703279022Lens · unsecureR2 DOOR EMERGENCY LIGHT LENS UNSECURE. INSTALLED THE LENS.SDR AALA201703279007Lens · brokenFOUND THE FLOOR LEVEL EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS .SDR AALA201703279004Lens · missingR4 DOOR EMERGENCY EXIT SIGN LENS MISSING. REPLACED LENS, CHECKED OK.SDR AALA201703279039Bulb · looseL2 DOOR EMERGENCY EVACUATION SLIDE LIGHT IS INOPERATIVE. RESEATED BULB IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR DALA2017032702456Lens · unsecureEMERGENCY EXIT SIGN COVER LOOSE. SECURED.SDR DALA2017032702448Switch · missingEMERGENCY LIGHTS ARMED SWITCH MISSING. R & R EMERGENCY LIGHTS CONTROL PANEL IAW AMM 33-51-08. OPS CHECKED GOOD.SDR SIMA20170324005Inverter · failedEMERGENCY LIGHTS AND NR 2 EPSU INOPERATIVE. R & R NR 2 EMERGENCY LIGHT POWER SUPPLY INVERTER IAW AMM 33-50-11-000-801-A, & 33-50-11-400-801-A, OPS CHECKED GOOD.SDR SIMA20170324004Inverter · inoperativeFIRST SET OF AISLE FLOOR LIGHTS AND LOWER SERVICE DOOR LIGHT INOPERATIVE. REMOVED AND REPLACED NR 2 INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR REXA2017032400395Battery · inoperativeEMERGENCY EXIT SIGNS AT MAIN CABIN DOOR WON'T LIGHT UP. REPLACED THE BATTERY NR 1 IAW AMM 33-51-17. OPS CHECKED GOOD.SDR JJBA20170324014Light · unsecureEMERGENCY LIGHT PEELING UP IN THE GALLEY. SECURED THE LIGHT IAW AMM 20-30-03. OPS CHECKED GOOD.SDR DALA2017032602403Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:405. ADJUSTED LIGHT OPS CHECK AND LENS OPS CHECK GOOD.SDR DALA2017032602402Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:407. ADJUSTED LIGHT OPS CHECK GOOD.SDR DALA2017032602397Light · inoperativeFLOOR PROXIMITY EMERGENCY LIGHT INOP F/C BULKHEAD. REPLACED FLOOR PROX LIGHT ASSY.SDR MASA2017032412688Battery · dischargedALL EMERGENCY LIGHTS INOP. CHARGED BATTERIES.SDR CALA2017032400713Battery · inoperativeEMERGENCY LIGHTS ON STOW BINS INOPERATIVE AT ROW 30DEF. REPLACED EMERGENCY POWER SUPPLY BATTERY, OPS CHECKED GOOD IAW MM 33-5 1-00.SDR CALA2017032400712Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK 1694 DOES NOT HOLD A CHARGE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06, OPS CHECKED GOOD.
SDR CALA2017032400711Charger · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE AFT OF OVERWING EXIT. REPLACED M1670 CHARGER AND BATTERY PACK, OPS CHECKED GOOD IAW 33-51-00-710-801.SDR CALA2017032400710Lamp · inoperativeR1 EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06-962-001-002. OPS TESTED GOOD.SDR CALA2017032400707Light · inoperativeAT EXIT ROW, EMERGENCY LIGHT ASSY IS INOPEREATIVE. REMOVED AND REPLACED THE LIGHT ASSY. OPS CHECKED GOOD.SDR CALA2017032400705Lamp · inoperativeEMERGENCY LIGHTS IN MAIN CABIN 43L AND 47L ARE INOPERATIVE DURING CHECK. REPLACED THE LAMPS, OPS CHECKED GOOD. IAW AMM 33-51- 07.SDR CALA2017032400701Power Supply · faultyGETTING L EPSU MESSAGE. REMOVED AND REPLACED EPSU IAW MM 33-51-38 EMER LIGHTS TEST OK ON CIDS BITE PANEL.SDR CALA2017032400704Lamp · inoperativeLAVATORY 101 EMERGECY LIGHT ON SIDE IS INOPERATIVE. REPLACED THE LAMPS. CHECKED GOOD.SDR SWAA2017040612972Sign · unsecureMID CABIN EXIT SIGN FELL DOWN. SECURED SIGN PER SIP.SDR AALA201703289030Lens · missingFWD (F/C) EMER EXIT LIGHT COVER MISSING. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY IN F/C GALLEY PER AMM 33-51-00. OP CK GOOD. OK FOR SERVICE.. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703289029Battery Pack · faultyRIGHT AFT EMERGENCY BATTERY PACK FOR EMERGENCY LIGHTING REQUIRES REPLACEMENT. REMOVED AND REPLACED RIGHT AFT EMERGENCY BATTERY PACK IAW AMM 33-51-06. OPS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017032812759Light · crackedLEFT FORWARD EMERGENCY LIGHT CRACKED AT ROW 1. R & R THE LIGHT IAW AMM.SDR QXEA2017032700184Battery Pack · dischargedALL 8 EMERGENCY LIGHT SYSTEM BATTERIES WERE DEPLETED. REPLACED ALL BATTERY PACKS.SDR QXEA2017032700183Battery Pack · failedEMERGENCY POWER SUPPLY 4 FAILED FUNCTIONAL CHECK OF EMERGENCY LIGHT POWER AND CHARGING SYSTEM. REPLACED BATTERY PACK.SDR QXEA2017032700182Battery Pack · failedEMERGENCY POWER SUPPLY 2 FAILED FUNCTIONAL CHECK OF EMERGENCY LIGHT POWER AND CHARGING SYSTEM. REPLACED BATTERY PACK.SDR ASAA2017032320266Cover · missingEMERGENCY EXIT SIGN HOUSING AT MID CABIN CEILING IS MISSING COVER ON FWD SIDE. ACFT GROUNDED. REPLACED THE COVER.SDR QXEA2017032700181Battery Pack · failedNR 3 EMERGENCY POWER SUPPLY FAILED FUNCTIONAL CHECK. REPLACED THE BATTERY PACK.
Back to JASC 3350