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 ASAA0842938Skin · damagedNR 4 SPOILER HAS BUMPS FROM SEAL SCREWS. REPAIRED SKIN DAMAGE ON OUTBOARD END OD NR 4 SPOILER IAW B737 400 SRM 51-70-10 REPAIR 4.SDR ASAA0843078Skin · dentedDENT ON LT LOWER FUSEALGE AT BS 500 TO 500A STR 25 TO 26. REPAIR WORK ACCOMPLISHED IAW B737 400 SRM 53 00 01.SDR ASAA0843098Skin · dentedLT LOWER FUSELAGE EXTERIOR DENTED AT STA 500E TO 500F STR 26 TO 27. REPAIRED DENT IAW B737 400 SRM TR53 27 REPAIR 31 FIG 201.SDR ASAA0843104Skin · dentedDENTS AT BS 480 500 STR 25L 26L. REPAIRED WITH REPAIR PART.SDR ASAA0843165Stringer · corrodedAPU COMPARTMENT TORQUE BOX STRINGER CORRODED. REPLACED STRINGER PER SRM 51 40 02.SDR ASAA0843105Intercostal · crackedCRACKED INTERCOSTAL COMMON TO UPPER SILL BEAM STRAP STA 303 STR4L. REPAIRED WITH REPAIR PART.SDR ASAA0843135Floorbeam · corrodedFLOORBEAM UPPER FLANGE IS CORRODED. REPLACED BEAM PER EA 5310 02800.SDR ASAA0843146Tie Clip · crackedE&E COMPARTMENT BS 380 STR 22L TIE CLIP CRACKED. E&E COMPARTMENT BS 380 STR 22L TIE CLIP REPLACED IAW B737 400 SRM 51 40 02.SDR ASAA0843081Support Channel · crackedL1 DOOR SILL INNER SUPPORT CORRODED ON SURFACE AND CRACKED. INSTALLED NEW CHANNEL IAW B737 400 SRM 51 40 02.SDR ASAA0843167Frame · crackedRIGHT FRAME AT STA 380 CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STA 380 PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 AND ASA EA 5310 02797.SDR ASAA0843166Frame · crackedLEFT FRAME AT STA 827 CRACKED AT PSU RAIL BRACKET. LEFT FRAME AT STA 827 AT PSU BRACKET REPAIRED IAW CASCADE ERO 8337 & ASA EA 5310 02797.SDR ASAA0843163Frame · crackedLEFT SIDE FRAME AT STA 747 CRACKED AT PSU RAIL BRACKET. LEFT SIDE FRAME AT STA 747 AT PSU RAIL BRACKET REPAIRED IAW ERO 8337 & ASA EA 5310 02797 REF CERT 11678.SDR ASAA0843157Frame · crackedFRAME CRACKED. REPAIRED FRAME PER EA 5310 02797.SDR ASAA0843156Frame · crackedFRAME CRACKED AT PSU RAIL BRACKET. REPAIRED FRAME PER EA 5310 02797.SDR ASAA0843139Frame · corrodedAFT CARGO PIT BS 767 BETWEEN 25R AND 26R LOWER FLANGE OF FRAME (AFT SIDE) HAS CORROSION. AFT CARGO PIT B767 BETWEEN STRINGER 25R 26R LOWER FLANGE REPAIRED IAW B737 400 SRM 51 70 11. REPAIRED WITH REPAIR PART.SDR ASAA0843134Frame · crackedRIGHT FRAME AT STA 867 CRACKED AT PSU RAIL BRACKET. REPAIRED PER EA 5310 02797.SDR ASAA0843131Frame · crackedRIGHT FRAME AT STA 787 CRACKED AT PSU RAIL BRACKET. REPAIRED PER EA 5310 02797.SDR ASAA0843130Frame · crackedRIGHT FRAME AT STA 747 AT PSU RAIL BRACKET CRACKED. REPAIRED PER EA 5310 02797.SDR ASAA0843128Frame · crackedRIGHT FRAME AT STA 727B CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STA 727B AT PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 ASA EA 5310 02797.SDR ASAA0843127Frame · crackedRIGHT FRAME AT STATION 500A CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STATION 500A AT PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 AND ASA EA 5310 02797.SDR ASAA0843126Frame · crackedRIGHT FRAME AT STATION 480 CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STATION 480 AT PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 ASA EA 5310 02797.SDR ASAA0843124Frame · crackedRIGHT FRAME AT STA 440 CRACKED AT PSU RAIL BRACKET. REPAIRED PER EA 5310 02797.SDR ASAA0843123Frame · crackedLEFT FRAME AT STA 867 CRACKED AT PSU RAIL BRACKET REPAIR PER EA 5310 02797.SDR ASAA0843119Frame · crackedRIGHT FRAME AT PSU RAIL BRACKET CRACKED REPAIR PER EA 5310 02747.SDR ASAA0843088Frame · crackedLT SIDE FRAME AT STA 727D CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843087Frame · crackedLT SIDE FRAME AT STA 500A CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843084Frame · crackedLT SIDE FRAME AT STA 440 CRACKED AT PSU RAIL BRACKET. REPAIRED FRAME IAW ASA EA5310 02797.SDR ASAA0843083Frame · crackedLT FRAME AT STA 360 CRACKED AT PSU RAIL BRACKET. REPAIRED IAW EA5310 02797.SDR ASAA0843074Frame · crackedRT FRAME AT STA827 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843097Cargo Track · brokenFWD CARGO PIT TIE DOWN TRACK TIE DOWN POINT BROKEN OUT. TIE DOWN POINT REPAIRED IAW SRM 53 00 53 REPAIR 2 FIG 201.SDR ASAA0843095Frame · crackedRT FRAME AT STA 907 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843094Frame · crackedLT FRAME AT STA 907 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843093Frame · crackedLT FRAME AT STA 787 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843092Frame · crackedLT SIDE FRAME AT STA 727F CRACK AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843152Bear Strap · corrodedBEAR STRAP CORRODED IN AFT CARGO BAY AREA. REPAIR STRAP PER EA 5330 02357.SDR ASAA0843162Sill · corrodedFORWARD CARGO BAY DOOR SILL PLATE CORRODED. REPLACED SILL PLATE PER SRM 51 40 05.SDR ASAA0843161Frame · dentedAFT CARGO PIT BS 727E BETWEEN STRINGER 22L & 23L TOP FLANGE OF FRAME DENTED. AFT CARGO PIT FRAME REPAIRED AT BS 727E STRINGER 22L TO 23L IAW B737 400 SRM 51 70 11 FIG 1.SDR ASAA0843159Bear Strap · corrodedAFT PIT BILGE STA 787 TO STA 793 RBL 23R BEAR STRAP HAS TWO AREAS OF CORROSION. REFER TO NIR 5097068 FOR REPAIR OF BEAR STRAP BS 787 TO BS 793 RBL 23.SDR ASAA0843151Attach Angle · corrodedFRAME TO SKIN ATTACH ANGLE CORRODED IN AFT BILGE AREA. REPAIRED PER SRM 53 00 07.SDR ASAA0843150Frame · dentedAFT CARGO PIT BS 727C BW STR 24R 25R TOP FLANGE OF FRAME DENTED. AFT CARGO PIT FRAME BS 727C STR 24R 25R REPAIRED IAW B737 400 SRM 51 70 11.SDR ASAA0843149Frame · dentedAFT CARGO PIT BS 727E AT STR 24R FRAME DENTED ON TOP FLANGE. AFT CARGO PIT BS 727E AT STR 24R FRAME REPAIRED IAW B737 400 SRM 51 70 11.SDR ASAA0843147Frame · dentedAFT CARGO PIT BS 727C AT STR 25L TOP FLANGE OF FRAME DENTED. REPAIRED WITH REPAIR PART IAW B737 400 SRM.SDR ASAA0843145Tie Clip · corrodedTIE CLIP AT STA 787 RBL 15 HAS CORROSION. REPLACED TIE CLIP WITH REPAIR PART.SDR ASAA0843144Stringer Clip · crackedSTRINGER TIE CLIP CRACKED IN FORWARD CARGO BAY AREA. REPLACED CLIP PER SRM 51 40 02.SDR ASAA0843121Floorbeam · corrodedFLOORBEAM UPPER FLANGE IS CORRODED. REPAIRED PER EA 5310 02800.SDR ASAA0843114Intercostal · crackedFORWARD CARGO BAY INTERCOSTAL ANGLE CRACKED. REPLACED INTERCOSTAL PER SRM 53 30 04 51 40 05 AND 51 40 02.SDR ASAA0843113Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED. REPLACED BEAM PER EA 5310 02800.SDR ASAA0843133Sill · corrodedAFT CARGO PIT DOOR SILL PLATE STA 783 TO 847 CORROSION AROUND FASTENER HOLES TOP AND BOTTOM OF PLATE CORROSION ON AFT CARGO DOOR SILL PLATE AT BS 793 TO BS 847 WAS BLENDED OUT AND FOUND TO BE BEYOND ALLOWABLE LIMITS IAW 737 400 SRM 51 40 05 AND 51 40 02. REPASDR ASAA0843082Frame · crackedLT FRAME AT STA 400 CRACKED AT PSU RAIL BRACKET. REPAIRED IAW ASA EA5310 02797.SDR ASAA0843132Frame · corrodedAFT CARGO COMPARTMENT FRAME AT BS 727G IS CORRODED BETWEEN STRINGER 25R AND 26R. REPAIRED WITH REPAIR PART IAW B737 400 SRM.
Back to Boeing 737-4Q8