Boeing 737-3G7
Service difficulty reports · 5,850
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 = '7373G7' 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 = '7373G7' 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 USAA920071167Skin · delaminatedPHX - MAJOR REPAIR - LEFT WING OUTBOARD TRAILING EDGE FOREFLAP DELAMINATED, WS 202.69 - WS 413.61. REPLACED LEFT WING OUTBOARD TRAILING EDGE FOREFLAP, WS 202.69 - WS 413.61 IAW USAIRWAYS TASK CARD R3M27022.SDR SWAA075744Girt Bar · looseDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR AFT GIRT BAR ATTACH FITTING LOOSE. SECURED AFT GIRT BAR ATTACH FITTING PER MM.SDR SWAA075743Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA075742Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, R2 DOOR LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA075747Window · arcedL1 COCKPIT WINDOW ARCED IN FLIGHT. REMOVED AND REPLACED L1 COCKPIT WINDOW PER MM.SDR USAA920071366Megaphone · inoperativeCLT - EMERGENCY EVACUATION EQUIPMENT - C18, AFT MEGAPHONE INOPERATIVE. REPLACED AFT MEGAPHONE.SDR USAA920071210Skin · delaminatedCLT - MAJOR REPAIR - C16 CHECK, LEFT WING NR 4 GROUND SPOILER UPPER SURFACE HAS DELAMINATION. REPAIRED LEFT WING NR 4 GROUND SPOILER IAW B737 SRM 51-70-10.SDR USAA920071358Door Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME CRACKED, BS 847, S20R. REPLACED AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME, BS 847, S20R IAW B737 SRM 51-40-02.SDR USAA920071287Skin · crackedCLT - MAJOR REPAIR-C-18- NR I1A53039/1, CRACK ON FUSELAGE SKIN AT BS 292, S13R - S14R. REPAIRED IAW SRM 53-00-01A.SDR SWAA075778Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REPOSITIONED R1 DOOR EMERGENCY EVAC SLIDE PER MM.SDR SWAA075779Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR LOWER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED R2 DOOR LOWER EMERGENCY EXIT LIGHT PER MM.SDR SWAA075780Lens · missingDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED R2 DOOR LOWER EMERGENCY EXIT LIGHT PER MM.SDR SWAA075781Light · brokenDURING SCHEDULED HC1 CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LEFT OVERWING EMERGENCY EXIT LIGHT PER MM.SDR SWAA075782Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REMOVED AND REPLACED L2 DOOR EMERGENCY EVAC SLIDE PER MM.SDR USAA920071145Skin · delaminatedPHX - MAJOR REPAIR - RIGHT WING NR 6 SPOILER PANEL DISBONDED UPPER SURFACE, WS 290.07 - WS 342.53. REPLACED THE NR 6 SPOILER, WS 290.07 - WS 342.53 IAW B737 AMM 27-61-11-4.SDR SWAA075715Glowstrip · wornDURING SCHEDULED C1 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN. REMOVED AND REPLACED STRIP PER MM.SDR SWAA075714Lamp · inoperativeDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR USAA920071340Wedge · debondedCLT- MAJOR REPAIR - C-18 CHECK - A DEBOND FOUND ON 2 INCHES OUT OF INBOARD EDGE OF RIGHT OUTBOARD FLAP TRAILING EDGE WEDGE. REMOVED DAMAGE AND REPAIRED ON RIGHT OUTBOARD FLAP TRAILING EDGE WEDGE IAW B737-300 SRM 51-70-10.SDR USAA920071150Skin · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FUSELAGE SKIN, BS 527, S27L. REPAIRED FUSELAGE SKIN, BS 527, S27L IAW USAIRWAYS EA 98963.SDR USAA920071107Spindle · corrodedCLT - MAJOR REPAIR - C16 CHECK, CORROSION ON RIGHT WING OUTBOARD MID FLAP INBOARD CARRIAGE SPINDLE. REMOVED AND REPLACED SPINDLE.SDR USAA920071373Crease Beam · crackedCLT - MAJOR REPAIR - C-18 CHECK- A CRACK FOUND ON INNER CHORD OF LEFT CREASE BEAM AT ATTACHMENT TO BS 616, LBL 4. REMOVED DAMAGE AND INSTALLED FABRICATED REPAIR ANGLE IAW US AIRWAYS EA 100058.SDR USAA920071365Floorbeam · corrodedCLT - MAJOR REPAIR - C18 CHECK, CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, RBL 7. REPAIRED AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, RBL 7 IAW USAIRWAYS EA 100061.SDR USAA920071364Floorbeam · corrodedCLT - MAJOR REPAIR - C18 CHECK, CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, RBL 2. REPAIRED AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, RBL 2 IAW USAIRWAYS EA 100061.SDR USAA920071363Floorbeam · corrodedCLT - MAJOR REPAIR - C18 CHECK, CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, LBL 2. REPAIRED AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, LBL 2 IAW USAIRWAYS EA 100061.SDR USAA920071362Floorbeam · corrodedCLT - MAJOR REPAIR - C18 CHECK, CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, LBL 6. REPAIRED AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, LBL 6 IAW USAIRWAYS EA 100061.SDR USAA920071361Floorbeam · corrodedCLT - MAJOR REPAIR - C18 CHECK, CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, LBL 10. REPAIRED AFT CARGO COMPARTMENT FLOOR SUPPORT BEAM, BS 727D, LBL 10 IAW USAIRWAYS EA 100061.SDR USAA920071359Crease Beam · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED LEFT CREASE BEAM WEB, BS 616 - BS 639. REPLACED LEFT CREASE BEAM WEB, BS 616 - BS 639 IAW USAIRWAYS EA 10058.SDR USAA920071094Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FORWARD ENTRY DOOR AFT FRAME, BS 344, WL 232. REPAIRED FORWARD ENTRY DOOR AFT FRAME, BS 344, WL 232 IAW USAIRWAYS EA 98952.SDR USAA920071151Spar · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED VERTICLE STABILIZER LEFT AFT SPAR CHORD, RUDDER STATION 18. REPLACED VERTICLE STABILIZER LEFT AFT SPAR CHORD, RUDDER STATION 18 I/A/W B737 SRM 55-30-13.SDR USAA920071067Seat Track · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED VERTICAL LEG OF SEAT TRACK, BS 673, LBL 24. REPAIRED CRACKED VERTICAL LEG OF SEAT TRACK, BS 673, LBL 24 IAW USAIRWAYS EA 98938.SDR USAA920071095Rib · crackedCLT - MAJOR REPAIR - C16 CHECK, LEFT WING RIB CRACKED, WBL 135.5. REPAIRED LEFT WING RIB, WBL 135.5 IAW USAIRWAYS EA 98937.SDR USAA920071044Attach Angle · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED INTERCOSTAL ATTACH ANGLE, AFT SIDE OF FLOORBEAM, BS 380, RBL 24.5. REPLACED INTERCOSTAL ATTACH ANGLE, AFT SIDE OF FLOORBEAM, BS 380, RBL 24.5 IAW B737 SRM 51-70-11.SDR USAA920071052Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 312, S7R - S8R. REPLACED FRAME, BS 312, S7R - S8L IAW B737 SRM 51-40-03.SDR USAA920071046Stringer Clip · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED STRINGER TIE CLIP, BS 867, S21R. REPLACED STRINGER TIE CLIP, BS 867, S21R IAW B737 SRM 51-40-02.SDR USAA920071004Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 807, S8R - S9R. REPAIRED FRAME, BS 807, S8R - S9R IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR USAA920071003Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 887, S8R - S9R. REPAIRED FRAME, BS 887, S8R - S9R IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR USAA920071002Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 787, S8R - S9R. REPAIRED FRAME, BS 787, S8R - S9R IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR USAA920070998Stringer Splice · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED STRINGER SPLICE BS 907, S4R. REPLACED STRINGER SPLICE, BS 907, S4R IAW B737-300 SRM 51-10-02.SDR SWAA075298Relay · faultyAIR TUNBACK, ON CLIMBOUT OF LAS NOSE GEAR UNSAFE LIGHT REMAINDED ON AFTER GEAR RETRACTION. GEAR LIGHT STAYED ON WITH HANDLE IN OFF POSITION. REMOVED AND REPLACED R374 RELAY PER MM.SDR USAA920071006Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 887, S26R. REPAIRED FRAME, BS 887, S26R IAW B737-300 SRM 51-70-11.SDR USAA920070999Stringer · corrodedCLT - MAJOR REPAIR - C16 CHECK, CORROSION AND CRACK ON STRINGER, BS 324, BL 0. REPLACED STRINGER, BS 324, BL 0 IAW B737-300 SRM 51-10-02.SDR USAA920071140Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, FORWARD SERVICE DOOR CUTOUT AFT FRAME CRACKED, BS 344. REPAIRED FORWARD SERVICE DOOR CUTOUT AFT FRAME, BS 344 IAW USAIRWAYS EA 100022.SDR USAA920071043Stringer · crackedCLT - MAJOR REPAIR - C16 CHECK, STRINGER 18A RIGHT WEB CRACKED, BS 663 - BS 747. REPLACED STRINGER 18A RIGHT WEB, BS 663 - BS 747 IAW B737 SRM 51-10-02.SDR USAA920071009Stop Fitting · crackedCLT - MAJOR REPAIR - C20 CHECK, FORWARD ENTRY DOOR STOP FITTING CRACKED, BS 328, 4TH ONE FROM THE BOTTOM. REPAIRED FORWARD ENTRY DOOR STOP FITTING, BS 328, 4TH ONE FROM THE BOTTOM IAW B737-300 SRM 51-70-11.SDR USAA920071005Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 360, S13R. REPAIRED FRAME, BS 360, S13R IAW USAIRWAYS EA 98944, EA 98948 AND TYPICAL REPAIR 53-10-01.SDR USAA920071050Attach Angle · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME ATTACH ANGLE, BS 348, S14L - S15L. REPLACED FRAME ATTACH ANGLE, BS 348, S14L - S15L IAW B737 SRM 51-10-02.SDR USAA920071048Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 480, S8L - S9L. REPAIRED FRAME, BS 480, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071068Skin · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FUSELAGE SKIN, BS 294.5, S13L AT LOWER DOOR HINGE CUTOUT. REPAIRED CRACKED FUSELAGE SKIN, BS 294.5, S13L AT LOWER DOOR HINGE CUTOUT IAW B737 SRM 51-10-02.SDR USAA920071001Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 360, S7L - S11L. REPAIRED FRAME, BS 360, S7L - S11L IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR USAA920070997Stringer · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED STRINGER SPLICE, BS 907, S4L. REPLACED STRINGER SPLICE, BS 907, S4L IAW B737-300 SRM 51-10-02.
Back to Boeing 737-3G7