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 AALA201808169004Light · inoperativeEXIT ROW 22BC OVERHEAD LIGHT WAS INOPERATIVE. REPLACED THE OVERHEAD LIGHT IAW AMM 33-21-11. OPS CHECKED GOOD.SDR AALA201808169003Light · inoperativeEXIT ROW 22ED SIDEWALL LIGHT WAS INOPERATIVE. REPLACED THE SIDEWALL LIGHT IAW AMM 33-21-11. OPS CHECKED GOOD.SDR MASA2018081513487Bulb · inoperativeEMERGENCY LIGHT, ROW 12, HAD 2 BULBS OUT. REPLACED THE BULBS.SDR MASA2018081513485Light · inoperativeEMERGENCY LIGHTS INOPERATIVE.SDR DALA2018081505090Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS INOPERATIVE FROM SEATS 17 - 26 WERE INOPERATIVE. R & R THE BATTERY PACKS IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2018081505089Battery Pack · inoperativeOVERWING EXIT SIGNS INOPERATIVE. R & R BATTERY PACKS, B5103, AND B5105 IAW AMM 33-50, OPS CHECKED NORMAL.SDR SWAA2018082024435Battery Pack · dischargedAFT EMERGENCY EXIT BATTERY M1673 INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018082024431Charger · brokenEMERGENCY EXIT LIGHT BATTERY CHARGER BROKEN AT M1673. R&R CHARGER PER AMM.SDR QXEA2018082000293Light · unsecureEMERGENCY LIGHT STRIP WAS DETACHED AT ROW 2DE. SECURED THE LIGHT STRIP. RETURNED TO SERVICE.SDR ASOA2018082045170Bulb · blownDURING MX INSPECTION, ROW 3 CEILING EMERGENCY LIGHT WAS INOPERATIVE. MX REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201808169018Sign · missingR1 DOOR EMERGENCY EXIT SIGN WAS MISSING AND THE MOUNT DAMAGED. MAINTENANCE REPLACED THE SIGN AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW MM 33-51-01.SDR AALA201808169012Light · inoperativePORTABLE EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE L1 PORTABLE EMERGENCY LIGHT IAW AMM 33-53-00.SDR DALA2018081655108Battery Pack · no testAFT LEFT EPSU BATTERY FAILED TO CHECK. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD.SDR AALA2018081659019Battery Pack · dischargedEMERGENCY LIGHTS VERY DIM. REPLACED FORWARD BATTERY PACK FOR EMERGENCY LIGHTS IAW MM 33-50-00.SDR SWAA2018081624285Battery · failedRT AFT CABIN EMERGENCY LIGHT BATTERY FAILED TEST. R&R BATTERY PER MM.SDR SWAA2018081624280Battery · failedLT AFT CABIN EMERGENCY LIGHT BATTERY FAILED TEST. R&R BATTERY PER MM.SDR SWAA2018081624271Light · inoperativeLT OVERWING EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2018081624270Battery · failedRT AFT CABIN EMERGENCY EXIT LIGHT BATTERY FAILED TEST. R&R BATTERY PER MM.SDR SWAA2018081624269Light · damagedRT FWD EEPLS DAMAGED. R&R EEPLS PER MM.SDR SWAA2018081624266Ballast · inoperativeOVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 12 DEF. R&R LIGHT BALLAST PER MM.SDR DALA201808165103Cradle · inoperativeDURING A SERVICE CHECK, MAINTENANCE FOUND THE AFT TAILCONE EMERGENCY LIGHTS TO BE INOPERATIVE. THE EMERGENCY CRADLE ASSEMBLY WAS REPLACED IAW AMM 33-51. OPS CHECKED GOOD.SDR REXA2018081540700Bulb · inoperativeGALLEY DOOR, EMERGENCY EXIT LIGHT, ONE BULB WAS INOPERATIVE. PERFORMED AN OPS TEST OF THE EMERGENCY LIGHT IAW AMM 33-51-00. OPS CHECKED GOODSDR SIMA201808154001Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10-04. OPS CHECKED GOOD.SDR DALA2018081405087Battery Pack · inoperativeSEVERAL EMERGENCY LIGHTS WERE INOPERATIVE IN THE TAIL SECTION. REMOVED AND REPLACED THE BATTERIES B5-28 IAW AMM 33-53.SDR 29GA2018081500001Switch · stuckEMERGENCY LIGHTS REMAIN ON AFTER ALL POWER REMOVED AND THE SWITCH OFF. FOUND F/A SWITCH GUARD PRESSED IN, ADJUSTED SWITCH IAW AMM 39-40-60-04. OPS CHECKED GOOD.SDR MASA2018081543483Light · inoperativeCEILING EMERGENCY FLOOD LIGHT WAS INOPERATIVE AT ROW 5.SDR SWAA2018082124499Light · damagedG1 LOWER EMERGENCY LIGHT ASSEMBLY DAMAGED. R&R LIGHT IAW AMM.SDR SWAA2018082024442Cover · crackedRT OVERHEAD STOWBIN EMERGENCY LIGHT LENS COVER CRACKED BETWEEN ROW 24 TO ROW 25. R&R COVER IAW AMM.SDR AALA201808169015Lens · missingEMERGENCY LIGHT LENS MISSING. MAINTENANCE SECURED THE LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201808169014Lens · missingEMERGENCY LIGHT LENS MISSING. MAINTENANCE SECURED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018081624268Lens · brokenRT OVERWING EXIT LIGHT LENS BROKEN. R&R LENS PER MM.SDR SWAA2018081624267Lens · looseLT OVERWING EXIT LIGHT LENS LOOSE. R&R LENS PER MM.SDR REXA2018081530699Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-21. OPS CHECKED GOOD.SDR IPXA2018081543814Light · inoperativeEMERGENCY LIGHT ABOVE THE CREW DOOR WAS INOPERATIVE. OPENSDR DALA2018081405082Lens · looseEMERGENCY EXIT SIGN LENS WAS LOOSE. SECURED THE SIGN LENS.SDR PNSA2018081400301Bulb · inoperativeFA CONTROL PANEL EMERGENCY LIGHT INOPERATIVE. R & R THE BULBS, OPS CHECKED GOOD.SDR 29GA2018081400001Bulb · inoperativeF/A REPORTED THE EMERGENCY LIGHT, BULB NOT WORKING. R & R THE BULB IAW AMM 33-20-00SDR DALA2018081305052Battery Pack · faultedEPSU EMERGENCY BATTERY FAULT FOUND THROUGH CIDS. CONFIRMED FAULT. REMOVED AND REPLACED EPSU BATTERY PACK IAW AMM. OPERATION CHECKED GOOD.SDR DALA2018081305013Battery Pack · inoperativeRT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR MASA2018081313477Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT, THE BULB WAS INOPERATIVE.SDR CALA2018081731793Power Supply · inoperativeSEVERAL BULL NOSE EMERGENCY LIGHTS WERE INOPERATIVE THROUGHOUT THE CABIN. REPLACED THE POWER SUPPLY 736 IAW AMM 33-51-07. LIGHTS OPS CHECKED OK.SDR CALA2018081731792Power Supply · inoperativeR4 DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 3-51-07. LIGHT OP CHECKED OK.SDR DALA2018081505100Sign · missingDOOR EXIT SIGN MISSING. R & R THE SIGN IAW AMM 33-22.SDR YENA2018081520313Battery Pack · no testDURING HEAVY MAINTENANCE, THE LT AFT EMERGENCY LIGHT FAILED TO ILLUMINATE WITH THE SWITCH IN THE ARMED POSITION AND C/B PULLED. REMOVED AND REPLACED THE BATTERY PACK & EPSU 13WL IAW AMM 31-51-38-00-001A, AND 33-51-38-400-001. SYSTEM OPS CHECKED GOOD IAW AMM SDR SWAA2018081324206Light · inoperativeRT SIDEWALL UNDER EMERGENCY EXIT LIGHT INOP AT ROW 12. REPAIRED LIGHT PER MM.SDR SWAA2018081324200Light · inoperativeRT OVERWING EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018081324184Battery Pack · failedRT FORWARD EMERGENCY EXIT LIGHT FAILED TEST. R&R BATTERY PACK PER MM.SDR IPXA2018081322718Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED THE POWER SUPPLY AND BATTERY IAW 33-51-07.SDR DALA2018081325010Battery Pack · inoperativeFOUND FWD CEILING EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-50. OPS CHECKED GOOD. OK FOR SERVICE.SDR MASA2018081213474Lamp · inoperativeROW 15 CEILING EMERGENCY FLOOD LIGHT WAS INOPERATIVE. REPLACED THE LAMPS.
Back to JASC 3350