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 AWXA0001846Crease Beam · corrodedRT crease beam (wet area) BS 947-990 has APPROX 10 sq inch surface corrosion and 1 drilled off fastener. removed surface corrosion on RT crease beam - corrosion within limits IAW SRM 53-60-15 fig 101.SDR AWXA0001845Frame · crackedcockpit LT side chord cracked at center of radius WL 207 BS 178 confirmed HFEC. removed and replaced chord IAW SRM 51-40-02 pg 38, 2&3.SDR AWXA0001844Floorbeam · corrodedaft lav FLOORBEAM BS 986.5 has moderate to severe exfoliated corrosion upper T-cap APPROX 30 sq inch. repaired IAW SRM 53-00-51 fig 202 sht 1-4.SDR AWXA0001843Floorbeam · corrodedaft cabin FLOORBEAM BS 947 has APPROX 1 sq inch corrosion at LBL 11. removed corrosion IAW SRM 53-60-51 fig 101 pg 110 det VII; corrosion exceeded limits IAW SRM 53-60-51 fig 101 pg 110 (max allowed .013 inch, removed .023 inch). repaired damaged area IAW SRSDR AWXA0001806Frame · crackedFWD SIDE OF FUSELAGE FRAME CRACKED ABOVE CENTER WING BS 616 LBL 65. TRIMMED OUT DAMAGE; INSTALLED REPAIR ANGLE AND FILLER IAW AWA ER 03-5311-01130-DL2 AND SB 737-53-1182.SDR AWXA0001805Bulkhead · crackedHFEC INSP FWD SIDE OF BS BLKHD WEB FOUND 2 CRACKS RBL 4.7 WL 196.2-197.1 AND 199.9-201.5. REPAIRED IAW SRM 53-10-8 FIG 211 PG 287-298.SDR AWXA0001804Bulkhead · crackedULTRASONIC CRACK INDICATIONS BS 178 BLKHD WEB FWD FACE 2 LBL 6.6 WL 209.5-210, 212.1-212.4 .5 INCH AND .3 INCH RESPECTIVELY. REPAIRED CRACKS IAW SRM 53-10-08 PG 287-298.SDR AWXA0001803Bulkhead · crackedULTRASONIC CRACK INDICATION BS 178 FWD FACE BLKHD WEB RBL 6.6 WL 212-212.7 .7 INCH LENGTH. REPAIRED IAW SRM 53-10-8 PG 287-298.SDR AWXA0001802Skin · scratchedRT EXTERNAL FUSELAGE HAS SCRATCH AFT OF RT WING TO BODY FAIRING JUST FWD AND BELOW EGRESS LIGHT. REPAIRED IAW SRM 53-00-01 FIG 201 PG 201-203.SDR AWXA0001801Pressure Panel · crackedCRACK IN PRESSURE WEB BS 663 APPROX LBL 34 ON TOP OF WEB. REPAIRED IAW ER 03-5702-01135-JS2.SDR AWXA0001800Frame · crackedFWD SIDE OF FUSELAGE FRAME CRACKED ABOVE CENTER WING BS 616 RBL 64 WL 201. TRIMMED OUT DAMAGED SECTION; INSTALLED REPAIR ANGLE AND FILLER IAW AWA ER 03-5311-01130-DL2.SDR SWAA011606Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR AWXA0001799Bulkhead · crackedHFEC INSP FWD SIDE OF BS 178 BLKHD WEB FOUND 3 CRACKS WL 234.1 LBL 9, 11, 12 AT HI-LOK FASTENER HOLES. REPAIRED IAW SRM 53-10-8 PG 265-274 FIG 209.SDR AWXA0001798Crossbeam · crackedCRACK FOUND IN FWD CARGO DOOR CROSSBEAM AFT LWR END. CUT OUT CRACKED SECTION AND INSTALLED FILLER AND REPAIR DOUBLER IAW AWA ER 03-5200-01129-JS1.SDR AWXA0001797Skin · crackedHFEC INDICATES CRACK IN FUSELAGE SKIN AT AFT SERVICE DOOR LWR HINGE CUTOUT BS 947.5 WL 226.5. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLER IAW SRM 53-60-01 FIG 207 PG 217-224.SDR AWXA0001796Bulkhead · crackedHFEC INSP FWD SIDE OF BS 178 BLKHD 2 CRACKS LBL 4.7 WL 199-199.4 AND 201-201.5. REPAIRED IAW SRM 53-10-8 FIG 211 PG 287-298.SDR AWXA0001795Bulkhead · crackedHFEC INDICATES 4 CRACKS BS 178 BLKHD WEB FWD SURFACE WL 234.1 RBL 8, 9, 11, 12 HI-LOK FASTENER HOLES. REPAIRED IAW SRM 53-10-8 FIG 209 PG 265-274.SDR AWXA0001794Bulkhead · crackedVISUAL AFT SIDE BS 178 WEB WL 189-187.8 RBL .6; 1.2 INCH CRACK VERIFIED BY HFEC. REPAIRED IAW SRM 53-10-8 PG 287-298 FIG 211.SDR AWXA0001764Bracket · wornRIGHT ELEVATOR OUTBOARD STAB MOUNT BRACKET HAS PLAY AT STAB MOUNT BOLTS (FITTING BOLT HOLES ARE ELONGATED). REPAIRED IAW AWA ER 03-5500-01143-JS1.SDR SWAA011516Bearing · groovedDURING SCHEDULED SERVICE CHECK, FOUND GROOVED RT MLG TRUNNION BEARING. REMOVED AND REPLACED RT MLG TRUNNION BEARING PER MM.SDR SWAA011521Beam · wornDURING SCHEDULED SERVICE CHECK, FOUND RT MLG ACTUATOR CLEVIS BEAM ARM BUSHING WORN AND CORRODED. REMOVED AND REPLACED CLEVIS BEAM ARM PER MM.SDR AWXA0001730Shear Tie · corrodedFS 727E BETWEEN STR 28L & 238R CORROSION ON FRAME SHEAR TIE. REPAIRED IAW AWA ER 03-5300-01130-JS1.SDR AWXA0001729Shear Tie · corrodedFS 727D BETWEEN STR 27L AND 27R CORROSION ON FRAME SHEAR TIE. REPAIRED IAW AWA ER 03-5300-01131-JS1.SDR AWXA0001728Hinge Fitting · damagedLEFT HORIZONTAL STABILIZER OUTBOARD RIB NR 6 HINGE MOUNT HAS 2 ELONGATED HOLES. REPAIRED HINGE FITTING IAW AWA ER 03-5510-01124-TB1.SDR AWXA0001726Floorbeam · crackedMAIN CABIN BS 520 RBL 45.5 FLOORBEAM CRACKED IN RADIUS OF UPPER CHORD. REPAIRED MAIN CABIN FLOORBEAM IAW EO 53-14-12.SDR AWXA0001725Fitting · crackedR1 DOOR LWR AFT CORNER FITTING CRACKED. REMOVED FITTING, FABED AND INSTALLED REPLACEMENT IAW SRM 51-40-02 PG 2-4 AND BAC DWG 69-69854-1.SDR AWXA0001724Bracket · crackedUPON REMOVAL OF OUTER BRACKET R1 DOOR LWR AFT CORNER FOR ACCESS TO INNER FITTING, FOUND OUTER BRACKET ALSO CRACKED. REMOVED AND REPLACED OUTER BRACKET IAW SRM 51-40-02 PG 10-12.SDR AWXA0001723Frame · crackedMAIN CABIN BS 616 FRAME AT RBL 63 WL 201 FRAME CRACKED AT FASTENER. REMOVED, FORMED, LOCATED, DRILLED AND INSTALLED REPAIR ANGLES AND STRAPS IAW ER 03-5311-01120-BA1.SDR AWXA0001722Frame · crackedMAIN CABIN BS 616 AT LBL 63 WL 201 FRAME CRACKED AT FASTENER. REMOVED, FORMED, LOCATED, DRILLED AND INSTALLED REPAIR ANGLES AND STRAPS IAW ER 03-5311-01120-BA1.SDR AWXA0001721Pressure Panel · crackedBS 663.75 LBL 31 PRESSURE WEB CRACKED. CUT OUT DAMAGED AREA; FABBED AND INSTALLED A REPAIR DOUBLER, FILLER AND STIFFENER IAW ER 03-5702-01116-TB1.SDR AWXA0001720Bulkhead · crackedBS 178 BLKHD WEB AT LBL 10.3-10.6 WL 218 CRACKED BENEATH ANGLE. CUT OUT DAMAGE TO WEB AND INSTALLED A REPAIR DOUBLER AND FILLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001716Angle · crackedCRACK AT LBL 5.7 TEE, BS 178 BLKHD WEB WL 184-185 AFT SIDE OF BLKHD. REMOVED, FORMED, LOCATED, DRILLED AND INSTALLED REPAIR ANGLES AND STRAPS IAW SRM 53-10-08 PG 221-240.SDR AWXA0001715Bulkhead · crackedULTRASONIC CRACK INDICATION BS 178 BLKHD WEB, 1.1 INCH LENGTH, RBL 9.3-10.4 BENEATH ANGLE. REMOVED STRAPS, BRACKETS, ANGLES AND CHANNEL; CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER; REINSTALLED STRAPS, BRACKETS, ANGLSDR AWXA0001714Frame · crackedRT MAIN FRAME BS 178 WL 195 FWD FACE CORRODED; HFEC INDICATES CRACK CONFIRMED FLUORESCENT PENETRANT. REMOVED SEAL RETAINERS, ATTACH ANGLES, BRACKETS, WEB AND SIDE CHORD; LOCATED, DRILLED NEW SIDE CHORD IAW SRM 53-10-02 PG 15 ITEM 8; INSTALLED SEAL RETAINERS, SDR AWXA0001713Bulkhead · crackedBLKHD 178 WEB HAS 2 CRACKS .5 INCH AT LBL .5 AND RBL .5 WL 189. REMOVED LOCALIZER ANTENNA MOUNT BOX; CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER; REINSTALLED LOCALIZER ANTENNA MOUNT BOX IAW SRM 53-10-08 PG 287-298.SDR AWXA0001712Frame · crackedLT MAIN FRAME CRACKED 1 INCH BS 178 WL 207. REMOVED STRAP, SEAL RETAINERS, ATTACH ANGLES, WEB AND SIDE CHORD; LOCATED AND DRILLED NEW SIDE CHORD IAW SRM 51-10-02 PG 15 ITEM 8. INSTALLED SEAL RETAINERS, ATTACH ANGLES, BRACKETS, WEB AND SIDE CHORD IAW SRM 51-4SDR AWXA0001711Bulkhead · crackedTWO CRACKS AT HI-LOKS BS 178 WEB FWD SIDE WL 234.1 RBL 11-12. REMOVED FASTENERS; CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER; REINSTALLED BRACKETS AND STIFFENER AND L-ANGLE IAW SRM 53-10-08 PG 287-298.SDR AWXA0001710Bulkhead · crackedTWO CRACKS AT HI-LOKS BS 178 WEB FWD SIDE WL 234.1 LBL 11-12. REMOVED FASTENERS; CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER; REINSTALLED BRACKETS AND STIFFENER AND L-ANGLE IAW SRM 53-10-08 PG 287-298.SDR AWXA0001709Bulkhead · crackedA .5 INCH CRACK EMANATING FROM BENEATH STRAP BS 178 BLKHD FWD SIDE RBL 4.7 FROM WL 200.2-200.7. REMOVED BRACKETS, STIFFENER AND L-ANGLE; CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER; REINSTALLED BRACKETS AND STIFFENERSDR AWXA0001708Bulkhead · crackedULTRASONIC INSPECTION OF BS 178 BLKHD WEB FOUND CRACK .4 INCH LENGTH LBL 6.7 WL 212-212.4 BENEATH STRAP. REMOVED BRACKETS AND STIFFENER; CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER; REINSTALLED BRACKETS AND STIFFENERSDR AWXA0001707Bulkhead · crackedVISUAL INSPECTION OF BS 178 BLKHD WEB FWD SIDE REVEALED CRACK EMANATING FROM BENEATH STRAP AT WL 198.5-198.8 LBL 4.7. CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001706Bulkhead · crackedHFEC INDICATES .7 INCH CRACK EMANATING FROM BENEATH STRAP BS 178 FWD SIDE WL 201.8-202.1 LBL 4.7. CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001705Bulkhead · crackedHFEC INDICATES .25 INCH CRACK RUNNING HORIZ IN WEB BS 178 WL 207 RBL 11.6-11.75. CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001704Bulkhead · crackedHFEC INDICATES .2 INCH CRACK EMANATING FROM BENEATH STRAP BS 178 BLKHD FORWARD SIDE WL 198.6-198.8 RBL 4.7. CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001703Bulkhead · crackedBS 178 WEB CRACKED .4 INCH WL 198.2-198.6 RBL 6.7 BENEATH STRAP. CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001702Bulkhead · crackedBS 178 WEB CRACKED .5 INCH WL 206 RBL 1-1.5. CUT OUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001701Bulkhead · crackedUPON REMOVAL OF STRAP FOUND .2 INCH CRACK BS 178 WL 210 LBL 4.7. CUTOUT DAMAGED WEB; LOCATED, DRILLED, TRIMMED AND INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 53-10-08 PG 287-298.SDR AWXA0001700Switch · defectiveD: PHX - AIR TURNBACK, APPROX 30 MIN AFTER TAKEOFF THE STANDBY HYDRAULIC LOW QUANTITY LIGHT ILLUMINATED, A AND B SYSTEM QUANTITY WAS NORMAL. THE AIRCRAFT RETURNED TO PHX. MAINTENANCE INSPECTED THE AIRCRAFT FOR LEAKS AND FOUND NONE. THE STANDBY HYDRAULIC RESSDR AWXA0001698Check Valve · failedLAX - 4/30/01 - RT MAIN GEAR GREEN LIGHT DIDN''T ILLUMINATE WITH THE LANDING GEAR HANDLE IN THE DOWN POSITION; WARNING HORN SOUNDED WITH FLAPS AT 5; THE GEAR WAS CYCLED 3 TIMES WITH NO CHANGE; A MANUAL GEAR EXTENSION WAS PERFORMED AND RESULTED IN 3 GREEN LIGHTSDR SWAA011312Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE IN CASE PER MM.
Back to Boeing 737-3G7