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 SWAA2018032220618Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018032120566Light · brokenCENTER OVERWING EMERGENCY EXIT LIGHT BROKEN FROM CEILING MOUNT. R&R LIGHT ASSEMBLY IAW CMM.SDR AALA201803229004Cover · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN COVER DISLODGED AT ROW 15. MAINTENANCE REINSTALLED EMERGENCY EXIT SIGN ABOVE ROW 15 SEAT ISLE PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803229003Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EEL LENS AT ROW 7DEF MISSING. INSTALLED NEW EEL LENS AT ROW 7DEF PER AMM 33-51-03. GOOD FOR SERVICE.SDR AALA201803219028Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LENS MISSING AT AFT RIGHT GALLEY DOOR. REMOVED AND REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA20180320009Battery Pack · weakTHE AIRCRAFT IS IN BASE MAINTENANCE. EMERGENCY LIGHT PACK B5-107 WEAK. REPLACED BATTERY PACK PER AMM 33-53-00.SDR AALA201803219030Cover · detachedAIRCRAFT WAS NOT GROUNDED. THE RIGHT HAND SIDE FLOOR LEVEL EMERGENCY LIGHT COVER IN THE MID GALLEY CAME OFF. REINSTALLED EMERGENCY LIGHT COVER.SDR AALA201803219016Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. OVER AISLE EXIT SIGN NOT WORKING. REPAIRED OVER AISLE EXIT SIGN PER 33-51-01.SDR AALA201803219020Sign · detachedOVERHEAD EXIT SIGN AT SEAT ROW 21 RT DETACHED. THE OVERHEAD EXIT SIGN WAS SECURED IAW 33-51-01-1. OK FOR FURTHER SERVICE.SDR AALA201803219029Lens · missingCABIN ENTRY DOOR, EMERGENCY EXIT LIGHT LENS MISSING AT THE FORWARD GALLEY DOOR. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-02, AND PERFORMED SATISFACTORY OPERATIONAL CHECK, NO FAULTS NOTED.SDR AALA201803209021Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. DOOR L1 EXIT SIGN MISSING. REPLACED EXIT SIGN ON DOOR L1 AS REQUIRED.SDR SIMA20180319002Sign · inoperativeRIGHT ESCAPE HATCH UPPER EXIT SIGN INOPERATIVE. REMOVED AND REPLACED THE SIGN. OPS CHECKED GOOD IAW AMM 33-50-14.SDR R61A201803190380Light · missingEMERGENCY LIGHT STRIP MISSING IN THE FWD CABIN NEAR SEAT 1D. REPLACED THE EMERGENCY LIGHT IAW CMM 33-51-07.SDR AALA201803209025Lens · damagedSEAT 14C EMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS.SDR DALA2018032001801Battery · dischargedDURING SVC FOUND EMERGENCY LIGHTS INOP ABOVE AFT OVERWING EXIT DOOR. R&R EMERGENCY PATH BATTERIES PER AMM 33-55 OPS CK GOOD.SDR MASA2018031913071Power Supply · inoperativeROW 13 EMERG EXIT LIGHTS INOP. REPLACED POWER SUPPLY 37.SDR QXEA2018031900095Lamp · inoperativeON FORWARD FA PANEL, EMERGENCY LIGHT BUTTON NOT ILLUMINATED. REMOVED FROM SERVICE. REPLACED THE EMERGENCY LIGHT SWITCH. NO OTHER DEFECT NOTED. AIRCRAFT RETURNED TO SERVICE.SDR MASA2018031913068Light · inoperativeCEILING FLOOD LIGHT INOPERATIVE AT ROWS 9 AND 18.SDR SWAA2018032220630Lens · missingR2 DOOR EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS PER EA.SDR SWAA2018032220629Light · dimLT OVERHEAD OVERWING EMERGENCY LIGHT DIM. RELAMPED LIGHT PER AMM.SDR SWAA2018032220598Light · damagedFORWARD RECESSED CEILING PANEL EMERGENCY LIGHT ASSEMBLY DAMAGED. R&R LIGHT IAW DWG & AMM.SDR AALA201803209014Battery Pack · defectiveAIRCRAFT WAS GROUNDED. SEAT MOUNTED EMERGENCY LIGHTS BATTERY PACKS REQUIRE REPLACEMENT. REPLACED SEAT MOUNTED EMERGENCY LIGHT BATTERY PACKS PER AMM 33-53-00.SDR AALA201803209013Battery Pack · defectiveAIRCRAFT WAS GROUNDED. OVERWING EMERGENCY LIGHT BATTERY PACK REQUIRES REPLACEMENT. REPLACED OVERWING EMERGENCY LIGHT BATTERY PACK PER 33-53-00.SDR AALA201803209019Lens · unsecureEMERGENCY EXIT LIGHT AT THE L3 DOOR FOUND DAMAGED. SECURED THE EMERGENCY LIGHT LENS. NO DAMAGED NOTED. OK FOR SERVICE IAW AMM 33-51-00.SDR AALA20180319006Battery Pack · inoperativeDURING PS2 CHECK, FOUND THE EMERGENCY LIGHT AT L4 DOOR AND CEILING EMERGENCY LIGHT AT SEATS 31ABC THRU 38ABC INOPERATIVE. REPLACED THE BATTERY PACK M33407 IAW AMM 33-51-06.SDR AALA201803219025Sign · crackedEMERGENCY EXIT SIGN CRACKED AT THE GALLEY DOOR FIRST CLASS. MAINTENANCE REPLACED THE SIGN IAW MM 11-00-01, AND PERFORMED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDEDSDR AALA201803219023Lens · missingRIGHT FORWARD SERVICE DOOR, THE EXIT SIGN LENS WAS MISSING. MAINTENANCE REPLACED THE SIGN LENS IAW AMM 33-25-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803219022Lens · looseEMERGENCY LIGHT LENS AT THE R2 DOOR WAS FOUND LOOSE. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT LENS IAW AMM 33-51-13, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018032020538Light · inoperativeLT EXTERIOR OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018032020522Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT BULB INOP. R&R LIGHT ASSEMBLY PER AMM.SDR SIMA20180318003Lamp · inoperativeLEFT EXIT ROW CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-50-07. OPS CHECKED GOOD.SDR ASAA2018031823962Lens · detachedMID CABIN CEILING EMERGENCY EXIT SIGN LENS DETACHED. ACFT GROUNDED. SECURED THE LENS IAW AMM 33-51-01.SDR R61A201803180379Light · crackedFWD PASSENGER DOOR EXIT IDENTIFIER LIGHT SURROUND CRACKED. R & R FWD PASSENGER DOOR EXIT IDENTIFIER LIGHT IAW AMM 33-50-15. OPS CHECK GOOD.SDR AALA201803209004Lens · missingFOUND THE AFT LEFT EXIT SIGN LENS MISSING DURING A PREFLIGHT. INSTALLED THE LENS IAW AMM 35-51-01.SDR DALA2018031901810Lens · looseEMERGENCY EXIT SIGN COVER LOOSE AT LOCATION 607. INSTALLED EMERGENCY EXIT SIGN LENS.SDR SWAA2018031920497Sign · brokenOVERWING EMERGENCY EXIT SIGN BROKEN ON LANDING. R & R THE SIGN IAW MM.SDR QXEA2018031900094Bulb · inoperativeFA REPORTED THE FORWARD EMERGENCY LIGHT SWITCH BULB OUT. REMOVED FROM SERVICE. REPLACED THE BULB IN THE EMERGENCY LIGHT SWITCH, CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR FDEA201803180726Power Supply · inoperativeDURING SERVICE CHECK, FOUND LEFT EXTERIOR SLIDE LIGHT NEXT TO L1 DOOR INOP. RELAMPED LIGHT, NO HELP. REMOVED AND REPLACED POWER SUPPLY REF AMM33-51-07-2 AND TESTED NORMAL.SDR SWAA2018032720768Lens · out of positionABOVE STOWBIN RIGHT EMERGENCY LIGHT LENS OUT OF POSITION AT ROW 14. R & R THE LIGHT IAW AMM.SDR AALA201803219019Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT SEAT ROW 15F. REPLACED THE LENS.SDR AALA201803219009Battery Pack · no testEMERGENCY POWER SUPPLY BATTERY AFT LEFT FAULTED DURING EMERGENCY LIGHT TEST. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803209012Battery Pack · inoperativeCREW REPORTED THE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED ALL OVERHEAD EMERGENCY LIGHT BATTERY PACKS IAW AMM 33-53-00. EMERGENCY LIGHTS OPS CHECKED NORMAL.SDR AALA201803209011Cover · missingEMERGENCY EXIT COVER MISSING AT SEAT ROW 15F. REPLACED EMERGENCY LIGHT COVER.SDR DALA2018032001829Power Supply · inoperativeSEVERAL EMERGENCY LIGHTS AT SEAT ROWS INOPERATIVE, REPLACED THE EPSU 11WL UNIT.SDR AALA201803209018Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT CLEAR LENS LIGHT MISSING AT 25D. REPLACED MISSING LENS AT 25D PER 33-53-10.SDR SIMA20180317001Sign · inoperativeEMERGENCY EXIT SIGN BY SEAT 3BC FWD BULKHEAD INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-50-13. OPS CHECKED GOOD.SDR AALA201803199022Lens · missing4C AISLE EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201803199009Cover · brokenL4 DOOR EXIT LIGHT COVER BROKEN AND HANGING LOOSE. REPLACED THE EMERGENCY LIGHT COVER. CHECKED GOOD IAW AMM 33-51-17.SDR AALA201803199007Lens · missingEXIT SIGN AT THE R4 DOOR, THE LENS WAS MISSING. REPLACED LENS.SDR SWAA2018031920507Light · inoperativeFORWARD EMERGENCY LIGHT STRIP INOPERATIVE. R & R THE LIGHT IAW AMM.
Back to JASC 3350