Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA1149836Keelbeam · corrodedKEEL BEAM LOWER CHORD OUTBOARD FLANGE CORRODED OUT OF LIMITS. REPAIRED CHORD IAW B737 400 SRM 53 30 12 REPAIR 2.SDR ASAA1149835Keelbeam · corrodedKEEL BEAM LOWER CHORD OUTBOARD FLANGE CORRODED OUT OF LIMITS. REPAIRED CHORD IAW B737 400 SRM 53 30 12 REPAIR 2.SDR ASAA1149831Shear Tie · corrodedFORWARD CARGO PIT FRAME BS 500F SHEAR TIE CORRODED ON FORWARD SIDE BETWEEN STR 26R AND 27R. REMOVED CORROSION OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149830Shear Tie · corrodedFORWARD CARGO PIT SHEAR TIE AT BS 500F CORRODED ON FORWARD SIDE BETWEEN STR 28R AND 28L. REMOVED CORROSION OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149829Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE FORWARD SIDE OF BS 500 BETWEEN STR 28L AND 28R HAS CORROSION AROUND FASTENERS. CORROSION FOUND OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR ANGLE IAW B737 400 SRM 53 00 07 REPAIR 10.SDR ASAA1149828Shear Tie · corrodedFORWARD PIT SHEAR TIE CORRODED BS 500E STR 26R 27R. REMOVED CORRODED SECTION FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 53 0 07 FIG 201.SDR ASAA1149826Shear Tie · corrodedFORWARD CARGO PIT FRAME BS 500D SHEAR TIE CORRODED ON FORWARD SIDE BETWEEN STR 26R AND 27R. REPAIRED SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA1149825Shear Tie · corrodedFORWARD CARGO PIT FRAME BS 500D SHEAR TIE CORRODED ON FORWARD SIDE BETWEEN STR 28L AND 28R. INSTALLED NEW SHEAR TIE IAW B737 400 SRM 51 40 02.SDR ASAA1149813Panel · crackedF/O'S WIRING RACEWAY PANEL IS CRACKED AT FORWARD CORNER. REMOVED DAMAGED AREA, FABRICATED REPAIR PART AND INSTALLED IAW B737 400 SRM 51 40 02 AND 51 70 13.SDR ASAA1149815Shear Tie · corrodedFORWARD CARGO PIT FRAME BS 500C SHEAR CLIP CORRODED ON FORWARD SIDE AT STR 28R. REMOVED EXISTING TIE CLIP LOCATED AND INSTALLED NEW STRINGER CLIP IAW B737 400 SRM 51 40 02.SDR ASAA1149814Support Bracket · corrodedFORWARD CARGO BAY LT SIDEWALL SUPPORT BRACKET FORWARD OF BS 500 ABOVE STR 22L HAS CORROSION ON UPPER SURFACE. REMOVED AND REPLACED SUPPORT BRACKET IAW B737 400 SRM 51 40 02.SDR ASAA1149812Web · corrodedIN AFT CARGO PIT CORROSION ON WEB STR 26R TO 25R BS 927. REMOVED AND REPLACED DAMAGED WEB IAW B737 400 SRM 51 40 02.SDR ASAA1149811Threshold · corrodedFORWARD PIT THRESHOLD WEB HAS CORROSION AT FASTENER HOLES. REMOVED AND REPLACED NEW THRESHOLD WEB IAW B737 400 SRM 53 30 15 FIG 1 AND 51 40 02 STEP 5.SDR ASAA1149810Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE ON FORWARD SIDE OF BS 480 BETWEEN STR 28L AND 28R HAS CORROSION AROUND FASTENER CORROSION OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR ANGLE IAW B737 400 SRM 53 00 07 REPAIR 10.SDR ASAA1149809Shear Tie · corrodedFORWARD CARGO PIT FRAME BS500B SHEAR TIE CORRODED ON FORWARD SIDE BETWEEN STR 27R AND 28R BLENDED CORROSION AND FOUND OUT OF LIMITS. REMOVED SHEAR TIE FABRICATED REPLACEMENT AND INSTALLED IAW B737 400 SRM 53 00 07 REPAIR 7.SDR ASAA1149808Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE FORWARD SIDE OF BS 500B BETWEEN STR 28R AND 28L HAS CORROSION AROUND FASTENERS. REMOVED CORRODED SHEAR TIE REPAIR FABRICATED NEW REPAIR AND INSTALLED IAW B737 400 SRM 51 40 02 AND 53 00 07 REPAIR 7.SDR ASAA1149807Shear Tie · corrodedFORWARD CARGO PIT FRAME BS 500C SHEAR TIE CORRODED ON FORWARD SIDE BETWEEN STR 28L AND 28R. REMOVED CORRODED SHEAR TIE, FABRICATED AND INSTALLED REPLACEMENT IAW B737 400 SRM 53 00 07 REPAIR 7.SDR ASAA1149806Shear Tie · corrodedFORWARD CARGO PIT FRAME BS 500B SHEAR TIE CORRODED ON FORWARD SIDE BETWEEN STR 27L AND 28L. REMOVED CORRODED SHEAR TIE REPAIR FABRICATED NEW REPAIR AND INSTALLED IAW B737 400 SRM 53 00 07 REPAIR 7.SDR ASAA1149805Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE FORWARD SIDE OF BS 500A BETWEEN STR 26L AND 26R HAS CORROSION. REMOVED CORROSION WAS OUT OF LIMITS. REMOVED CORRODED SHEAR TIE FABRICATED REPLACEMENT AND INSTALLED IAW B737 400 SRM 53 00 07 REPAIR 7.SDR ASAA1149804Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE AFT SIDE OF BS 500 BETWEEN STR 28R AND 27R CORRODED BLENDED CORROSION AND FOUND OUT OF LIMITS. FABRICATED REPAIR ANGLE AND INSTALLED IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1149803Stringer · crackedFORWARD CARGO PIT RT STR 26R CORRODED FROM BS 500F TO 500G IN CENTER AREA. REMOVED CORROSION AND FOUND OUT OF LIMITS. STOPPED DRILL CRACK AND INSTALLED REPAIR CHANNEL IAW B737 400 SRM 53 00 53 FIG 201.SDR ASAA1149719Support · crackedLT WING NR 1 ENGINE AFT PYLON FLAP TRACK FAIRING INBOARD INTERIOR ANGLE SUPPORT CRACKED. REMOVED AND REPLACED ANGLE IAW B737 400 SRM 51 40 02.SDR ASAA1149722Strip · corrodedAFT PIT RT CAP STRIP NR 3 HAS CORROSION. REMOVED CORROSION FOUND OUT OF LIMITS. FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 30 01 AND BOEING DWG 65 49613.SDR ASAA1149721Strip · corrodedAFT PIT RT CAP STRIP NR 2 HAS CORROSION. REMOVED CORROSION FOUND OUT OF LIMITS. FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 400 SRM 51 30 01 AND BOEING DWG 65 49613.SDR ASAA1149702Seat Track · gougedLT INBOARD SEAT TRACK GOUGED STA 540 727 LBL 24.25. REMOVED DAMAGED TRACK,TREATED PRIMED INSTALLED NEW SEAT TRACK IAW B737 400 SRM 51 40 04.SDR ASAA1149698Seat Track · gougedLT OUTBOARD SLAT TRACK GOUGED SEVERAL AREAS BS 727B TO BS 927. REMOVED SEAT TRACK FABRICATED REPLACEMENT PART AND INSTALLED IAW B73 400 SRM 53 00 52 REPAIR 2.SDR ASAA1149703Strip · corrodedAFT PIT LT NR 3 CAP STRIP CORRODED. REMOVED CORRODED STRIP FABRICATED TREATED PRIMED TOP COATED AND INSTALLED NEW CAP STRIP IAW B737 400 SRM 51 40 05.SDR ASAA1149701Strip · corrodedAFT PIT LT NR 4 CAP STRIP CORRODED. REMOVED CORRODED STRIP FABRICATED TREATED PRIMED TOP COATED AND INSTALLED NEW CAP STRIP IAW B737 400 SRM 51 40 05.SDR ASAA1149700Strip · corrodedAFT PIT LT NR 1 CAP STRIP CORRODED. REMOVED CORRODED STRIP FABRICATED TREATED PRIMED TOP COATED AND INSTALLED NEW CAP STRIP IAW B737 400 SRM 51 40 05.SDR ASAA1149699Strip · corrodedAFT PIT LT NR 2 CAP STRIP CORRODED. REMOVED CORRODED STRIP FABRICATED TREATED PRIMED TOP COATED AND INSTALLED NEW CAP STRIP IAW B737 400 SRM 51 40 05.SDR ASAA1149715Floor Support · corrodedRT OUTBOARD FLOOR SUPPORT ANGLE CORRODED BS 639. REPAIRED SUPPORT ANGLE IAW B737 400 SRM 51 70 12.SDR ASAA1149714Floor Support · corrodedLT OUTBOARD FLOOR SUPPORT ANGLE CORRODED BS 639. REPAIRED SUPPORT ANGLE IAW B737 400 SRM 51 70 12.SDR ASAA1149712Floor Support · corrodedLT OUTBOARD FLOOR SUPPORT ANGLE CORRODED BS 578. REPAIRED SUPPORT ANGLE IAW B737 400 SRM 51 70 12.SDR ASAA1149656Seat Track · gougedLT INBOARD SEAT TRACK GOUGED AND CHAFED BETWEEN BS 460 AND BS 520. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52.SDR FOTR2106709222Seat Track · damagedSEAT TRACK DAMAGED AT STA 684, RBL 24. REPAIRED ON FASI W/O 21067, NR 09222.SDR FOTR2106709174Seat Track · damagedSEAT TRACK DAMAGED AT STA 710, LBL 45. REPAIRED ON FASI W/O 21067, NR 09174.SDR FOTR2106709180Seat Track · damagedSEAT TRACK DAMAGED STA 727C- 907, LBL45SDR FOTR2106709083Seat Track · damagedSEAT TRACK DAMAGED AT BS 460, RBL 24. REPAIRED ON FASI W/O 21067, NR 09083.SDR FOTR2106709176Seat Track · damagedSEAT TRACK DAMAGED AT STA 727B-907, RBL 45. REPAIRED ON FASI W/O 21067, NR 09176.SDR FOTR2106709181Seat Track · damagedSEAT TRACK DAMAGED AT STA 787-907 LBL 24. REPAIRED ON FASI W/O 21067 NR 09181.SDR FOTR2106709189Seat Track · damagedSEAT TRACK DAMAGED AT BS 520-695 LBL.45. REPAIRED ON FASI W/O 21067, NR 09189.SDR FOTR2106709191Seat Track · damagedSEAT TRACK DAMAGED AT STA 500C-660 LBL 24. REPAIRED ON FASI W/O 21067 NR 09191.SDR FOTR2106709193Seat Track · damagedSEAT TRACK DAMAGED BS 520-695 RBL 24. REPAIRED ON FASI W/0 21067, NR 09193.SDR FOTR2106709285Skin · dentedDENTED HORIZONTAL STAB STA 129.5. REPAIRED ON FASI W/O 21067, NR 09285.SDR FOTR2106709347Seat Track · damagedSEAT TRACK DAMAGED AT STA 727-727A, LBL 45. REPAIRED ON FASI W/O 21067, NR 09347.SDR FOTR2106708543Frame · corrodedCORROSION AT STA 747 AND STR 28R. REPAIRED ON FASI W/O 21067.SDR FOTR2106709194Seat Track · damagedSEAT TRACK RBL 45 BS 485-500G IS DAMAGED. REPAIRED ON FASI W/O 21067, NR 09194.SDR FOTR2106709190Seat Track · damagedSEAT TRACK AT LBL 24 FROM BS 375-500C IS DAMAGED. REPAIRED ON FASI W/O 21067, NR 09190.SDR FOTR2106708995Frame · crackedRT FUSELAGE FRAME AT BS 601 IS CRACKED AT LOWER FASTENER HOLE BELOW STR 17R. REPAIRED ON FASI W/O 21067, NR 08995.SDR BJNA110502Lamp · burned outEMERGENCY EXIT FLOOR LIGHT INOPERATIVE AT SEAT 19C. RELAMPED EXIT PATH LIGHT AT SEAT 19C, OPS CHECK GOOD.
Back to Boeing 737-4Q8