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 ASAA1048438Frame · corrodedSTA 500F IB OF 28L CORRODED. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048437Fitting · corrodedSTA 500G FRAME CLIP CORRODED. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048433Shear Tie · corrodedAFT PIT SHEAR TIE AT STA 927 HAS CORROSION. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048432Shear Tie · corrodedAFT PIT SHEAR TIE AT STA 927 HAS CORROSION. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048416Frame · corrodedFRAME AT STA 747 CORRODED ON LOWER LEG. REMOVED CORROSION AND INSTALLED REPAIR.SDR ASAA1048415Shear Tie · corrodedAFT CARGO SHEAR TIE AT STA 767 BETWEEN STR 27L CORRODED. REMOVED CORROSION AND INSTALLED REPAIR.SDR ASAA1048400Shear Tie · corrodedAFT CARGO SHEAR TIE IS CORRODED AT FS 807. REPAIRED SHEAR TIE.SDR ASAA1048353Angle · corrodedAFT CARGO ANGLE AT STRINGER 25R HAS CORROSION. FABRICATED NEW PART AND INSTALLED.SDR ASAA1048341Frame · corrodedFRAME AT STA 727D LOWER LEG CORRODED BETWEEN STR 25L AND 26L. REPAIRED FRAME.SDR ASAA1048340Frame · corrodedFRAME AT STA 727C LOWER LEG CORRODED BETWEEN STR 25L AND 26L. REPAIRED FRAME.SDR ASAA1048443Frame · corrodedFRAME AT STA 847 STR 25R CORRODED. REMOVED AND REPLACED FRAME.SDR ASAA1048440Intercostal · crackedLT WING I/B LEADING EDGE HAS CRACKED INTERCOSTAL ON LOWER SURFACE. REMOVED SUPPORT ANGLE AND INSTALLED REPAIR PARTS.SDR ASAA1048367Sill · corrodedAFT PIT ENTRY SILL WEB CORRODED AROUND LOWER FASTENER HOLES. REPAIRED WITH NEW PART.SDR ASAA1048448Skin · dentedNR 2 SPOILER UPPER SURFACE HAS PROTRUDING DENTS. REPAIRED NR 2 SPOILER.SDR ASAA1048441Bear Strap · corrodedBEAR STRAP CORRODED FS 847. REPAIRED AFT CARGO BEAR STRAP.SDR ASAA1048436Skin · dentedLT FUSELAGE DENTED FS 727E+14 AND 727F+4. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS.SDR ASAA1048255Skin · crackedR2 DOOR LOWER CORNER OF FUSELAGE CRACKED.SDR ASAA1048257Skin · crackedR2 DOOR LOWER CORNER OF FUSELAGE CRACKED. REMOVED CRACK INSTALLED REPAIR.SDR BJNA100802Light · brokenEMERGENCY TRACK LIGHT AT 14 ABC SEAT BROKEN. R & R EMERGENCY TRACK LIGHT AT SEAT 14 ABC IAW AMM 33-51-02.SDR ASAA1048235Bracket · bentRT ELEVATOR TAB MECHANISM I/B ATTACH POINT BRACKET BENT. REMOVED AND REPLACED BRACKET.SDR ASAA1048208Stringer · crackedCRACK IN AFT UPPER END OF STRINGER 23R AT BS 1013. INSTALLED NEW STRINGER.SDR ASAA1048207Stringer · crackedCRACK IN AFT UPPER END OF STRINGER 24R AT BS 1013. INSTALLED NEW STRINGER.SDR ASAA1048210Skin · chafedRT WING O/B MID FLAP HAS A CHAFE JUST O/B OF THE NR 7 FLAP TRACK FAIRING. REMOVED DAMAGED AREA AND BONDED REPAIR.SDR ASAA1048175Skin · damagedLEFT O/B MID FLAP LOWER SURFACE SKIN PANEL INTERNAL DAMAGE TO INNER SKIN. REPAIRED LEFT O/B MID FLAP LOWER SURFACE SKIN PANEL.SDR ASAA1048173Skin · delaminatedRT WING I/B FOREFLAP UPPER SURFACE REPAIR DELAMINATED. REPAIRED THE DAMAGED AREA OF THE I/B FORE FLAP.SDR ASAA1048206Doubler · damagedNR 2 LEADING EDGE SLAT OUTBOARD UPPER SURFACE HAS PREVIOUS REPAIR DENTED AND IS SEPARATING AT O/B END. REMOVED AND REPLACED EXTERNAL DOUBLER.SDR ASAA1048205Skin · dentedLEFT ELEVATOR LOWER SURFACE HAS DENT WITH DELAMINATION. REPAIRED DENT.SDR ASAA1048185Skin · dentedNR 1 SPOILER HAS MULTIPLE DENTS ON LOWER SURFACE. REMOVED DAMAGED AREA AND BONDED REPAIR.SDR ASAA1048174Skin · dentedLT WING O/B FOREFLAP DENTED ABOVE NR 1 FLAP TRANSMISSION. REPAIRED O/B FOREFLAP.SDR ASAA1048172Skin · dentedLEFT WING O/B AFT FLAP LOWER SURFACE HAS MULTIPLE DENTS. REPAIRED DAMAGED AREAS.SDR ASAA1048171Skin · dentedRIGHT WING NR 7 SPOILER DENT AT SLOPE 4 INCHES FROM O/B EDGE. REPAIRED NR 7 SPOILER.SDR ASAA1048170Skin · dentedLT WING I/B FOREFLAP HAS TWO DENTS ON LOWER SURFACE. REPAIRED LT WING INBOARD FORE FLAP.SDR ASAA1048169Skin · dentedRT WING NR 8 SPOILER DENT 5 INCHES PAST INBOARD HINGE POINT. REPAIRED NR 8 SPOILER.SDR ASAA1048209Skin · dentedEXTERNAL FUSELAGE SKIN IS DENTED AND GOUGED AT STA 1013 STR 13L. REMOVED SKIN AND REPLACED WITH NEW SKIN.SDR ASAA1048204Skin · dentedEXTERNAL FUSELAGE SKIN IS DENTED AND GOUGED AT STA 1013 STR 13L. REMOVED DAMAGE AND INSTALLED NEW SKIN.SDR ASAA1048176Skin · dentedSTA 500C + 15 ABOVE STR 26L FASTENER ROW DENTED. REPAIRED DENTED AREA.SDR ASAA1048168Skin · dentedDENT AT STA 1020 FOUND WITHIN 3 INCHES OF SKIN SPLICE FASTENER ROW. REPAIRED DENT.SDR BJNA100702Wire · brokenEMERGENCY FLOOR LIGHTS AT WING EXIT INOPERATIVE. REPAIRED BROKEN WIRE AT LIGHT STRIP AT AFT OVERWING EXIT DOOR IAW SWPM 20-30-12. OPS CK GOOD IAW AMM 33-51-81.SDR BJNA100801Light · inoperativeAISLE LOCATOR LIGHT STRIPS LOCATED AT ROW 10 ABC AND 15 ABC ARE NOT ILLUMINATED. R & R AISLE LOCATOR LIGHT STRIP(S) AT ROW 10ABC AND 15ABC IAW AMM 33-51-81. OPS CK GOOD IAW AMM 33-51-81.SDR ASAA1048064Slat · delaminatedNR 1 SLAT L/E DELAMINATED I/B AFT CORNER. REMOVED DAMAGE, INSTALLED AND BONDED REPAIR DOUBLER.SDR ASAA1048096Skin · dentedDENT AFT OF L2 DOOR BETWEEN STR 12L AND 13L IS WITHIN 3 INCHES OF SKIN BUTT SPLICE. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048095Skin · gougedRIGHT O/B MID FLAP INBOARD LEADING EDGE IS GOUGED. REMOVED DAMAGED AREA, FABBED FILLER AND DOUBLER AND INSTALLED REPAIR.SDR ASAA1048094Skin · delaminatedNR 1 SLAT UPPER O/B AFT CORNER DELAMINATED. REMOVED DAMAGE AND INSTALLED REPAIR.SDR ASAA1048093Skin · delaminatedNR 2 SLAT O/B AFT CORNER DELAMINATED. REMOVED PREVIOUS REPAIR AND INSTALLED NEW.SDR ASAA1048092Skin · chafedNR 4 SLAT LOWER TRAILING EDGE I/B END IS CHAFED. REMOVED DAMAGE, INSTALLED REPAIR.SDR ASAA1048091Skin · delaminatedNR 2 SLAT INBOARD AFT CORNER IS DELAMINATED. REMOVED DAMAGED AREA, BONDED THE REPAIR.SDR ASAA1048082Stringer · damagedSTR 20R HAD DAMAGED OVERSIZED HOLES FROM STA 320-360. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048081Stringer · damagedSTR 21R HAD DAMAGED OVERSIZED HOLES FROM STA 314 370. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048080Stringer · damagedSTR 22R HAD DAMAGED OVERSIZED HOLES FROM STA 320-360. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048070Skin · chafedLEFT O/B FORE FLAP OUTBOARD LOWER SKIN CHAFED. REMOVED REPAIR DOUBLER AND INSTALLED NEW DOUBLER.
Back to Boeing 737-4Q8