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 SWAA2017013011515Battery Pack · inoperativeRIGHT OVERWING DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017013111580Sign · brokenR2 DOOR EMERGENCY EXIT SIGN LIGHT COVER BROKEN. R & R THE SIGN IAW MM.SDR REXA2017012900129Light · missingEMERGENCY FLOOR TRACK LIGHT STRIP MISSING AT 13CD. REPLACED EMERGENCY FLOOR TRACK LIGHT STRIP AT 13CD IAW AMM 33-5
1-01.SDR SWAA2017020811736Housing · brokenCENTER CEILING EXIT LIGHT HOUSING ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR AALA20170128003Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT AT 21DEF INOPERABLE. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 21DEF PER AMM 33-51-11.SDR DALA2017013100855Light · malfunctionedEMERGENCY CEILING LIGHTS ILLUMINATED WITH CABIN AND FLIGHT DECK SWITCH IN NORMAL POSITION. CYCLED EMERGENCY POWER SWITCH. OPS CHECKED GOOD.SDR AALA20170131034Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131033Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131032Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131031Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131030Power Supply · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131029Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131028Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131027Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131025Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131024Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131023Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131022Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131021Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170131018Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R1 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170131014Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 15WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170129003Epsu · failedAIRCRAFT WAS GROUNDED. EMERGENCY POWER SUPPLY UNIT 12WL FAILED TEST. REMOVED AND REPLACED EPSU IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170129001Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS INOPERATIVE DURING PREFLIGHT CHECK. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201701299012Lens · missingAIRCRAFT NOT GROUNDED. DOOR 4R EMERGENCY EXIT LIGHT COVER MISSING. REPLACED 4R EMERGENCY EXIT LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATION.SDR REXA2017012800133Light · inoperativeP/R 721803-G-2 GALLEY EMERGENCY LIGHT HAS THREE (3) BURNT OUT LIGHT BULBS. REMOVED AND REPLACED (3) BURNT BULBS IAW AMM 33-51-11. OPS CK GOOD.SDR AALA201701299013Cover · wrong partEMERGENCY EXIT LIGHT COVER DOESN'T SAY EXIT. REPLACED EXIT COVER WITH THE CORRECT COVER.SDR DALA2017013000792Fuse · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE AT ROWS 30-36. REPLACED THE FUSE IN THE BATTERY ASSEMBLY AT ROW 35 IAW SWPM 20. EMERGENCY LIGHTS OPERATE NORMALLY.SDR AALA201701299008Battery · inoperativeFLIGHT ATTENDANT FLASHLIGHT AT JUMPSEAT R4 INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2017012913381Power Supply · inoperativeEMERGENCY LIGHT BATTERY 1 LOW ALERT DURING EMERGENCY LIGHT TEST. REMOVED & REPLACED THE POWER SUPPLY IAW MM 33-51-01, OPS CHECKED NORMAL IAW 33-51-01-05-015.SDR DALA2017013000717Power Supply · inoperativeDURING TURN-AROUND CHECK, MAINTENANCE FOUND THAT BOTH OF THE EXTERIOR EMERGENCY FLOOD LIGHTS FOR THE LEFT AND RIGHT WINGS WERE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR MASA2017012812837Light · inoperativeEXIT LIGHT 6D BULBS OUT. REPLACED BULBS.SDR MASA2017012812836Light · inoperativeLOWER EXIT LIGHT AT FWD FA SEAT INOP. ADJUSTED, REROUTED WIRES.SDR SWAA2017020311651Lens · missingLEFT OVERHEAD BIN EMERGENCY LIGHT LENS COVER MISSING AT ROW 9. R & R THE LENS IAW SIP.SDR AALA20170131011Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN AT R3 DOOR CROSS AISLE IS MISSING. REMOVED AND REPLACED LIGHT ASSEMBLY (AALA20170131010) AND LENS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170131010Light · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN AT R3 DOOR CROSS AISLE IS MISSING. REMOVED AND REPLACED LIGHT ASSEMBLY AND LENS (AALA20170131011) IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170131009Lens · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN AT L3 DOOR CROSS AISLE IS MISSING. REMOVED AND REPLACED LIGHT ASSEMBLY (AALA20170131008) AND LENS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170131008Sign · missingAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN AT L3 DOOR CROSS AISLE IS MISSING. REMOVED AND REPLACED LIGHT ASSEMBLY AND LENS (AALA20170131009) IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170131005Sign · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY R1 DOOR AND G1 GALLEY IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170131004Sign · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L1 DOOR IS CRACKED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR DALA2017013000808Light · not seatedEXTERNAL AFT LEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RESEATED LIGHT, OPS CHECKED GOOD.SDR SWAA2017013011566Sign · missingR2 DOOR EXIT SIGN MISSING. INSTALLED THE SIGN IAW AMM.SDR SWAA2017013011563Lamp · inoperativeL/H WING TRAILING EDGE EMERGENCY EXIT SLIDE AFT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017013011536Lens · looseL1 EMERGENCY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW SIP.SDR SWAA2017013011528Lens · detachedOVERWING OVERHEAD EMERGENCY EXIT SIGN LENS FELL OUT. REINSTALLED LENS IAW SIP.SDR AALA201701289009Lens · missingEMERGENCY LIGHT COVER SEAT 9D MISSING. REPLACED THE LENS AND ACCOMPLSIHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201701289008Lens · missingR4 DOOR EXIT LIGHT COVER MISSING. INSTALLED THE LIGHT COVER.SDR AALA201701289007Lens · brokenEMERGENCY EXIT LIGHT COVER AT THE R2 DOOR IS BROKEN. REPLACED EMERGENCY EXIT LIGHT LENS.SDR AALA201701289005Lens · brokenR4 DOOR EXIT LIGHT LENS COVER BROKEN. REPLACED EXIT LIGHT LENS COVER AT R4 DOOR IAW A321 AMM 33-51-19. AIRCRAFT NOT GROUNDED.SDR AALA20170130010Sign · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY L1 DOOR IS CRACKED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR ASAA2017012719568Battery Pack · dischargedWHILE ACCOMPLISHING TASK CARD 78233008 FOUND ALL EMERGENCY LIGHTS AT R1 DOOR INOPERATIVE AND FIRST CLASS AREA LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED BATTERY PACK FOR LIGHTING/EMERGENCY FOR ALL LIGHTS AT R1 DOOR AND FIRST CLASS AREA IAW AMM 33-51-06-960-8
Back to JASC 3350