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 U2RA201809250002Power Supply · inoperativeEMERGENCY LIGHTS L1853, L1854, AND L5735 ARE INOPERATIVE (MAIN DECK LEFT DOOR). REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AIRCRAFT MAINTENANCE MANUAL 33-51-04. LIGHTS OPERATE NORMAL.SDR U2RA201809250001Power Supply · inoperativeUPPER DECK RIGHT HAND DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY SUPPLY ASSEMBLY PER AIRCRAFT MAINTENANCE MANUAL 31-31-04. LIGHT OPERATES NORMAL.SDR FDEA201809252680Power Supply · inoperativeEMER LT BAT 1 LO ON PREFLIGHT TEST. REMOVED AND REPLACED EMERGENCY EXIT LIGHTS POWER SUPPLY REF AMM 33-51-01-4. OPS CK SATISFACTORY.SDR DALA2018101005964Lens · damagedSHIP 3874 EMERGENCY ESCAPE PATH LIGHT LENS DAMAGED AT LOC 1C AND 3C . CORRECTIVE ACTION: REPLACED WITH NEW SEAT LIGHT SHROUDS (0756729).SDR SWAA2018100325730Battery Pack · dischargedFORWARD ENTRY AREA EMERGENCY EXIT SIGNS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018100225710Sign · damagedAFT LAVATORY FORWARD WALL EMERGENCY EXIT SIGN BY DOOR L2 DAMAGED. INSTALLED LIGHT IAW AMM.SDR R61A2018092850988Power Supply · no testFWD EMERGENCY LIGHTS WILL NOT TEST FROM FA PANEL. R&R FWD LH EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR R61A2018092850986Light · inoperativeEMERGENCY LIGHT IN CABIN 3RD CEILING PANEL BACK INOP. R&R CEILING EMERGENCY LIGHT IAW AMM 33-50-13.SDR UIEA2018092602073Epsu · inoperativeL2 DOOR EMERGENCY LIGHT OPERATION TEST FAILED. L2 DOOR EMERGENCY LIGHT EPSU REPLACED IAW AMM 33-51-04 AND OPERATION TEST CARRY OUT RESULT NORMAL IAW AMM 33-51-04.SDR UIEA2018092802113Epsu · inoperativeL2 DOOR EMERGENCY LIGHT OPERATION TEST FAILED. L2 DOOR EMERGENCY LIGHT EPSU REPLACED IAW AMM 33-51-04 AND OPERATION TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-04.SDR UIEA2018092602074Epsu · inoperativeU/D AFT EMERGENCY LIGHT BATTERY OPERATION TEST FOUND INOP. U/D AFT EMER LIGHT EPSU REPLACED AND OPERATION TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-04.SDR UIEA2018092802105Light · missingCABIN G8 GALLEY LT PARTITION FWD EMERGENCY LIGHT FOUND MISSING WHEN AIRCRAFT INPUT. G8 GALLEY LT PARTITION FWD EMERGENCY LIGHT INSTALLED AS PER AMM 33-51-12.SDR UIEA2018092802106Light · damagedCABIN G8 GALLERY LT PARTITION AFT EMERGENCY LIGHT FOUND DAMAGED. G8 GALLEY LT PARTITION AFT EMERGENCY LIGHT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092802107Light · dimM/D L4 DOOR EXIT INDICATOR SIGN FOUND DIM. M/D L4 DOOR EXIT INDICATOR SIGN LAMP REPLACED AS PER AMM 33-51-12.SDR UIEA2018092802108Light · missingCABIN SEAT 17ABC SEAT EMERGENCY LIGHT FOUND MISSING WHEN AIRCRAFT INPUT. CABIN SEAT 17ABC EMERGENCY LIGHT INSTALLED AS PER AMM 33-51-12.SDR UIEA2018092802109Light · dimU/D LT EMERGENCY DR EXIT INDICATOR SIGN FOUND DIM. U/D LT EMERGENCY DR EXIT INDICATOR SIGN LAMP REPLACED AS PER AMM 33-51-12.SDR UIEA2018092802110Light · damagedCABIN CC12 RT FWD EMERGENCY LIGHT FOUND DAMAGED. CC12 RT FWD EMERGENCY LIGHT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092802111Light · damagedM/D L2 DOOR PARTITION EMERGENCY LIGHT FOUND DAMAGED. M/D L2 DOOR PARTITION EMERGENCY LIGHT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092802112Light · damagedCABIN C17 LT AFT EMERGENCY LIGHT FOUND DAMAGED. CABIN CC17 LT AFT EMERGENCY LIGHT REPLACED AS PER AMM 33-51-12.SDR SWAA2018092725568Lens · detachedL1 DOOR EMERGENCY EXIT LIGHT COVER DETACHED. R&R LENS PER AMM.SDR SWAA2018092725563Cover · looseRT EMERGENCY LIGHT COVER LOOSE AT ROW 3. SECURED COVER PER AMM.SDR AALA2018092769012Battery Pack · no testDURING ACCOMPLISHMENT OF TASK CARD 221N OF A CHECK 17 FOUND TRHEE AISLE EMERGENCY LIGHTS, RIGHT AISLE INOPERATIVE. REPLACED THE BATTERY PACK M33409. CHECKED OK IAW AMM 33-51-06.SDR SWAA2018092525508Battery Pack · dischargedAFT ENTRY EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR AALA201809269004Battery · dischargedFOUND FLASHLIGHT TAMPER SEAL BROKEN AND FLASHLIGHT NOT PROPERLY STOWED, AND WITH DEAD BATTERIES. REPLACED THE BATTERIES IAW AMM 25-64-00.SDR N6WA201809262501Lamp · inoperativeREAR EMER LT BURNED OUT.RELAMPED EMER LIGHT AT THE REAR IAW CRJ 700 AMM 33-51-09 PERFORMED OPS CHK IAW CRJ 700 AMM 33-51-00 OPS CHK GOOD AT THIS TIMESDR IPXA2018092654400Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-51-01-401. OPS CHECKED GOOD.SDR DALA2018092605765Battery Pack · inoperative(AIRCRAFT 6810, L/P 4723744) EMERGENCY LIGHT AT R2 DOOR INOP (FORM SEAT 19F TO 25F). REMOVE AND REPLACE EMERGENCY BATTERY AT R2 DOOR, NO FIX. REMOVE AND REPLACE EMERGENCY BATTERY SUPPLY CHARGER PER B757. AMM 33-51. OPS CHECK OK.SDR AALA201809269008Battery · no testWHILE ACCOMPLISHING AN EMERGENCY POWER SUPPLY UNIT CAPACITY TEST, THE 17WL POWER SUPPLY FAILED TO TEST. REPLACED THE POWER SUPPLY BATTERY IAW 33-51-38. OPS CHECKED OK.SDR AALA201809269007Battery · no testWHILE ACCOMPLISHING AN EMERGENCY POWER SUPPLY UNIT CAPACITY TEST, THE 14WL AND 17WL POWER SUPPLIES FAILED TO TEST. REPLACED THE POWER SUPPLY BATTERIES IAW 33-51-38. OPS CHECKED OK.SDR MASA2018092511410Light · inoperativeEMERG OVERHEAD FLOOD LIGHT ROW 18 INOP. PLACED ON MELSDR SWAA2018092725590Battery Pack · dischargedCOCKPIT EMERGENCY LIGHT INOP AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018092625548Guard · missingAFT EMERGENCY LIGHTS SWITCH LENS GUARD MISSING. R&R GUARD PER SIP.SDR SWAA2018092625529Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS PER MM.SDR SWAA2018092525526Battery Pack · dischargedLT EMERGENCY LIGHTS IN COCKPIT GALLEY FAULTY BETWEEN ROW 1 TO ROW 3. R&R BATTERY PACK PER AMM.SDR SWAA2018092525525Charger · faultyLT EMERGENCY LIGHTS IN COCKPIT GALLEY FAULTY BETWEEN ROW 1 TO ROW 3. R&R CHARGER PER AMM.SDR SWAA2018092525521Light · inoperativeRT OVER WING LOWER EXIT SIGN BULB INOP. SECURED BULB IAW AMM.SDR SWAA2018092525507Light · inoperativeLT OVER WING INTERIOR FORWARD EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201809265008Battery Pack · no testDURING ACCOMPLISHMENT OF TASK CARD 221N OF A CHECK 17, FOUND THE THREE LAST AISLE EMERGENCY LIGHTS, RIGHT AISLE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK M33409, AND PERFORMED A SATISFACTORY OPS CHECK IAW AMM 33-51-06.SDR HALA2018092500262Sign · unsecureDOOR 3R EXIT SIGN FELL OFF. RE-SECURED EXIT SIGN AT DOOR 3R.SDR AALA2018092659008Lens · detachedSMALL EXIT LIGHT LENS FELL OFF NEXT TO THE FORWARD GALLEY DOOR. REPLACED THE LENS IAW 33-10-00. OPS CHECKED GOOD.SDR IPXA2018092654393Battery Pack · inoperativeEMERGENCY LIGHT BATTERY 1 LOW LEVEL 1 WARNING, DURING TEST. REPLACED THE EMERGENCY LIGHTS BATTERY POWER SUPPLY IAW MM 33-51-01-401. OPS CHECKED GOOD.SDR HALA2018092500436Sign · unsecureEXIT SIGN AT 3R DOOR FELL OFF. PIECE IN COCKPIT. RE-SECURED EXIT SIGN AT 3R DOOR. OK FOR SVC.SDR AALA201809259017Lens · missingSEAT 8C EMERGENCY LIGHT LENS WAS MISSING. MAINTENANCE REPLACED THE LENS AMM 33-50-00, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201809259011Lens · missingSEAT 14A EMERGENCY LIGHT LENS WAS MISSING. REPLACED THE LAMPS IAW AMM 33-51-19. OPS CHECKED GOOD.SDR YENA2018092540356Epsu · failedFLT 950, GND-JFK. DURING WEEKLY CHK, FOUND SOME CABIN EMER LIGHTS INOP. PER EPSU TEST AND FOUND EPSU AT 11WL FAULTY. R&R EPSU AT 11WL PER AMM 33-51-38. BITE CHK PASSED.SDR QXEA2018092400343Battery Pack · dischargedFORWARD NR 1 LT AND RT BATTERY PACKS INOP. REMOVED AND REPLACED LT NR 1 AND RT NR 1 BATTERY PACKS IAW AMM 33-51-00-820-801. OPS TEST GOOD. NO FURTHER DEFECTS NOTED.SDR MASA2018092411406Light · inoperativeROW 1 O/H CEILING LIGHT INOP. PLACED ON MEL.SDR MASA2018092411405Light · inoperativeROW 20 OVERHEAD FLOOD LIGHT INOP. PLACED ON MEL.SDR SWAA2018092825616Light · inoperativeRT BULLNOSE EMERGENCY LIGHT INOP AT ROW 16. RELAMPED LIGHT PER AMM.SDR R61A2018092830989Light · out of positionPHOTOLUMINESCENT STRIP, RH SIDE AT ROW 14, MIGRATED FORWARD. NOT VISIBLE. ADJUSTED MIGRATED PHOTOLUMINESCENT STRIP AT RH ROW 14.
Back to JASC 3350