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 AALA20180314002Battery Pack · inoperativeAFT OVERWING EMERGENCY EXIT LIGHTS FOUND INOPERATIVE DURING AN A CHECK. REPLACED THE BATTERY PACK B5-105 IAW WDM 31-51-11. EMERGENCY EXIT LIGHT OPS CHECKED NORMAL.SDR REXA2018031300190Battery Pack · inoperativeLEFT AND RIGHT AFT EXTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT PS38 IAW AMM 33-51-17. OPS CHECKED SATISFACTORY.SDR SWAA2018031520450Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1672. R & R THE BATTERY IAW AMM.SDR SWAA2018031520449Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1669. R & R THE BATTERY IAW AMM.SDR SWAA2018031520448Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1668. R & R THE BATTERY IAW AMM.SDR SWAA2018031520420Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1675. R & R THE BATTERY IAW AMM.SDR SWAA2018031520419Lamp · inoperativeLEFT EMERGENCY EXIT HATCH COVER LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR R61A201803130315Power Supply · inoperativeL2 DOOR FLOOR LEVEL RECTANGULAR LIGHT WAS FOUND INOPERATIVE. THE POWER SUPPLY NR 3 WAS CHANGED IAW AMM 33-50-01.SDR AALA20180314009Battery Pack · inoperativeEMERGENCY LIGHTS DIM THEN INOPERATIVE. REPLACED THE EMERGENCY LIGHTS BATTERY PACKS IAW AMM 33-60-98.SDR AALA201803149007Lens · missingLENS MISSING FROM THE EMERGENCY LIGHT AT THE R1 DOOR. INSTALLED A NEW LENS.SDR DALA2018031501717Power Supply · inoperativeDURING SVC CHECK FOUND PORTION OF 1ST CLASS OVERHEAD CEILING EMERGENCY LIGHTS WON’T STAY ON DURING EMERGENCY TEST. R&R POWER SUPPLY PER AMM 33-53. OPS CK GOOD.SDR PNSA2018031301Light · inoperativeEMERGENCY LIGHTS ARMED SWITCH ON FA PANEL INOP. REPLACED BULBS, OPS OK.SDR DALA2018031401706Battery Pack · inoperativeDURING INSPECTION FOUND FWD LT DOOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED LEFT FWD BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR SIMA20180313007Light · inoperativeEMERGENCY EXIT LIGHT ABOVE EMERGENCY EXIT ROW INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-08-000-801-A, AND 33-50-08-400-801-A.. OPS CHECKED GOOD.SDR FDEA201803130654Light · inoperativeDURING A SERVICE CHECK, FOUND THE EXTERNAL RT DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOOD IAW 33-51-06-2-1.SDR MASA2018031313055Light · inoperativeL2 DOOR EMERGENCY LIGHTS INOPERATIVE.SDR SWAA2018041621179Bulb · inoperativeLEFT OVERWING HATCH EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR ASAA2018031223888Sign · detachedOVERWING EXIT SIGN IS BROKEN AND HANGING DOWN. GROUNDED - YES. RESECURED EXIT SIGN IAW AMM 33-51-01 OPS CHECKED NORMAL.SDR AALA20180314007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT DIM THEN INOPERABLE. MAINTENANCE REPLACED ESCAPE PATH LIGHT BATTERY PACK PER AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR UIEA2018031400406Switch · inoperativeEMERGENCY LIGHT SWITCH GUARD INOPERATIVE. REPLACED THE EMERGENCY LIGHT SWITCH GUARD ASSY. OPS CHECKED GOOD IAW AMM 33-61-00-715-304.SDR DALA2018031401714Battery Pack · dischargedEMERGENCY EXIT SIGN AT DOOR AND 1ST CLASS FLICKERS (ON AND OFF). MAINTENANCE REPLACED THE CABIN EMERGENCY LIGHT BATTERY PACK AND BATTERY OPERATION IS NOW NORMAL PER AMM 33-51.SDR JJBA20180312002Light · defectiveEXTERNAL EMERGENCY LIGHT AT MAIN DOOR INOP. TROUBLE SHOT TO BAD CONTACT ASSY. R&R MAIN CABIN DOOR LIGHT ASSY. OPS CK SAT MEL CLEARED.SDR AALA201803139027Light · inoperativeEMERGENCY LIGHT AT ROW 10D WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT.SDR AALA201803139026Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROWS 19D, & 15D. REMOVED AND REPLACED EMERGENCY LIGHTS.SDR SWAA2018031420413Lamp · inoperativeLEFT EMERGENCY AISLE LIGHT INOPERATIVE AT ROW 6. REPLACED THE LAMPS LIGHT IAW AMM.SDR CALA2018031300912Epsu · inoperativeEMERGENCY LIGHTS OPS TEST FAILS MULTIPLE EPSU AND BATTERY FAULTS. REMOVED AND REPLACED EPSU 12WL IAW AMM 33-51-38-000-001-A AND 33-51-38-400-001-A. REMOVED AND REINSTALLED BATT ON AFT EPSU 13UL IAW AMM 33-51-38-000-001-A AND 33-51-38-400-001-A. PER FORMED BITESDR DALA2018031301675Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT 20B IS INOPERATIVE. FOUND AISLE ESCUTCHEON BROKEN AND REPLACED AND REATTACHED EMERGENCY LIGHT BOX. SYSTEM OPS NORMAL.SDR DALA2018031301674Light · inoperativeSEAT 20A MOUNTED EMERGENCY LIGHT WAS FOUND INOPERATIVE. AISLE ESCUTCHEON WAS FOUND BROKEN AND REPLACED. SYSTEM OPS NORMAL.SDR AALA201803139011Light · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. ACCOMPLISHED ADJUSTMENT AND TEST OF EMERGENCY LIGHT IAW 33-56-00N.SDR AALA201803139010Lens · missingEMERGENCY LIGHT LENS MISSING AT THE FORWARD GALLEY. REPLACED THE LENS IAW AMM 33-51-05-10D.SDR SIMA20180312001Charger · inoperativeLT AND RT OVERWING EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED THE NR 4 BATTERY AND CHARGER ASSEMBLY IAW FIM 33-50-00-810-804-A, AND AMM 33-50-10. OPS CHECKED GOOD,SDR SIMA20180312003Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10, OPS CHECKED GOOD.SDR SIMA20180312002Lamp · inoperativeGALLEY DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. NO FURTHER DISCREPANCIES FOUND.SDR DALA2018031301578Lens · missingEMERGENCY EXIT SIGNS INOPERATIVE, LOCATIONS 25E, ACARS TEXT FRC25600125E INTERIOR. FOUND OVERWING EXIT DOOR LIGHT UPPER LENS COVER MISSING. INSTALLED NEW COVER. OK FOR SVC.SDR DALA2018031301577Light · damagedSEAT MOUNTED EMERGE LIGHT AT SEAT 16 IS DAMAGED. REPLACED LIGHT ASSY AT SEAT16 JAW AIM 33-50. OPS CHECK GOOD.SDR MASA2018031213053Lamp · inoperativeCEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2018031213054Lamp · inoperativeROW 3 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPSSDR DALA2018041602503Lens · damagedEMERGENCY EXIT LENS DAMAGED. REPLACED THE LENS IAW AMM 33-51.SDR UIEA2018032000441Light · inoperativeEMERGENCY LIGHT AT SEAT 21 A AND C INOPERATIVE. REPAIRED IAW SWPM 20-10-13SDR UIEA2018032000442Lamp · inoperativeEMERGENCY LIGHTS BY SEAT 17K INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-00.SDR REXA2018031100188Connector · looseCEILING EMERGENCY LIGHT INOPERATIVE IN THE FIRST CLASS CABIN. FOUND A CONNECTOR PLUG LOOSE AT P5437. OPS TESTED GOOD.SDR AALA20180312007Cover · detachedAIRCRAFT WAS NOT GROUNDED. L4 DOOR EXIT SIGN COVER IS OFF OF LIGHT PANEL. REINSTALLED LIGHT COVER PER AMM 25-25-00.SDR AALA20180312009Battery Pack · dischargedTHE AIRCRAFT IS IN BASE MAINTENANCE. DOOR 1E EXTERIOR LIGHT IS INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06. REPLACED R1 EXTERIOR EMERGENCY LIGHT LAMP SOCKET PER CH20 20-10-00 AND AMM 33-51-04. OPERATIONS CHECK NORMAL.SDR QXEA2018031300087Light · dimBOTTOM BETA LIGHT ON EMERGENCY EXIT DOOR IS DIM. REPLACED BETA LIGHT IAW AMM 33-51-00-960-801. CHECKS GOOD. RETURNED TO SERVICE.SDR AALA20180312001Light · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE COCKPIT EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-02 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018031201668Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND EMERGENCY LIGHTS AT SEATS 1A - 5A TO BE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK. SYSTEM OPS NORMAL.SDR SWAA2018031320393Lens · missingRIGHT OVERWING EXIT SIGN LENS MISSING. INSTALLED THE LENS IAW AMMSDR SWAA2018031320387Lamp · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2018031320385Bulb · inoperativeG4 EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW MM.SDR DALA2018031201657Lens · unsecureEMERGENCY EXIT SIGN LENS LOOSE. SECURED THE LENS. OK FOR SERVICE.
Back to JASC 3350