Boeing 737-823
Service difficulty reports · 31,890
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '737823' 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 aircraft_model_key = '737823' 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 AALA201908279026Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 777, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 770, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 775, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 766, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279021Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 761, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279020Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 759, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 747, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727I+14.5, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727I+8, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727J+12, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279012Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727I+8, LBL 20, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279011Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727I+6.5, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727D+8, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908279006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL, BS 727J+10, LBL 21, AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082759020Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 986 AND LBL 43. REPLACED FLOOR BEAM PER SRM 53-00-51-2R-1 AND EA 296997.SDR AALA2019082759019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER 51-00-05-R1.SDR AALA2019082759018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500G AND BS 500H AT S25R. REPLACED TRANSITION PANEL PER 51-00-05-R1.SDR AALA2019082759017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500F AND BS 500G AT S25R. REPLACED TRANSITION PANEL PER 51-00-05-R1.SDR AALA2019082759016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500E AND BS 500F AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05 R1.SDR AALA2019082759015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500D AT S25R. REPLACED TRANSITION PANEL PER 51-00-05-R1.SDR AALA2019082759014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500C AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-R1.SDR AALA2019082759013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759012Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500D AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759011Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B AND BS 500C AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759010Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500B AT S26L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500G AND BS 500H AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500F AND BS 500G AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500E AND BS 500F AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D AND BS 500E AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082759005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD ANGLE AT BS 500I AND S26L. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA2019082759004Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D AND BS 500E AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05 R1.SDR AALA2019080529009Pump · unreliableAIRCRAFT WAS GROUNDED: PILOT DECLARED EMERGENCY ON ACCOUNT OF NR 1 ENGINE LOW HYDRAULIC PRESSURE. MAINTENANCE REMOVED AND REPLACED NR 1 ENG HYD PUMP IAW 29-11-11, OPS CHECK & LEAK CHECK GOOD.SDR AALA2019080529019Snubber · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS FWD ENTRY DOOR SNUBBER INOP. REMOVED AND REPLACED SNUBBER IAW AMM 52-11-51, OPS CHECKS GOOD.SDR AALA201908299010Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500F TO BS 500G, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299009Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500G TO BS 500H, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299005Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500E TO BS 500F, S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA201908299008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500H TO BS 500I, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500D TO BS 500E, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500C TO BS 500D, LBL25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299002Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL FROM BS 500B TO BS 500C, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908299001Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL FROM BS 492 TO BS 500, -S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019082989044Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT LOWER THRESHOLD WEB AT BS 831 AND RBL 25. REPLACED THRESHOLD WEB PER SRM 51-10-02-0G.SDR AALA2019082989043Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT LOWER THRESHOLD WEB AT BS 800 AND RBL 25. REPLACED THRESHOLD WEB PER SRM 51-10-02-0G.SDR AALA2019082989042Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR THRESHOLD WEB BETWEEN BS 807 AND BS 827 AT RBL25. REPLACED THRESHOLD WEB PER SRM 51-40-02-0G.SDR AALA2019082759021Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE LANDING GEAR TRANSFER CYLINDER MOUNTING BRACKET JUST ABOVE NOSE LANDING GEAR WHEEL WELL FLOOD LIGHT BETWEEN BS 207 AND BS 259. REPLACED BRACKET PER 51.00-05-1.SDR AALA2019080529010Impeller · damagedAIRCRAFT WAS GROUNDED: PILOT REPORTS NR 2 FORWARD LOW PRESSURE LIGHT ILLUMINATED WITH PUMP TURNED ON. MAINTENANCE ACCOMPLISHED FIM TASK 28-22-810-806 STEP G- NO FAULTS NOTED. ACCOMPLISHED STEP H - REPLACED TANK 2 FWD BOOST PUMP LOW PRESSURE SWITCH-S153- NO HELSDR AALA2019080219001Control Handle · lack of lubeAIRCRAFT WAS GROUNDED: PILOT REPORTS ON RUNWAY CLEARED FOR T/O, GOT A TAKEOFF CONFIGURE LIGHT. ABORTED TO (20KTS) CLEARED AND FOUND PSEU LT ON, WOULD NOT CLEAR. MAINTENANCE ACCOMPLISHED BITE PSEU, FOUND FAULT MSG SPDBRK DN 27-62001 INTERMITTENT. CLEANED AND LUSDR AALA2019080219022Pitot Head · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING CRUISE FLIGHT FL 370 IN CLEAR SKIES, F/O ALTIMETER & AIRSPEED BECAME UNRELIABLE. IAS DESAGREE, ALT DISAGREE, EECS WENT INTO SOFT ALTN MODE. RAN AIRSPEED UNRELIABLE AND EEC ALTERNATE MODE QRH. INDICATIONS RETURNED TO SDR AALA201908029016Tat Probe · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING CRUISE FLIGHT FL 370 IN CLEAR SKIES, F/O ALTIMETER & AIRSPEED BECAME UNRELIABLE. IAS DESAGREE, ALT DISAGREE, EECS WENT INTO SOFT ALTN MODE. RAN AIRSPEED UNRELIABLE AND EEC ALTERNATE MODE QRH. INDICATIONS RETURNED TO SDR AALA201908029017Adc · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING CRUISE FLIGHT FL 370 IN CLEAR SKIES, F/O ALTIMETER & AIRSPEED BECAME UNRELIABLE. IAS DESAGREE, ALT DISAGREE, EECS WENT INTO SOFT ALTN MODE. RAN AIRSPEED UNRELIABLE AND EEC ALTERNATE MODE QRH. INDICATIONS RETURNED TO
Back to Boeing 737-823