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 DALA2017063005103Battery Pack · inoperativeDURING INSPECTION, FOUND THE R2 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. MAINTENANCE R & R BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR 7C7A2017063000330Battery Pack · dischargedEMERGENCY LIGHT BY ROW 4A INOPERATIVE, R & R BAD EMERGENCY LIGHT BATTERY RECEPTACLE AND OPS CHECKED GOOD IAW MM 33-52-00.SDR AALA201706309010Lens · missingL1 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201706309009Switch · faultyDURING ENGINE SHUTDOWN WITH EMERGENCY LIGHTS SWITCH IN ARM THE EMERGENCY LIGHTS COME ON.SDR AALA201706309008Light · brokenEMERGENCY LIGHT ASSEMBLY BROKEN AT ROW 12 LEFT. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLEY AT ROW 12.SDR AALA201706309005Lens · missingEXIT LENS MISSING FROM 3R. INSTALLED LENS.SDR JJBA20170629032Light · inoperativeSERVICE DOOR THRESHOLD EXIT LIGHT INOPERATIVE. PERFORMED ADJUSTMENT AND TEST WITH NO FAULTS NOTED.SDR MASA2017062912418Bulb · inoperative14F EMERGENCY EXIT LIGHT HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR MASA2017062912419Bulb · inoperativeLIGHTED EXIT SIGN BY PAX DOOR ONE BULB INOPERATIVE.SDR MASA2017062912420Bulb · inoperativeLIGHTED EXIT SIGN BY SERVICE DOOR HAD ONE BULB INOPERATIVE.SDR SWAA2017080815520Power Supply · inoperativeRT STOWBIN EMERGENCY EXIT LIGHT INOP AT ROW 22. R&R POWER SUPPLY PER MM.SDR SWAA2017080815374Power Supply · inoperativeRT OVERHEAD EMERGENCY EXIT SIGN LIGHT INOP AT ROW 2R. R&R POWER SUPPLY IAW AMM.SDR SWAA2017080815373Power Supply · inoperativeLT STOWBIN EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 14 TO ROW 24. R&R POWER SUPPLY PER AMM.SDR SWAA2017080815325Power Supply · inoperativeL2 CABIN DOOR AFT EMERGENCY EXIT LIGHT INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2017070314722Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017070314721Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017070314713Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1671. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017070214706Lamp · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017070314695Lamp · inoperativeR2 DOOR EMERGENCY LIGHT EXTERIOR INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR DALA2017070205152Sign · unsecureFLIGHT ATTENDANT REPORTS EXIT SIGNS FALLING OFF AT LOCATION 608-104. REATTACHED SIGNS AND SECURE IAW MM.SDR DALA2017062905104Lens · missingRIGHT FORWARD OVERWING EMERGENCY LIGHT MISSING IT`S LENS, REPLACED THE LIGHT ASSY.SDR R61A201706300476Battery Pack · inoperativeL2 EXIT SIGN INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-50-00.SDR IPXA2017062918745Power Supply · inoperativeEMERGENCY EXIT EXTERNAL EGRESS LIGHT INOPERATIVE. R & R THE POWER SUPPLY M731. SYS CHECKED OK, IAW AMM 33-51-07.SDR YENA201706280542Battery Pack · failedEMERGENCY LIGHT FAILED TO TEST. R & R THE BATTERY PACK IAW AMM 33-51-11. EMERGENCY LIGHT TESTED OK.SDR AALA201706299016Light · looseEXIT LIGHT COVER OVER RIGHT AFT SERVICE DOOR IS LOOSE. INSTALLED NEW EXIT SIGN LIGHT ASSEMBLY ARE R2 DOOR IAW AMM 33-51-01 FUNCTIONS NORMAL.SDR AALA201706299008Battery · inoperativeFAULTED BATTERY AT EMERGENCY LIGHT 11WL. REPLACED BATTERY IAW MM 33-51-38.SDR DALA2017062905057Cover · looseEMERGENCY EXIT SIGN COVER AT LOCATION 608 LOOSE. SECURED EMERGENCY EXIT SIGN COVER.SDR DALA2017062905053Charger · inoperativeDURING SERVICE CHECK, FOUND EMERGENCY LIGHT INOPERATIVE OVERHEAD AT THE R3 DOOR AND FLOOR LEVEL LIGHT INOPERATIVE AT THE L3 DOOR. TROUBLESHOT. REMOVED AND REPLACED BATTERY CHARGER M735 IAW AMM 33-51-07-862-054. OPS NORMAL.SDR AALA201706299003Lens · damagedEMERGENCY EXIT LIGHT COVER 1C WONT STAY ON. INSTALLED EMERGENCY LIGHT LENS COVER-CHECK NORMAL.SDR AALA201706299006Lens · missingRIGHT FOWARD GALLEY EMERGENCY LIGHT LENS MISSING. REPLACED MISSING EMERGENCY LIGHT LENS.SDR SWAA2017062814672Sign · unsecureRT OVERWING LOWER EMERGENCY EXIT SIGN FELL OFF. R&R LIGHT IAW AMM.SDR PNSA2017062801Power Supply · no test3 POWER SUPPLIES FAILED ELPS TESTSDR REXA2017062800729Battery Pack · inoperativeLEFT AND RIGHT OVERWING EXIT EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-04, AND OPS CHECKED GOOD IAW AMM 33-51-04.SDR YENA201706280533Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R THE BATTERY PACK IAW AMM 33-51-11. EMERGENCY LIGHTS TESTED OK.SDR E07A201802140005Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ONSDR E07A201802140004Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ONSDR SWAA2017071014888Battery Pack · inoperativeRIGHT AFT GALLEY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK HOUSING IAW AMM.SDR SWAA2017070314711Lens · detachedFORWARD ENTRY DOOR EXIT LIGHT LENS COVER FELL OFF. SECURED THE LENS IAW SIP.SDR CALA2017063002011Sign · brokenL3 DOOR & R1 DOOR UPPER EXIT SIGNS STOPPERS FOUND BROKEN. REPLACED THE SIGN STOPPERS AND CARRY OUT CONDITION CHECK FOUND NORMAL IAW AMM 33-51-01-960- 802, REV.80, AND OPERATIONAL TEST FOUND GOOD.SDR DALA2017062805086Fuse · inoperativeDURING SERVICE CHECK, FOUND EMERGENCY LIGHTS FROM ROWS 31-41 ARE INOPERATIVE ON BOTH SIDES. REPLACED POWER SUPPLY FUSE AT M9010. SYSTEM OPERATION GOOD.SDR BJNA20170627006Battery Pack · inoperativeLEFT FWD EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LT FWD EMERGENCY LIGHT BATTERY PACK. CHARGED THE BATTERY PACK. OPS CHECKED GOOD IAW 33-51-51.SDR DALA2017062905069Charger · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHTS INOPERATIVE AT SEATS 17 - 23. MAINTENANCE R & R THE BATTERY AND CHARGER. ALL ENERGENCY LIGHTS OPS CHECKED GOOD.SDR AALA201706299015Cover · missingEMERGENCY EXIT LIGHT COVER MISSING FROM OVERHEAD DOOR 4R. REPLACED EMERGENCY LIGHT COVER OPS CHECKED GOOD IAW AMM33-51-00.SDR DALA2017062805055Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING / LOCATIONS:602. REPLACED EMERGENCY EXIT LIGHT COVER. OK FOR SERVICE.SDR SWAA2017062914687Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM.SDR SWAA2017062914685Cover · missingRT OVERWING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2017062914682Cover · defectiveL1 DOOR EMERGENCY EXIT LIGHT COVER MISSING RED ARROW. R&R COVER PER AMM.SDR SWAA2017062914679Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER AMM.SDR AALA201706289022Lens · detachedTHE AIRCRAFT WAS NOT GROUNDED. PLASTIC COVER ON EXIT SIGN DOOR LEFT AFT IS DETACHED. REPLACED EXIT SIGN LENS COVER AT AFT LEFT DOOR IAW MM 33-51-01 OPS GOOD.SDR AALA201706289020Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER MISSING AISLE SIDE OF F/C GALLEY WALL. REPLACED LIGHT ASSEMBLY IAW MM 33-51-02.
Back to JASC 3350