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 ASAA0944519Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED UPPER CHORD AND INSTALLED REPAIR CHORD SECTION AND SPLICES.SDR ASAA0944518Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED TOP CHORD OF FLOORBEAM, FABRICATED REPAIR PARTS AND NEW TOP CHORD AND INSTALLED PER SRM 53-10-51.SDR ASAA0944517Floorbeam · corrodedBS 986 FLOORBEAM UPPER CAP CORRODED. REPAIRED FLOORBEAM PER ER 09-1817-EA-400-53EA-00969.SDR ASAA0944514Web · corrodedWEB CORRODED BS 986-1016. REPLACED WEB.SDR ASAA0944508Crease Beam · corrodedL1 DOOR MOP SILL CREASE BEAM CORRODED. REMOVED AND REPLACED MOP SILL.SDR ASAA0944507Support · corrodedAFT CARGO BAY CORROSION ON FLOOR TO SIDEWALL SUPPORT. REMOVED, FABRICATED NEW AND INSTALLED.SDR ASAA0944506Support · puncturedFWD CARGO BAY FLOOR TO SIDEWALL SUPPORT PUNCTURED. FLOOR TO SIDEWALL SUPPORT PLATE REMOVED AND REPLACED STA 500A-500G.SDR ASAA0944505Support Angle · corrodedFWD CARGO BAY SIDEWALL SUPPORT ANGLE HAS CORROSION. REMOVED SUPPORT, FABRICATED NEW SUPPORT AND INSTALLED.SDR ASAA0944504Support · corrodedFWD CARGO BAY SIDEWALL SUPPORT HAS CORROSION. FABRICATED NEW SUPPORT AND INSTALLED PER SRM 51-40-02.SDR ASAA0944503Support · corrodedFWD CARGO BAY SIDEWALL SUPPORT HAS CORROSION. REMOVED SUPPORT, FABRICATED NEW SUPPORT AND INSTALLED PER SRM 51-40-02.SDR ASAA0944783Skin · crackedFUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REMOVED DAMAGE, FABRICATED DOUBLER FILLER AND TRIPLER. INSTALLED REPAIR PARTS IAW ASA EA 400 53EA 00843.SDR ASAA0944657Doubler · crackedR1 DOOR AFT LOWER CORNER INNER DOUBLER CRACKED. REMOVED DOUBLER, FABRICATED AND INSTALLED NEW DOUBLER IAW B737 400 SRM 51 40 02.SDR ASAA0944568Intercostal · corrodedINTERCOSTAL AT STA 794 HAS CORROSION. REMOVED AND REPLACED CORRODED INTERCOSTAL IAW B737 400 SRM 51 40 02 INTERCOSTAL REPLACED WITH NEW PART.SDR ASAA0944872Frame · corrodedFRAME UPPER SURFACE STA 727C STR 25L CORRODED. REMOVED DAMAGED AREA, FABRICATED TREATED AND INSTALLED FRAME REPAIR IAW B737 400 SRM 51 70 11.SDR ASAA0944834Frame · corrodedFRAME UPPER SURFACE STA 727C STR 25L CORRODED. REMOVED DAMAGED AREA, FABRICATED, TREATED AND INSTALLED FRAME REPAIR IAW B737 400 SRM 51 70 11.SDR ASAA0944791Frame · corrodedAFT PIT FRAME SURFACE STA 727E CORRODED. REMOVED DAMAGED AREA, FABRICATED, TREATED AND INSTALLED REPAIR ANGLE IAW B737 400 SRM 51 70 11.SDR ASAA0944714Skin · dentedLEFT O/B FOREFLAP JUST OUTBOARD OF I/B END HAS 3 DENTS. REPAIRED, BONDED LT O/B FOREFLAP IAW B737 400 SRM 51 70 10.SDR ASAA0944715Frame · corrodedAFT PIT FRAME STA 807 STRINGER 25L CORRODED. REMOVED DAMAGED AREA, INSTALLED NEW REPAIR ANGLE FILLER AND SHIM IAW B737 400 SRM 51 70 10.SDR ASAA0944682Skin · dentedLEFT I/B FORE FLAP HAS 2 DENTS AT I/B END LOWER SIDE. PREPPED DAMAGE AREA, FABRICATED REPAIR DOUBLER AND BONDED DOUBLER IAW B737 400 SRM 51 70 10.SDR ASAA0944663Doubler · chafedLEFT O/B MID FLAP CHAFED ABOVE I/B AFT FLAP TRACK. REMOVED CHAFED DOUBLER, FABRICATED AND BONDED REPAIR DOUBLER IAW B737 400 SRM 57 53 01.SDR ASAA0944738Support Angle · corrodedAFT PIT SUPPORT ANGLE STA 794 STR 25R 27R CORRODED. REMOVED CORRODED ANGLE, FABRICATED AND INSTALLED NEW SUPPORT ANGLE IAW B737 400 SRM 51 30 01.SDR ASAA0944661Slat · delaminatedRIGHT NR 5 SLAT OUTBOARD T/E DELAMINATED. REMOVED DAMAGED AREA, FABRICATED AND BONDED REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944717Hinge Fitting · damagedL1 DOOR LWR HINGE CUTOUT BEARING PLATE FITTING TO HAVE ELONGATED HOLE. REMOVED EXISTING HINGE FITTING AND INSTALLED NEW LOWER L1 DOOR HINGE FITTING IAW B737 400 SRM 51 40 02.SDR ASAA0944492Flap Track · corrodedRUST ON NR 8 FLAP TRACK BEARING CONTACT SURFACES. REMOVED CORROSION AND TREATED IAW EA 400 57EA 00306.SDR ASAA0944491Flap Track · corrodedRUST ON NR 7 FLAP TRACK BEARING CONTACT SURFACES. REMOVED CORROSION AND TREATED IAW EA 400 57EA 00306.SDR ASAA0944490Flap Track · corrodedRUST ON NR 2 FLAP TRACK BEARING CONTACT SURFACES. REMOVED CORROSION AND TREATED IAW EA 400 57EA 00306.SDR ASAA0944487Flap Track · corrodedRUST ON NR 1 FLAP TRACK BEARING CONTACT SURFACES. REMOVED CORROSION AND TREATED IAW EA 400 57EA 00306.SDR ASAA0944881Stringer Clip · corrodedFWD PIT STR 28R CORRODED STA 500D 520. REMOVED CORRODED STRINGER CLIPS, FABRICATED, TREATED, LOCATED AND INSTALLED NEW CLIPS IAW B737 400 SRM 53 00 03.SDR ASAA0944848Stringer · corrodedFWD PIT STR 28R CORRODED STA 500D 520. REMOVED CORRODED STRINGER CLIPS, FABRICATED, TREATED, LOCATED, INSTALLED NEW CLIPS IAW B737 400 SRM 53 00 03.SDR ASAA0944891Intercostal · damagedINTERCOSTAL WEB HAS TOOLING DAMAGE AT STA 790 845. REMOVED DAMAGED WEB, INSTALLED NEW WEB IAW B737 400 SRM 51 40 02.SDR ASAA0944786Frame · corrodedFWD PIT FRAME STA 500E BETWEEN STR 28L 28R CORRODED. REMOVED CORROSION, FABRICATED, TREATED AND INSTALLED REPAIR SHEAR TIE IAW B737 400 SRM 53 00 07.SDR ASAA0944600Shear Web · corrodedSHEAR WEB STA 967 986 LBL 48 CORRODED. REMOVED CORRODED WEB, FABRICATED LOCATED AND DRILLED AND INSTALLED NEW SHEAR WEB IAW B737 400 SRM 51 40 02.SDR ASAA0944596Frame · corrodedFWD PIT FRAME CORRODED STA 500B BETWEEN STR 26R 27L. REMOVED CORROSION, FABBED, DRILLED AND INSTALLED SHEAR TIE REPAIR AW B737 400 SRM 53 00 07 51 20 01.SDR ASAA0944595Stringer · corrodedPREVIOUS REPAIR AT STRINGER 25R STA 940 CORRODED. REMOVED CORRODED STRINGER, FABBED, TREATED AND INSTALLED REPAIR ANGLE IAW B737 400 SRM 51 40 02 53 00 03.SDR ASAA0944566Shear Web · corrodedSHEAR WEB STA 986 992 LBL 45 CORRODED. REMOVED SHEAR WEB, FABRICATED AND INSTALLED NEW SHEAR WEB IAW B737 400 SRM 51 40 02.SDR ASAA0944488Snubber · defectiveL1 DOOR WILL NOT SHUT PROPERLY. REPLACED L1 DOOR SNUBBER REF ASMM 52 11 71 004 023 52 11 71 404 009. ADJUSTED DOOR GUIDE ARM REF ASMM 52 11 21 404 007 002, OPS CHECK OK.SDR ASAA0944602Shear Web · corrodedSHEAR WEB STA 967 987 CORRODED. REMOVED 2 CORRODED SHEAR WEBS, FABRICATED, DRILLED AND INSTALLED NEW SHEAR WEBS IAW B737 400 SRM 51 40 02.SDR ASAA0944885Skin · dentedNR 3 SLAT LWR SURFACE DENTED 18 INCHES FROM I/B END. REMOVED DAMAGED AREA, FABRICATED, TREATED AND BONDED SKIN AND DOUBLER REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944878Threshold · corrodedFWD PIT THRESHOLD WEB CORRODED STA 468 495. REMOVED CORRODED WEB, FABRICATED, TREATED, PRIMED, TOP COATED AND INSTALLED NEW THRESHOLD WEB IAW B737 400 SRM 51 40 02.SDR ASAA0944851Threshold · corrodedFWD PIT THRESHOLD WEB CORRODED STA 468 495. REMOVED CORRODED WEB, FABRICATED, TREATED, PRIMED, TOPCOATED AND INSTALLED NEW THRESHOLD WEB IAW B737 400 SRM 51 40 02.SDR ASAA0944838Skin · dentedNR 3 SLAT LOWER SURFACE DENTED 18 INCHES FROM I/B END. REMOVED DAMAGED AREA, FABRICATED, TREATED AND BONDED SKIN AND DOUBLER REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944569Skin · delaminatedNR 6 SPOILER TRAILING EDGE DELAM. REMOVED DAMAGED AREA, FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944542Skin · dentedNR 6 SPOILER DENTED AT I/B HINGE. PREPPED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 10 REP 2.SDR ASAA0944541Skin · dentedNR 5 SPOILER HAS DENT ABOVE I/B HINGE ON T/E. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR SKIN AND DOUBLER IAW B737 400 SRM 51 70 10.SDR ASAA0944540Skin · dentedNR 5 SPOILER HAS DENT AT CENTER O/B HINGE AT T/E. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR SKIN AND DOUBLER IAW B737 400 SRM 51 70 10.SDR ASAA0944539Skin · dentedNR 5 SPOILER HAS DENT AROUND O/B HINGE. REMOVED DAMAGED AREA OF SKIN, FABRICATED AND INSTALLED REPAIR SKIN AND DOUBLER IAW B737 400 SRM 51 70 10 REP 4.SDR ASAA0944538Skin · dentedNR 5 SPOILER HAS CLUSTER OF 6 DENTS AROUND O/B HINGE. REMOVED DAMAGED AREA OF SKIN, FABRICATED AND INSTALLED REPAIR SKIN AND DOUBLER IAW B737 400 SRM 51 70 10 REP 4.SDR ASAA0944601Floorbeam · corrodedFLOORBEAM STA 344 LBL 50 CORRODED. REMOVED CORROSION, FABRICATED, DRILLED AND INSTALLED REPAIR STRAP IAW ASA EA 400 53EA 00780.SDR ASAA0944933Frame · crackedFUSELAGE FRAME STA 907L IS CRACKED BETWEEN STRINGER 8L 9L. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944932Frame · crackedFUSELAGE FRAME STA 787L IS CRACKED BETWEEN STRINGER 8L 9L. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.
Back to Boeing 737-4Q8