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 AALA2019082629057Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 847 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA2019082629035Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER ATTACHMENT ANGLE CLIP AT BS 907 AND S27L. REPLACED ATTAMENT ANGLE CLIP PER SRM 51-40-02.SDR AALA2019081969026Transition 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 51-10-02.SDR AALA2019081969025Transition 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 51-10-02.SDR AALA2019081969024Transition 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 51-10-02.SDR AALA2019081969023Transition 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 51-10-02.SDR AALA2019081969022Transition 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 51-10-02.SDR AALA2019081969021Transition 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 51-10-02.SDR AALA2019081969020Transition 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 51-10-02.SDR AALA2019081969019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500 AND S27L. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA2019081969018Transition 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 51-10-02.SDR AALA2019081969017Transition 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 51-10-02.SDR AALA2019081969016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 510 AND S26L. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA2019081969015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 767 AND BS 787 AT S25L. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA2019081969014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 747 AND BS 767 AT RBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969013Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL AT BS 312 AND LBL46. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA2019081969040Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727D AND BS 727E AT LBL 21. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969039Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727 AND RBL 20. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA201908169038Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727J AND BS 747 AT RBL 20. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019081969036Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727I AND BS 727J AT RBL 20. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2019081969035Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727H AND BS 727I AT RBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969034Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727G AND BS 727H AT RBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969033Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727E AND RBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969032Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 767 AND BS 787 AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 747 AND BS 767 AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969030Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 787 AND BS 807 AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA2019081969028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA2019081969027Transition 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 51-10-02.SDR AALA2019081969052Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT THRESHOLD WEB BETWEEN BS 794 AND BS 847 AT S26R. REPLACED WEB PER AARD 51-00-05-1.SDR AALA2019081969051Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 518 AND S23R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969049Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969046Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727J AND BS 747 AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727I AND BS 727J AT RBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969044Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727H AND BS 727I AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969043Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727G AND BS 727H AT LBL 21. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969042Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727F AND BS 727G AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2019081969041Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727E AND BS 727F AT LBL 20. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA201908169053Transition 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 51-10-02.SDR AALA201907289001Cover · brokenAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY EXIT LIGHT PLASTIC COVER BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA201907259015Pressure Deck · crackedAIRCRAFT WAS GROUNDED: RIGHT HAND WHEEL WEEL FORWARD BULKHEAD PRESSURE DECK CRACKED AT BS 663.75 AT RBL 41. REPAIRED PRESSURE DECK PER SRM 57-10-10-2R-4.SDR AALA201907269005Cover · brokenAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY EXIT LIGHT PLASTIC COVER BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA201907259014Bulkhead · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED PRESSURE BULKHEAD AT BS 663.75 AND LBL 31.83. REPAIRED BULKHEAD PER SRM 57-10-10-2R-4.SDR AALA201907259003Warning System · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS DESCENDING THROUGH FL 350 AUTO FAIL LIGHT ILLUMINATED IN ACCORDANCE WITH QRH, SWITCHED TO ALTN, LIGHT EXTINGUISHED. MAINTENANCE ACCOMPLISHED BITE AND RESET CABIN PRESSURE CONTROLLERS #1 & #2 IAW AMM 21-31-00 OK FOR SERVICESDR AALA201907259006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 500B AND BS 500C AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA2019082629059Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED VERTICAL PRESSURE DECK WEB AT BS 663 BETWEEN RBL 40 AND RBL 45.64. REPAIRED VERTICAL PRESSURE DECK WEB PER SRM 57-10-10-2R-3.SDR AALA2019080259017Shear Web · crackedAIRCRAFT IN BASE MAINTENANCE, CRACKED SHEAR WEB UNDER G4 GALLEY AT BS 1019 AND RBL 20. REPAIRED SHEAR WEB PER EA 296254.SDR AALA201907259012Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 344 AND BS 360 AT LBL 1. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201907259011Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL AT BS 284 AND BL 0. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA201907259004Adiru · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS ON CLIMB OUT PASSING ABOUT FL240 IN IMC, THE A/S DISAGREE AND ALT DISAGREE MESSAGES (FOS SIDE WAS WRONG FAILED LOW) CAME ON. WE WERE FLYING THROUGH ICING AS WELL. DESCENDING THROUGH 16,000. FIRST OFFICERS INSTRUMENTS RETU
Back to Boeing 737-823