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 SWAA2016111609733Sign · looseL1 DOOR EXIT SIGN LOOSE. SECURED SIGN PER EA.SDR DALA2016111608848Lens · crackedTHE PILOT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER COVER WAS CRACKED. MAINTENANCE REPLACED THE LENS/COVER AND THE OPERATIONAL CHECK WAS GOOD.SDR DALA2016111608846Lens · brokenTHE PILOT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER COVER WAS BROKEN. MAINTENANCE REPLACED THE LENS/COVER AND THE OPERATIONAL CHECK WAS GOOD.SDR AALA20161116013Lens · detachedAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY EXIT SIGN LENS COVER DETACHED. SECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161116007Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT FLOOR PROXIMITY LIGHT LENS MISSING. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161116006Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS COVER BETWEEN 4L AND 4LC JUMPSEAT ON WALL NEAR FLOOR IS DETACHED. SECURED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161116002Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 31C AISLE COMPARTMENT IS MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161116001Battery · dischargedAIRCRAFT WAS NOT GROUNDED. LEFT AND RIGHT FORWARD OVERWING EXIT EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED M1209 POWER SUPPLY BATTERY IAW AMM 33-51-07 AND WDM 33-51-01. OPERATIONAL CHECK NORMAL.SDR AALA20161115030Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ACROSS LAV 2F-1R AND GALLEY CORNER OF 477 COMPARTMENT IS MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115029Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT LEFT SIDE OF GALLEY COMPARTMENT 1011 AND SIDE OF LAV 5F-R IS MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115028Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT RIGHT SIDE OF GALLEY COMPARTMENT 672 SIDE OF LAV 5F-R IS MISSING LENS. REPLACED LENS IAW AMM 31-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115027Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT CREW REST AREA RIGHT SIDE CORNER IS MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115026Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT CORNER OF SEATS 33H AND 32J BEHIND GALLEY COMPARTMENT 672 IS MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115024Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT MID GALLEY COMPARTMENT MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115023Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LEFT SIDE MID BAR COMPARTMENT MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. DURING ACCOMPLISHMENT OF CARD 2908 SEAT MOUNTED EMERGENCY LIGHTS AFT BETWEEN ROWS 21 AND 31 DID NOT ILLUMINATE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY ML1672 IAW AMM 33-51-06.SDR AALA201611169025Power Supply · failedAIRCRAFT WAS NOT GROUNDED. FAILED CABIN EMERGENCY POWER SUPPLY UNIT 13WL. REPLACED POWER SUPPLY PER AMM 33-51-38.SDR AALA201611169017Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY LIGHT RED LENS COVER AT SEAT 9D. EMERGENCY LIGHT ASSEMBLY AT SEAT 9D PER AMM 33-51-18.SDR AALA201611169016Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY LIGHT RED LENS COVER AT SEAT 8C. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 8C PER AMM 33-51-18.SDR AALA201611169015Lens · missingAIRCRAFT WAS NOT GROUNDED. DOOR 2R EMERGENCY EXIT LIGHT LENS MISSING. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201611169014Light · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT ROW 9D INOPERATIVE. SECURED EMERGENCY EXIT LIGHT AT SEAT 9D PER AMM 33-50.SDR R61A201611150667Light · inoperativeEMERGENCY LIGHT NEAR SEAT 1A INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR SWAA2016122910805Light · damagedMID CABIN OVERHEAD EXIT LIGHT DAMAGED. R & R LIGHT ASSY IAW MM.SDR CALA2016111800922Battery Pack · dischargedL3 DOOR EXTERIOR EMERGENCY LIGHT FOUND DIM. THE BATTERY PACK WAS REPLACED AND CHECKED NORMAL IAW AMM 33-51-05SDR CALA2016111800921Battery Pack · dischargedMID GALLEY EMERGENCY LIGHT FOUND DIM IN MID GALLEY. THE BATTERY PACK WAS REPLACED AND TESTED NOMRAL IAW AMM 35-51-05.SDR DALA2016111508934Guard · damagedEMERGENCY LIGHTS SWITCH IS NOT ARMING WHEN COVER CLOSED. REPLACED EMERGENCY LIGHT SWITCH GUARD, CHECKED GOOD.SDR DALA2016111608933Battery Pack · inoperativeEMERGENCY EXIT SIGN AT 2R DOOR INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2016111808931Light · brokenEMERGENCY LIGHT SEAT 30D MOUNT ASSY BROKEN. REPLACED THE BUMPER AND MOUNT ASSY AT 30D.SDR SWAA2016111709830Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2016111709829Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2016111709828Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2016111709818Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2016111709812Battery Pack · dischargedEMERGENCY EXIT LIGHT POWER SUPPLY INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2016111709788Light · inoperativeRT EMERGENCY EXIT DOOR LIGHT INOP. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2016111709782Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 16. RELAMPED LIGHT PER AMM.SDR DALA2016111608879Light · missingEMERGENCY LIGHT MISSING JUST FORWARD OF OF ACFT RIGHT SIDE. REPLACED THE LIGHT.SDR DALA2016111608876Light · inoperativeBOTH CREW REST EMERGENCY EXIT SIGNS ARE INOPERATIVE. MAINTENANCE RELAMPED BOTH SIGNS. SYSTEM OPERATION IS NORMALSDR SWAA2016111609762Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. RELAMPED BULB PER AMM.SDR CALA2016111695981Module · malfunctionedEMERG LIGHT AT FWD LEFT OVER WING EXIT, LIGHT SIGN DOES NOT TURN ON WITH SWITCH IN COCKPIT RESET LT OVERWING EXIT BATTERY LIGHT MODULE. LIGHT WORKS REF MM 33-51-00-710-001-A.SDR AALA20161116019Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 27H INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20161116014Light · inflt separationAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 12D INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161115025Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT LAV 4F-LC MISSING LENS. REPLACED LENS IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161115011Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AISLE EMERGENCY LIGHTS ON BOTH SIDES OF ROWS 25 THRU 30 ARE INOPERATIVE. REMOVED AND REPLACED R4 DOOR WIRELESS CONTROL UNIT ASSEMBLY IAW AMM 33-51-07. OPERATIONAL CHECK NORMAL.SDR AALA20161115003Battery · faultyAIRCRAFT WAS NOT GROUNDED. WELS UNIT 4 SHOWS ACTIVE MESSAGE FOR DEGRADED BATTERY. REMOVED AND REPLACED WELS UNIT 4 BATTERY IAW AMM 33-51-07. MESSAGE WENT INACTIVE AND OPERATION CHECK NORMAL.SDR AALA201611169023Cover · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN DOOR SURROUND PANEL 226CRW EXIT SIGN COVER. REPLACED EXIT SIGN COVER PER AMM 33-50-00 AND AMM 33-50-15.SDR AALA201611169022Cover · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN DOOR SURROUND PANEL 251HLW EXIT SIGN COVER. REPLACED EXIT SIGN COVER PER AMM 33-50-00 AND AMM 33-50-15.SDR AALA201611169021Cover · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN DOOR SURROUND PANEL 252HRW EXIT SIGN COVER. REPLACED EXIT SIGN COVER PER AMM 33-50-00 AND AMM 33-50-15.SDR AALA201611169020Lens · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN LOWER CEILING PANEL EMERGENCY LIGHT LENS COVER AT 253GLC. REPLACED LIGHT LENS COVER PER AMM 33-50-17.SDR AALA201611169019Lens · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN LOWER CEILING PANEL EMERGENCY LIGHT LENS COVER AT 228ARC. REPLACED LIGHT LENS COVER PER AMM 33-50-17.SDR AALA20161115019Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN LENS COVER OVER L1 DOOR DETACHED. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.
Back to JASC 3350