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 ASAA1048332Stringer Clip · crackedSTR 4R CLIP CRACKED AT STA 867. REMOVED AND REPLACED WITH NEW CLIP.SDR ASAA1048354Spoiler · dentedLEFT WING T/E AND NR 1 SPOILER UPPER T/E DENTED I/B OF O/B END. REPAIRED DAMAGE.SDR ASAA1048427Skin · corrodedFOUND CORROSION ON INTERNAL AND EXTERNAL SKIN. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048435Shear Tie · corrodedSHEAR TIE AT STA 867 HAS CORROSION. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048394Frame · crackedFRAME CRACKED AT STA 787. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048393Frame · crackedFRAME CRACKED AT STA 747. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048388Frame · crackedFRAME CRACKED AT STA 380. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048386Frame · crackedFRAME CRACKED AT STA 440. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048352Seat Track · damagedRIGHT O/B SEAT TRACK HAS LUG DAMAGED. REMOVED AND INSTALLED NEW.SDR ASAA1048334Stringer Clip · crackedSTR 5R CLIP CRACKED AT STA 727D. REMOVED AND REPLACED CLIP.SDR ASAA1048333Stringer · corrodedAPU LOWER TORQUE BOX INLET CUTOUT LOWER INBOARD FLANGE CORRODED. REMOVED DAMAGED LOWER STRINGER AND INSTALLED NEW.SDR ASAA1048434Shear Tie · corrodedSHEAR TIE AT STA 827 HAS CORROSION. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048351Seat Track · gougedRIGHT I/B SEAT TRACK HAS GOUGES. REMOVED AND INSTALLED NEW.SDR ASAA1048350Seat Track · damagedRIGHT O/B SEAT TRACK HAS MISSING LOBE. REMOVED AND INSTALLED NEW.SDR ASAA1048336Stringer Clip · crackedSTRINGER CLIP STA 639 STR 2R IS CRACKED. REMOVED CRACKED CLIP AND INSTALLED NEW STRINGER CLIP.SDR ASAA1048335Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 500F AND STRINGER 25L. REMOVED CRACKED CLIP AND INSTALLED NEW STRINGER CLIP.SDR ASAA1048396Frame · crackedFRAME CRACKED AT STA 907. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048395Frame · crackedFRAME CRACKED AT STA 867. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048392Frame · crackedFRAME CRACKED AT STA 727F. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048391Frame · crackedFRAME CRACKED AT STA 747R. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048390Frame · crackedFRAME CRACKED AT STA 787R. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048389Frame · crackedFRAME CRACKED AT STA 827. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048387Frame · crackedFRAME CRACKED AT STA 400. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048385Frame · crackedFRAME CRACKED AT STA 440. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048384Frame · crackedFRAME CRACKED AT STA 500F. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048369Seat Track · gougedRIGHT O/B SEAT TRACK HAS SEVERAL GOUGES. REMOVED AND REPLACED WITH NEW.SDR ASAA1048349Seat Track · gougedLEFT O/B SEAT TRACK HAS SEVERAL GOUGES. REMOVED AND INSTALLED NEW.SDR ASAA1048348Seat Track · gougedLEFT I/B SEAT TRACK HAS SEVERAL GOUGES. REMOVED AND INSTALLED NEW.SDR ASAA1048324Floorbeam · corrodedSTA 947.5 FLOORBEAM HAS CORROSION AROUND FASTENER HOLES AT RBL 6. REPAIRED AFT FLANGE OF FLOORBEAM.SDR ASAA1048449Rib · crackedRT WING RIB LOWER CHORD AT WING STA 135 IS CRACKED. REPAIRED RIB.SDR ASAA1048382Attach Fitting · crackedFWD SIDE INTERCOSTAL ATTACH CLIP FROM FRAME TO INTERCOSTAL AT STR 11L IS CRACKED. REMOVED AND INSTALLED NEW.SDR ASAA1048361Floorbeam · corrodedFLOOR FRAME STA 380 CORRODED ON TOPSIDE. REMOVED DAMGE AND INSTALLLED REPAIR PARTS.SDR ASAA1048450Frame · corrodedSTA 1006 22R FRAME HAS CORROSION AT STRINGERS ATTACHMENT. REPAIRED FRAME.SDR ASAA1048447Bulkhead · corrodedCORROSION ON APB INNER SKIN. REPAIRED APB WEB.SDR ASAA1048444Frame · corrodedCORROSION ON APB LT AND RT FRAME CHANNEL AT BL 0. REPAIRED CHANNELS.SDR ASAA1048442Channel · corrodedAFT LAV DRAIN MAST DOUBLER CHANNEL CORRODED AT FS 998. REMOVED AND REPLACED AFT LAV DRAIN MAST.SDR ASAA1048439Frame · corrodedSTA 967 CORRODED AT STR 25R TO 23L. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048429Fitting · corrodedAFT CARGO BAY STA 986 FRAME CLIP CORRODED ON AFT SIDE OF FRAME. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048428Frame · corrodedSTA 1006 STR 22L FRAME HAS CORROSION. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048425Frame · dentedFWD CARGO COMPARTMENT FRAME AT STA 500D HAS DENT ABOVE STR 24L. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048424Floorbeam · corrodedLT AND RT REPAIR SECTIONS ON T-CAP ARE CORRODED STA 986. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR ASAA1048418Stringer · corrodedAFT CARGO EQUIPMENT BAY STA 968 STR 25L CORRODED FWD END. REMOVED CORROSION AND INSTALLED REPAIR.SDR ASAA1048417Cusp Web · corrodedRT CUSP WEB AT STA 847 - 867 CORRODED. REMOVED CORROSION AND INSTALLED REPAIR.SDR ASAA1048414Web · corrodedFLOOR WEB AT STR 17L CORRODED AT STA 807. REMOVED DAMAGED AREA AND INSTALLED NEW PART.SDR ASAA1048413Stringer · corrodedSTR 27 AT STA 847 CORRODED. REMOVED DAMAGED AREA AND INSTALLED REPAIR.SDR ASAA1048402Sill · corrodedR2 LOWER SILL INNER CHORD CORRODED. REPLACED LOWER SILL INNER CHORD.SDR ASAA1048383Stringer Clip · crackedAFTER ROMOVAL OF FRAME FOUND STRINGER CLIP AT STA 847 STR 27R CRACKED. REMOVED AND INSTALLED NEW.SDR ASAA1048368Angle · corrodedREINFORCEMENT ANGLE AT 747 FRAME AND STR 27L IS CORRODED. REMOVED AND REPLACED ANGLE.SDR ASAA1048401Crease Beam · corrodedMAIN CABIN FLOOR AT L2 DOOR CREASE BEAM AND ANGLE IS CORRODED. REPLACED CREASE BEAM AND ANGLE.SDR ASAA1048446Frame · corrodedFRAME REPAIR AT FS 747 CORRODED. REPAIRED FRAME.
Back to Boeing 737-4Q8