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 ASAA0640494Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION FOUND OUT OF LIMITS. REPAIRED SHEAR TIE PER SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA0640493Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION FOUND OUT OF LIMITS. REPAIRED SHEAR TIE PER SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA0640492Frame · corrodedFOUND FRAME SHEAR TIE CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640491Floorbeam · corrodedFOUND FLOORBEAM CORRODED. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 51SDR ASAA0640490Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED FLOORBEAM UPPER CHORD PER SRM 53 10 51 REPAIR 5.SDR ASAA0640489Shear Tie · corrodedFOUND CORROSION ON AFT SIDE OF SHEAR TIE REPAIR DOUBLER. REMOVED AND REPAIRED PER SRM 53 00 07.SDR ASAA0640471Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED DAMAGED SECTION OF SHEAR TIE FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 07.SDR ASAA0640470Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REMOVED DAMAGED SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640466Angle · crackedFOUND L ANGLE CRACKED 9" FWD OF FWD GALLEY DOOR NR 4 (FROM TOP) STOP PAD FITTING. REMOVED FABRICATED AND REPLACED ANGLE.SDR ASAA0640463Angle · crackedL ANGLE CRACKED FWD OF FWD GALLEY DOOR NR 3 (FROM TOP) STOP PAD FITTING. REMOVED FABRICATED AND REPLACED ANGLE.SDR ASAA0640462Shear Tie · damagedFOUND SHEAR TIE HAS OBLONG HOLE. REMOVED AND REPLACED SHEAR TIE PER SRM 51 40 02.SDR ASAA0640461Shear Tie · corrodedFOUND CORROSION ON FRAME SHEAR TIE. REMOVED CORROSION FOUND OUT OF LIMITS REMOVED DAMAGE FABRICATED AND INSTALLED REPAIR PER SRM 53 00 07 FIG 201.SDR ASAA0640460Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS REMOVED FABRICATED AND INSTALLED FRAME REPAIR PER SRM 53 00 07 FIG 201.SDR ASAA0640459Stringer · damagedFOUND STRINGER DAMAGED. REMOVED AND REPLACED STRINGER WITH NEW ITEM PER SRM 53 00 03 REPAIR 1.SDR ASAA0640458Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS REPAIRED FABRICATED AND INSTALLED FRAME PER SRM 53 00 07 FIG 201.SDR ASAA0640457Shear Tie · corrodedFOUND CORROSION ON FRAME SHEAR TIE. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07 REPAIR 3.SDR ASAA0640464Skin · debondedFOUND LT WING SLAT O/B EDGE LWR SKIN DISBONDED. ACCOMPLISHED HOT BOND REPAIR PER SRM 51 70 10.SDR ASAA0640454Stringer · damagedFOUND STRINGER DAMAGED. REPAIRED PER SRM 53 00 03 FIG 201 REPAIR 1.SDR ASAA0640453Shear Tie · damagedFOUND SHEAR TIE DAMAGED. REMOVED AND REPAIRED PER SRM 53 00 07 REPAIR 1.SDR ASAA0640452Shear Tie · damagedFOUND SHEAR TIE DAMAGED. REMOVED AND REPAIRED PER SRM 53 00 07 REPAIR 1.SDR ASAA0640451Shear Tie · damagedFOUND SHEAR TIE DAMAGED. REMOVED AND REPAIRED PER SRM 53 00 07 REPAIR 1.SDR ASAA0640447Door Frame · corrodedAFT CARGO DOOR CUTOUT FWD FRAME HAS CORROSION JUST O/B OF CARGO LIGHT SWITCH AND IN 2 O/B THRESHOLD FASTENER HOLES. REMOVED CORROSION AND REPAIRED FRAME SEGMENT PER SRM 51 40 02 FIG 8.SDR ASAA0640415Frame · corrodedFOUND CORROSION ON FRAME SHEAR TIE BETWEEN KEEL BEAM AND STRINGER 26R. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 07 AND 51 40 02.SDR ASAA0640411Skin · ground damageFOUND L1 UPPER FWD HINGE CUTOUT HAS TORN SKIN FROM JETWAY DAMAGE. INSTALLED REPAIR DOUBLER PER SRM 52 00 01 REPAIR 2.SDR ASAA0640414Frame · corrodedFOUND CORROSION ON FRAME. REPLACED FRAME PER SRM 51 40 02.SDR ASAA0640390Frame · damagedAFT CARGO BAY OBLONG HOLE IN FRAME. REMOVED DAMAGE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51 70 11.SDR ASAA0640389Door Frame · corrodedAFT CARGO DOOR CUTOUT FRAME HAS CORROSION ON UPPER FLANGE AND VERICAL FLANGE FWD SIDE. CUT OUT DAMAGED ON FLANGE AND REPAIRED PER SRM 51 70 11 REMOVED CORROSION FROM REFIT SIDE OF FRAME 6IN BY 3IN BY .006. IN LIMITS PER SRM 51 20 01 AND 53 00 07.SDR ASAA0640384Slide · dischargedFOUND L1 DOOR SLIDE PRESSURE NOT IN THE "GREEN". REMOVED AND REPLACED THE L1 SLIDE PER AMM 25 61 35 PG 201 218.SDR ASAA0640377Frame · damagedAFT CARGO BAY OBLONG HOLE IN FRAME. REMOVED DAMAGED SECTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51 70 11.SDR ASAA0640376Shear Tie · corrodedAFT CARGO BAY CORROSION FOUND ON FRAME SHEAR TIE. REMOVED DAMAGED SECTION OF SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640373Frame · corrodedAFT CARGO COMPARTMENT CORROSION ON BACK SIDE OF FRAME. REMOVED CORROSION ON FRAME FOUND TO BE OUT OF LIMITS REPLACED FRAME PER SRM 53 00 07.SDR ASAA0640324Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED FRAME IAW SRM 53 00 07.SDR ASAA0640323Shear Tie · corrodedAFT CARGO COMPARTMENT CORROSION ON SHEAR TIE. REMOVED DAMAGE FABRICATED AND INSTALLED NEW SHEAR TIE PR SRM 53 00 07.SDR ASAA0640357Slide · no testDURING R 1 ESCAPE SLIDE TEST PER ASA TASKCARD 48125002 SLIDE DEPLOYED AUTOMATICALLY INTEGRAL LIGHT ILLUMINATED SLIDE INFLATED AND REMAINED EXCEPT SLIDE DEPLOYED SIDEWAYS (LEFT SIDE UP) INSTALLED NEW SLIDE.SDR ASAA0640446Shear Tie · corrodedFOUND AFT CARGO BAY CORROSION ON FRAME SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640315Skin · chafedNR 1 SLAT LOWER TRAILING EDGE SKIN CHAFED. REPAIRED NR 1 SLAT IAW SRM 57 43. 01.SDR ASAA0640317Shear Tie · corrodedFOUND FRAME CORRODED ON FWD SIDE. REMOVED CORRODED SHEAR TIE FABRICATED AND INSTALLED SHEAR TIE PER SRM 53 00 17 PG 201.SDR ASAA0640316Shear Tie · corrodedFOUND FRAME CORRODED ON FWD SIDE. REMOVED SHEAR TIE FABRICATED AND INSTALLED SHEAR TIE PER SRM 53 00 07 PG 201.SDR ASAA0640312Shear Tie · corrodedFOUND AFT CARGO BAY CORROSION ON FRAME SHEAR TIE. REMOVED DAMAGED PARTS OF FRAME FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 07.SDR ASAA0640311Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED. REMOVED DAMAGED PORTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0640313Shear Tie · damagedAFT CARGO COMPARTMENT ON SHEAR TIE. REMOVED DAMAGED SECTION OF SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 7.SDR ASAA0640307Frame · corrodedFOUND CORROSION ON FRAME. REMOVED CORRDED AREA OF FRAME SHEARTIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0540196Skin · delaminatedRT NR 5 SLAT OB T/E IS DELAMINATED. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER IAW SRM. (K)SDR ASAA0640270Skin · dentedSKIN DENTED. FABRICATED AND INSTALLED REPAIR PARTS PER EA 5330 02061 AND ER 06 1486.SDR ASAA0640271Wire · shortedMOMENTARY APU FIRE INDICATION WITH APU NOT RUNNING DURING CRUSE FLIGHT. FOUND WIRE TO APU TAIL PIPE OVERHEAT DETECTOR RUBBING AND SHORTING TO APU COWLING. TEMPORARY REPAIR DONE TO WIRE AND REPOSITIONED PER SWPM 20 10 13 PG 122.SDR ASAA0640265Skin · dentedFUSELAGE SKIN DENT. REPAIRED PER EA 5330 02064 AND EO 06 1319.SDR ASAA0640260Door Frame · crackedL1 DOOR FRAME CRACKED AT LOWER STOP FITTING FWD SIDE. REPAIRED PER EA 5310 02594.SDR ASAA0640254Skin · chafedCHAFE MARKS ON SKIN. INSTALLED REPAIR PER ASA EA 5360 01055.SDR ASAA0640255Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED CORRODED AREA AND INSTALLED REPAIR PER EA 5310 02591.SDR ASAA0640256Cam · gougedL1 DOOR HARD TO CLOSE AND GOUGE ON FWD LWR TORQUE TUBE ROLLER FITTING. REMOVED AND REPLACED 1 DOOR PER AMM 52-11-00 AND ACCOMPLISHED TEST PER AMM 52-11-00 PG 517 AND 518.
Back to Boeing 737-4Q8