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 AALA2019082629052Splice Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INNER FUSELAGE SKIN BUTT SPLICE PLATE AT BS 887 AND S26L. REPAIRED BUTT SPLICE PLATE PER EA 296850.SDR AALA2019082629039Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 440 AND BS 456 AT S25R. REPLACED SILL WEB PER AARD 51-00-05.SDR AALA2019082329084Failsafe · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FORWARD FRAME FAIL SAFE STRAP AT BS 440 BETWEEN RBL 28 AND RBL 33. REPAIRED FRAME FAIL SAFE STRAP PER EA 296739.SDR AALA2019082329029Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 489 AND BS 495 AT RBL 26. REPLACED WEB PER AARD 51-00-05.SDR AALA201907189016Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BETWEEN BS 954 AND BS 962 AT LBL 53. REPLACED CREASE ANGLE PER 51-00-05-1.SDR AALA201907189008Electronic Unit · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS PRIOR TO FLAP SELECTION DURING APPROACH, FLAP INDICATOR SHOWED SMALL NEEDLE SPLIT. WHEN FLAP HANDLE MOVED TO FLAPS 1 NEEDLES DID NOT MOVE AND OHP LE DEVICES PANEL SHOWED NO MOVEMENT. QRH PROCEDURE FOLLOWED, CALL FLAPS UP LSDR AALA201907189011Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL ANGLE BETWEEN BS 767 AND BS 787 AT S25R. REPLACED TRANSITION PANEL ANGLE PER 51-00-05.SDR AALA201907189005Unknown · malfunctionedAIRCRAFT WAS GROUNDED: WHEN SETTING STAB TRIM FOR TAKE OFF, NEITHER YOKE TRIM SWITCH WOULD ACTIVE ELECTRIC TRIM MOTORS. TRIM WHEELS COULD BE MOVED MANUALLY. MAINTENANCE ACCOMPLISHED STM INTERNAL LOGIC RESET IAW FIM 27-41-00. PERFORMED STAB. ELEC. TRIM SYS. REPSDR AALA2019082629054Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 958 AND RBL 50. REPLACED THE FLOOR SUPPORT PER 51-00-05-1.SDR AALA2019082629072Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT BS 947 AND RBL 51. REPAIRED FLOOR BEAM PER EA 296627.SDR AALA2019082629063Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT AT BS 950 BETWEEN LBL 27 AND LBL 49. REPLACED FLOOR SUPPORT PER 51-00-05-1.SDR AALA2019082629060Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT 958 AND LBL 28. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA2019082629045Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND LBL 4. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629044Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND RBL 11. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629043Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND LBL 12. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629042Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947.5 AND RBL 4. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5 AND EA 296627.SDR AALA2019082629040Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD RIGHT HAND DOOR CUT OUT CREASE ANGLE SPLICE AT BS 304 AND RBL 55. REPLACED CREASE ANGLE PER EA 296725 AND AARD 51-00-05-1.SDR AALA2019082629038Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 986.5 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R.SDR AALA2019082629037Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD RIGHT HAND DOOR CUT OUT CREASE ANGLE AT BS 332 AND RBL 55. REPLACED CREAASE ANGLE PER EA 296725.SDR AALA2019082629036Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INBOARD AND OUTBOARD STRINGER ATTACHMENT ANGLES AT BS 767 AND S27L. REPLACED ATTACHMENT ANGLES PER AARD 51-00-05-1.SDR AALA2019082629034Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON STRINGER ATTACHMENT ANGLE AT BS 747 AND S27L. REPLACED ATTACHMENT ANGLE PER AARD 51-00-05-1.SDR AALA2019082629033Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER ATTACHMENT ANGLE AT BS 727J AND S27L. REPLACED ATTACHMENT AGLE PER AARD 51-00-05-1.SDR AALA2019082629032Attach Angle · corrodedAIRCRAFT IN BASE MANINTENANCE: CORROSION ON STRINGER ATTACH ANGLE AT BS 727I AND S27L. REPLACED ATTACH ANGLE PER AARD 51-00-05-1.SDR AALA2019082329093Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500E AND BS 500H AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082329092Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500D AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082329091Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500C AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082329090Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 501 AND BS 520 AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082329089Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 466 AND BS 499 AT S24L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082329088Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD WET AREA FLOOR INTERCOSTAL AT BS 292 AND RBL 12. REPAIRED INTERCOSTAL PER EA 296477.SDR AALA2019082329087Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL SUPPORT ANGLE AT BS 500I BETWEEN RBL 24 AND RBL 26. REPLACED SUPPORT ANGLE PER SRM 53-70-53.SDR AALA2019082329086Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDEWALL SUPPORT ANGLE AT BS 500I BETWEEN LBL 24 AND LBL 27. REPLACED SUPPORT ANGLE PER SRM 51-40-02.SDR AALA2019082329085Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDE PLATE BETWEEN BS 492 AND BS 500A AT S26R. REPLACED SIDE PLATE PER BOEING DRAWING 143A8126.SDR AALA2019082329078Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDE PLATE BETWEEN BS 500G AND BS 500I AT S27R. REPLACED SIDE PLATE PER BOEING DRAWING 143A7501.SDR AALA2019082329077Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SIDE PLATE BETWEEN BS 500E AND BS 500G AT S27R. REPLACED SIDE PLATE PER BOEING DRAWING 143A7501.SDR AALA2019082329076Plate · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON FORWARD CARGO COMPARTMENT SIDE PLATE BETWEEN BS 500C AND BS 500E AT S27R. REPLACED SIDE PLATE PER DRAWING 143A7501.SDR AALA2019082329075Plate · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON FORWARD CARGO COMPARTMENT SIDE PLATE BETWEEN BS 428 AND BS 440 AT S27R. REPLACED SIDE PLATE PER EA 296405.SDR AALA201908239003Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT LAVATORY INBOARD AFT MOUNT AT BS 947 AND LBL 25. REPAIRED MOUNT PER EA 296627.SDR AALA201908239001Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ATTACH ANGLE AT BS 787 AND S27L. REPLACED ATTACH ANGLE PER AARD 51-00-05-1.SDR AALA2019082329095Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA2019082329094Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500C AT S63R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019082329031Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR Z ANGLE AT BS 992.32 AND RBL 45. REPLACED Z ANGLE PER AARD 51-00-05.SDR AALA2019082329030Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR Z ANGLE AT BS 1015 AND RBL 32. REPLACED Z ANGLE PER AARD 51-00-05-1.SDR AALA2019082329026Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT GIRT BAR FITTING AT BS 344 AND LBL 58. REPLACED FITTING PER 51-00-05-1.SDR AALA2019080259023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 500H AND BS 500I AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019080259022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN 500G AND BS 500H AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019080259021Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN 500F AND BS 500G AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019080259020Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN 500E AND BS 500F AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019080259019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN 500D AND BS 500E AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019080259018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN 500C AND BS 500D AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019080259013Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT ANGLE AT BS 500I BETWEEN LBL 24 AND RBL 24. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1.
Back to Boeing 737-823