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 ASAA0640932Stringer Clip · corrodedAFT PIT TIE CLIP CORRODED. REPLACED WITH FABRICATED PART IAW SRM 51-30-01 AND 51-40-02.SDR ASAA0640931Skin · gougedE&E COMPARTMENT DOOR EXTERNAL SKIN GOUGED 5 INCHES AFT OF FWD EDGE RIGHT SIDE. REPAIRED IAW SRM 53-00-01 FIG 201.SDR ASAA0640930Frame · corrodedAFT CARGO PIT HAS CORROSION ON FRAME AT FWD AND AFT SIDES. CORRODED FRAME REPAIRED IAW SRM 53-00-07 FIG 201.SDR ASAA0640929Skin · dentedDENTS IN RIGHT FUSELAGE APPROX 62.5 INCHES AFT OF R1 DOOR AND 6 INCHES BELOW LAP SEAM. REMOVED DAMAGED SECTION OF SKIN AND INSTALLED EXTERNAL DOUBLER PER SRM 53-00-01.SDR ASAA0640880Frame · corrodedFOUND FRAME CORRODED. REPAIRED CORRODED FRAME IAW SRM 53 00 07.SDR ASAA0640879Stringer Clip · corrodedFOUND FRAME TIE CLIP CORRODED. REPLACED TIE CLIP IAW SRM 53 00 03 AND 51 40 02.SDR ASAA0640872Stringer · corrodedFOUND STRINGER 16R CORRODED. REPAIRED CORRODED STRINGER IAW SRM 53 00 03 FIG 201.SDR ASAA0640870Stringer Clip · corrodedFOUND TIE CLIP CORRODED. REPLACED TIE CLIP IAW SRM 51 40 02.SDR ASAA0640869Skin · crackedINSURANCE CLAIM DAMAGED FROM BS 500 TO BS 500A STR 16R TO 18R. DAMAGED SKIN REPAIRED IAW SRM 53 00 01 REPAIR 32.SDR ASAA0640868Bracket · crackedFOUND AFT FRAME TO SKIN ATTACH ANGLE CRACKED. REPAIRED AFT FRAME TO SKIN ATTACH ANGLE IAW SRM 53 00 07.SDR ASAA0640862Stringer · crackedFOUND STRINGER CRACKED. REPAIRED IAW SRM 51 70 13.SDR ASAA0640867Shear Tie · crackedFOUND SHEAR TIE CRACKED. REPLACED SHEAR WEB IAW SRM 51 40 05 AND 51 40 02.SDR ASAA0640866Shear Tie · crackedFRAME TO SKIN ATTACH ANGLE CRACKED. REPLACED FRAME TO SKIN ATTACH ANGLE IAW SRM 53 00 07.SDR ASAA0640865Stringer Clip · crackedFOUND TIE CLIP CRACKED. REPLACED CRACKED TIE CLIP IAW SRM 51 40 02.SDR ASAA0640864Stringer Clip · crackedFOUND TIE CLIP CRACKED. REPLACED TIE CLIP IAW SRM 51 40 02.SDR ASAA0640863Stringer · crackedFOUND STRINGER CRACKED. REPAIRED PER SRM 53 00 03.SDR ASAA0640841Stringer · crackedSTRINGER CRACKED. REPAIRED CRACKED STRINGER IAW SRM 53-00-03.SDR ASAA0640840Bracket · crackedFWD FRAME TO SKIN ATTACH ANGLE CRACKED. FWD FRAME TO SKIN ATTACH ANGLE REPAIRED IAW SRM 53-00-07.SDR ASAA0640839Intercostal · crackedREF AD 2005 20 03 L1 DOOR S7L INTERCOSTAL WEB CRACKED FWD INBOARD IN RADIUS. REPLACED S7L INTERCOSTAL WEB IAW PEMCO EA PD 37 53 552 AND ASA EA 5310 02650.SDR ASAA0640838Intercostal · crackedREF AD 2005 20 03 L1 DOOR S16 INTERCOSTAL WEB CRACKED. REPLACED S16L INTERCOSTAL WEB IAW PEMCO EA PD 37 53 552 AND ASA EA 5310 02650.SDR ASAA0640837Beam · crackedLT HORIZONAL STAB NR 2 BALANCE BAY BEAM SPAN WEB CRACKED APPROX 1 INCH AT STAB STA 165. ACCOMPLISHED INTERIM REPAIR IAW PEMCO EA PD37 55 012 AND ASA EA 5510 01246 PER BOEING MESSAGE NUMBER 1 210047303.SDR ASAA0640836Skin · dentedFUSELAGE SKIN DENTED ATR AFT SIDE OF FWD DOOR CUTOUT. REPAIRED DENT PER EA 5330 02181.SDR ASAA0640835Frame · crackedFRAME CRACKED AT STOP PAD FITTING. REPAIRED FRAME PER EA 5310 02653 AND ER 06 2544.SDR ASAA0640834Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED PER EA 5310 02651.SDR ASAA0640833Door Frame · corrodedAFT CARGO BAY DOORWAY FRAME CORRODED. REMOVED AND REPLACED FRAME PER SRM 51-40-02 AND DWG 65 47959.SDR ASAA0640832Retainer · corrodedCORROSION IN RIGHT AFT OVERWING EXIT LWR SEAL RETAINER. REMOVED AND REPLACED LWR SEAL RETAINER PER SRM 51-40-02.SDR ASAA0640831Skin · crackedLT HORIZ STAB LWR SKIN CRACKED APPROX 1" LONG AT REAR SPAR. ACCOMPLISHED TEMP REPAIR IAW PEMCO EA PD37 55 0111 AND ASA EA 5510 01245 AND PER BOEING MESSAGE 1 209186222 8 DATED 19 JUL 06.SDR ASAA0640830Frame · crackedFOUND CRACKED FRAME WEB. REMOVED AND REPLACED FRAME PER SRM 51 40 02.SDR ASAA0640828Skin · dentedFOUND DENT IN FUSELAGE SKIN. REPAIRED PER EA 533 02125.SDR ASAA0640825Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED IAW SRM 53 10 51.SDR ASAA0640824Floorbeam · corrodedCORROSION ON UPPER FLANGE OF 986.5 FLOORBEAM. REPAIRED IAW EA 5310 02652.SDR ASAA0640823Skin · lightning strikePER EA 5330 1981 PERMINATE REPAIR REQUIRED TO LOCATION STATED ON LOGPAGE 5916421 W I 24 MONTHS OF THIS ENTRY DATE. REPAIRED PER EA 5330 02126.SDR ASAA0640826Skin · lightning strikeLIGHTING STRIKES ON SKIN AT CAPT'S NR 3 WINDOW LWR AFT CORNER. REPAIRED LIGHTING STRIKES ON SKIN AT CAPT'S NR 3 WINDOW CUT OUT LWR AFT CORNER.SDR ASAA0640827Guide Arm · out of adjustON TAKEOFF FLT CREW FOUND THE R 1 DOOR HANDLE (STRIGHT UP) AND WOULD NOT STAY IN THE DOWN POSITION. PRESSURIZATION NOT AFFECTED. SLIDE AND LINING WAS REMOVED. DOOR INSPECTED IAW AMM. NO DISCREPANCIES NOTED. HOWEVER THE GUIDE ARM WAS MISADJUSTED. AFTER RE ADJUSSDR ASAA0640822Frame · damagedELONGATED HOLES IN FRAME FLANGE. CUT OUT AND REMOVED 1.1 X .90 DAMAGED AREA ON FRAME UPPER FLANGE. FABRICATED AND INSTALLED REPAIR IAW SRM 51 70 11.SDR ASAA0640821Doubler · corrodedSKIN DOUBLER CORRODED. REMOVED AND REPLACED IAW SRM 51 40 02.SDR ASAA0640819Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED WITH FABRICATED REPAIR PART PER SRM 51 70 11.SDR ASAA0640818Skin · gougedFOUND RT OB AFT FLAP LE GOUGED. REPAIRED PER SRM 57 43 01 FIG 201.SDR ASAA0640817Frame · corrodedFOUND CORROSION ON FRAME REPAIRED FRAME PER SRM 53 00 07.SDR ASAA0640816Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPLACED FLOORBEAM PER EA 5310 01697.SDR ASAA0640815Frame · corrodedFOUND SKIN TO FRAME ATTACH ANGLE CORRODED AT BS 520 BETWEEN STR 27R AND 28R. ATTACH ANGLE REPLACED IAW SRM 51 30 01 53 00 07 AND 51 40 02.SDR ASAA0640814Frame · corrodedFOUND SKIN TO FRAME ATTACH ANGLE CORRODED AT BSTA 520 BETWEEN STR 27R AND 28R. ATTACH ANGLE REPLACED IAW SRM 51 30 01 5300 07 AND 51 40 02.SDR ASAA0640813Frame · corrodedFOUND FWD CARGO PIT FRAME TO SKIN AT BSTA 500C CORRODED. FRAME TO SKIN ATTACHMENT REPAIRED PER SRM 53 00 07.SDR ASAA0640812Frame · corrodedFOUND FWD CARGO FRAME TO SKIN AT BSTA 500C CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640811Frame · corrodedFOUND FWD CARGO PIT FRAME TO SKIN AT BSTA 500B CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640810Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED WITH FABRICATED PART IAW SRM 51 70 11.SDR ASAA0640809Skin · chafedRT PYLON IB SKIN CHAFED AT LE. REPAIRED PER EA 5430 01150.SDR ASAA0640804Frame · crackedFOUND CRACK IN FRAME STRAP. REMOVED AND REPLACED FRAME STRAP PER SRM 51 40 02.SDR ASAA0640803Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM. REPAIRED PER ER 06 2584 AND EA 5310 02649.SDR ASAA0640802Frame · crackedFOUND CRACK IN FRAME. REPAIRED PER SRM 53 00 07.
Back to Boeing 737-4Q8