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 ASAA2017101722230Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ON THE NR 1 GALLEY ADJACENT TO R1 DOOR HAS BROKEN LENS. ACFT GROUNDED. REMOVED AND REPLACED THE LENS AND TESTED THE LIGHT ASSEMBLY IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017101722229Lens · detachedMID-CABIN EMERGENCY EXIT SIGN DETACHED. ACFT GROUNDED. ATTACHED THE SIGN COVER. OK FOR SERVICE.SDR IPXA2017101722700Lamp · inoperativeUPPER DECK SLIDE LIGHT INOPERATIVE REPLACED THE LAMP IAW AMM 33-51-10-962-001, REV 90.02. PERFORMED AN EMERGENCY LIGHT TEST WAS SATISFACTORY.SDR DALA2017101807616Battery Pack · inoperativeTHE EMERGENCY LIGHTS BETWEEN AFT LAVATORYS ARE INOPERATIVE. REPLACED THE BATTERY PACK AND CHECKED GOOD.SDR ASOA201710174055Battery Pack · inoperativeDURING PREFLIGHT INSPECTION, THE FWD EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE INSPECTED THE AIRCRAFT AND REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT BATTERY PACK, OPS TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICSDR FDEA201710172967Power Supply · inoperativeL1 DOOR EMERGENCY SIGN AND L1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-07-2, ALL INTERIOR AND EXTERIOR EMERGENCY LIGHTS CHECKED NORMAL.SDR DALA2017101707581Battery Pack · inoperativeMAIN ENTRANCE AND FWD SERVICE DOOR EXIT IDENTIFIER LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53, OPS CHECKED GOOD.SDR UIEA2017112302285Battery · dischargedLEFT OVER WING EMERGENCY EXIT LIGHT INOP. R&R BATTERY ASSEMBLY IAW AMM 33-51-07. OPS CHECK GOOD.SDR HNAA2017102000353Controller · failedEMERGENCY LIGHTS ARE ILLUMINATED IN THE ARM POSITION. WOULD NOT EXTINGUISH. R & R THE EMERGENCY LIGHT CONTROLLER IAW W/C 33-50-05R. OPS CHECKED GOOD.SDR SWAA2017101917220Battery Pack · dischargedAFT ENTRY EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017101917218Light · inoperativeLT EMERGENCY LIGHT AFT OF THE WING INOP. R&R BULB PER AMM.SDR SWAA2017101917197Lens · brokenFORWARD ENTRY THRESHOLD EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR SWAA2017101917191Cover · brokenR2 DOOR EMERGENCY LIGHT COVER BROKEN. REPAIRED COVER IAW SIP.SDR ASAA2017101622234Power Supply · failedEMERGENCY LIGHTS ILLUMINATED ON LANDING AND STAYED ON FOR APPROXIMATELY 30 SECONDS, THEN WENT OUT. ONLY 2 LIGHTS ILLUMINATED, FORWARD AND AFT OF EMERGENCY EXIT ROW RIGHT SIDE OF AIRCRAFT. ACFT GROUNDED. LOCATED BATTERY PACK & POWER SUPPLY M1671 AT ROW 22-23 SDR REXA2017101601103Light · missing24 INCHES OF THE EMERGENCY LIGHT STRIP WAS MISSING FROM GALLEY. SECURED THE LIGHT STRIP IAW AMM 33-51-01, OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR AALA20171016001Sign · brokenBROKEN EXIT LIGHT AT THE AFT, RIGHT PASSENGER ENTRY DOOR. INSTALLED THE SIGN IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR FDEA201710162966Battery Pack · inoperativeR1 INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE M730 POWER SUPPLY BATTERY PACK IAW AMM 33-51-07-2, OPS CHECKED GOOD.SDR R61A201710160766Battery · no testFWD SERVICE DOOR EXIT SIGN FOUND INOPERATIVE DURING AN EMERGENCY LIGHT FUNCTIONAL TEST. R & R THE EMERGENCY LIGHT BATTERY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR DALA2017101707603Battery Pack · inoperativeL3 DOOR EXTERIOR EMERGENCY LIGHT AND INTERIOR EMERGENCY LIGHTS WERE INOPERATIVE FROM ROWS 30 - 37AB. REPLACED THE BATTERY PACK AND CHARGER IAW MM 33-51. CHECKED OK, OK FOR SERVICE.SDR DALA2017101707602Lamp · inoperativeR2 DOOR SLIDE GROUND ILLUMINATION LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51.SDR DALA2017101707599Lens · missingINTERIOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OK FOR SERVICE.SDR DALA2017101707598Charger · inoperativeL4 DOOR SLIDE GROUND ILLUMINATION LIGHT INOPERATIVE. REPLACED THE CHARGER AND BATTERY PACK IAW AMM 33-51.SDR DALA2017101707582Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT THE AFT OVERWING EXITS. TROUBLESHOT IAW WDM 33-51-13. REMOVED AND REPLACED THE BATTERY PACKS. OPS CHECKED GOOD.SDR ASAA2017101622214Battery Pack · failedON LANDING, THE EMERGENCY LIGHTS IN THE MID-CABIN FLICKERED ON, THEN WENT OFF. ACFT GROUNDED. FOUND THE BATTERY PACK M2627 BAD. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805.SDR CALA2017101603649Lens · detachedR2 DOOR, SIGN LENS DETACHED. REPLACED THE LENSSDR CALA2017101603648Lens · missingEMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS.SDR CALA2017101603647Bulb · inoperativeEMERGENCY EXIT LIGHT NOT ARMED. BULB THE REPLACED.SDR CALA2017101603645Sign · detachedEMERGENCY EXIT SIGN IN MID-CABIN CAME LOOSE, INSTALLED THE SIGN. TESTED OK IAW AMM 33-51-01-960-802, AND 33-51-00-720-801.SDR DALA2017101607537Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS INOPERATIVE FROM ROWS 16 - 20. REPLACED THE BATTERY PACK B5-102. CHECKED GOOD.SDR AALA201710169031Lens · missingR4 DOOR MISSING THE EMERGENCY LIGHT LENS. INSTALLED A NEW LENS, OK FOR SERVICE.SDR DALA2017101707629Lens · missingEMERGENCY LIGHT LENS COVER MISSING AT 4C, INSTALLED NEW COVERSDR AALA201710169050Lens · brokenEMERGENCY EXIT SIGN BY THE R2 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201710169019Sign · looseTHE EXIT SIGN AT ROW 17DEF FOUND LOOSE. REPLACED THE SIGN.SDR AALA201710169018Lens · missingMISSING OVERHEAD EMERGENCY DOME LIGHT LENS, ROW 6. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-11.SDR IPXA2017101822743Bezel · missingL1 DOOR EMERGENCY LIGHT, FOR THE DOOR HANDLE MISSING THE LENS. INSTALLED A NEW BEZEL.SDR IPXA2017101622686Battery · no testBATTERY CHECK UPPER DECK LEFT DOOR INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017101717154Lamp · inoperativeRIGHT EMERGENCY ESCAPE HATCH AFT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017101717137Cover · detachedLEFT EMERGENCY EXIT SIGN COVER FELL OFF. SECURED THE COVER IAW AMM.SDR DALA2017101707605Lens · brokenAISLE LIGHT 10B LENS BROKEN. SECURED LENS. OK FOR SERVICE.SDR DALA2017101507601Battery Pack · inoperativeFOUND EMERGENCY LIGHTS AT ROWS 6A - 10A INOPERATIVE. REPLACED THE BATTERY PACK M7235 IAW AMM 33-51..CHECKED GOOD.SDR AALA201710169052Lens · missingEMERGENCY EXIT LIGHT AFT OF R2 DOOR MISSING THE LENS. REPLACED THE LENS.SDR HALA2017101600248Sign · detachedR3 DOOR EXIT SIGN DETACHED. SECURED THE SIGN.SDR HNAA2017101600349Inverter · inoperativeLEFT AFT INTERIOR OVERWING EMERGENCY EXIT SIGN WILL NOT ILLUMINATE. R & R THE INVERTER IAW AMM 33-50-11-000/400-801A. OPS CHECKED GOOD. OK FOR SERVICE.SDR REXA2017101501097Light · missingSEAT 12C MISSING THE EMERGENCY LIGHT. REPLACED THE EMERGENCY LIGHT IAW AMM 33-55-01.SDR SIMA20171015001Charger · inoperativeEXTERIOR OVERWING EMERGENCY LIGHTS INOPERATIVE. R & R THE NR 4 EMERGENCY LIGHT CHARGER ASSEMBLY AND BATTERY IAW W/C 33-700-19. OPS CHECKED GOOD.SDR DALA2017101600246Lamp · inoperativeSEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR CALA2017101503636Lens · brokenEMERGENCY EXIT LIGHT BROKEN IN ISLE ON THE FWD FIRST CLASS CLOSET. REPLACED THE LENS.SDR CALA2017101503635Light · inoperativeFORWARD SEAT EMERGENCY LIGHT INOPERATIVE AT 20C. REPLACED FORWARD THE LENS. OPS CHECKED NORMAL.SDR CALA2017101503634Light · inoperativeEMERGENCY EXIT SEAT LIGHT INOPERATIVE AT 12C. REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017101503630Lamp · inoperativeR4 DOOR EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-0 4-960-801.
Back to JASC 3350