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 ASAA0944992Beam · crackedFWD ENTRY DOOR LOWER GATE BEAM CRACKED BEYOND STOP DRILL. REPAIRED LOWER GATE BEAM PER SRM 51 70 11.SDR ASAA0944990Intercostal · bentFWD CARGO BAY INTERCOSTAL BENT. REPLACED INTERCOSTAL PER SRM 51 30 01 AND DWG 69 18388.SDR ASAA0944989Intercostal · bentFWD CARGO BAY INTERCOSTALS BENT LBL 24.20 (9 EACH). REPLACED WITH NEW PARTS PER SRM 51 30 01 AND DWG 69 41473.SDR ASAA0945000Skin · corrodedSEVERAL SMALL AREAS OF CORROSION AROUND BELLY DRAINS AT LOWER FUSELAGE BS 360 BETWEEN STA 24L AND 24R. CORROSION FOUND TO BE IN LIMITS ALODINED AND PRIMED.SDR ASAA0944978Rib · chafedLT WING T/E RIB IS CHAFED ON LOWER SURFACE OF UPPER FLANGE. BLENDED AND TREATED CHAFED AREA PER EA 400 57EA 00956. RE-INSPECTION WITHIN 24 MONTHS.SDR ASAA0944980Intercostal · crackedFWD CARGO COMPARTMENT INTERCOSTAL CRACKED. REMOVED INTERCOSTAL, FABRICATED NEW INTERCOSTAL AND INSTALLED PER SRM 51 40 02.SDR ASAA0944979Intercostal · crackedFWD CARGO COMPT BS 500E TO 500F WL 150 RBL 20 INTERCOSTAL CRACKED AT BOTH ENDS. REMOVED AND REPLACED INTERCOSTAL IAW SRM 57 40 02.SDR ASAA0944993Strap · damagedCARGO DOOR THRESHOLD STRAP FRAME BS 767+15 TO BS 794+9 RBL 20 WL 156 THAT GOES UNDER BOTH WEBS HAS EXISTING ELONGATED HOLE. REMOVED AND REPLACED STRAP PER SRM 51 40 02 AND 51 40 05.SDR ASAA0944962Fastener · looseFWD CARGO PIT BLOW OUT PANEL NOT SECURED. REPLACED BUTTON HEAD FASTENERS WITH FLUSH RIVETS AND STRAP PER ASA EA 400 53EA 00501 AND ASA EA 400 53A 00973.SDR ASAA0944963Strap · damagedAFT CARGO STRAP HAS ELONGATED HOLES. INSTALLED NEW STRAP PER SRM 51 40 02.SDR ASAA0944964Fuse · blownL1 EMERGENCY EXIT SIGN OVER THE DOOR IS INOP. REMOVED AND REPLACED FUSE IN EMERGENCY BATTERY PACK POWER SUPPLY.SDR ASAA0944959Web · corrodedAFT CARGO VERTICAL WEB BS 847 867 STR 25R HAS CORROSION. REPLACED WEB PER SRM 53 60 15 AND SRM 51 40 02.SDR ASAA0944960Skin · chafedNR 4 SLAT CHAFED ON THE INNER UPPER SURFACE T/E WEDGE. REMOVED PREVIOUS REPAIR AT I/B END. INSTALLED NEW DOUBLER AND REPAIRED PER ER 09 2016 ASA EA 400 57EA 0096.SDR ASAA0944961Support Angle · crackedE1 2 EQUIPMENT SHELF RT SUPPORT ANGLE CRACKED. REMOVED AND REPLACED PER ER 09 2053 ASA EA 400 25EA 00939.SDR ASAA0944957Floor Support · corrodedFLOOR SUPPORT IS CORRODED STA 847 867. REMOVED AND REPLACED SUPPORT PER SRM 51 40 02.SDR ASAA0944950Support Channel · crackedWX RADAR R/T UNIT LT SUPPORT CHANNEL CRACKED. REMOVED AND REPLACED CHANNEL PER SRM 51-40-02.SDR ASAA0944949Skin · corrodedGROUND AIR CONDITIONING ACCESS DOOR EXTERNAL SKIN PILLOWING AND INTERNAL SKIN CORRODED. REPLACED GROUND AIR CONDITIONING ACCESS DOOR PER SRM 51 40 02.SDR ASAA0944956Rib · damagedINBOARD AND OUTBOARD ACTUATOR ATTACH RIBS DAMAGED AT NR 4 SLAT AND LOWER T-CHORD DAMAGED. REPAIRED INBOARD AND OUTBOARD NR 4 SLAT ACTUATOR RIBS AND REPLACED LOWER T-CHORD PER SRM 57 43 03 PG 106 SRM 51 20 00 AND DWG 65C26603.SDR ASAA0944955Tee Fitting · damagedNR 4 SLAT LOWER T-CHORD DAMAGED AT PCU ATTACH POINT. REPLACED T-CHORD PER SRM 51 40 05, SRM 51 30 01 AND DWG 65C26603.SDR ASAA0944948Support Angle · crackedLT WING I/B TRAILING NO STEP PANEL O/B SUPPORT ANGLE IS CRACKED. REPLACED SUPPORT ANGLE (FITTING) PER SRM 51 40 02.SDR ASAA0944951Tripler · gougedSKIN REPAIR OF LT MLG W/W FS 727 AT STR 26L HAS A GOUGE IN TRIPLER. REPAIRED TRIPLER IAW ASA EA 400 53EA 0096 REV NEW.SDR ASAA0944954Channel · crackedCHANNEL CRACKED BS 794 STR 17 RT. REPLACED CHANNEL PER SRM 51 30 01 & SRM 51 40 02.SDR ASAA0944947Support Angle · corrodedSUPPORT ANGLE ABOVE ANTI COLLISION LIGHT CORRODED. REPLACED SUPPORT ANGLE PER SRM 51-40-02 AND DWG 65-45866.SDR ASAA0944953Strap · damagedFRAME STRAP BS 794 STR 16 26R HAS ELONGATED HOLES. REPLACED FRAME STRAP PER SRM 51 40 02.SDR ASAA0944899Floorbeam · damagedFLOORBEAM WHERE SEAT TRACK ATTACHES AFT FASTENER HOLE IS A DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 727D.SDR ASAA0944952Channel · damagedDURING BS 794 RT FRAME REPLACEMENT FOUND WEB MECHANICAL DAMAGE BS 794 STR 16R. REPLACED WEB PER SRM 53 60 15 DETAIL VI SRM 51 40 05 AND DWG 65 47962.SDR ASAA0944897Support Angle · damagedLT WING T/E CAVITY NO STEP PANEL I/B ANGLE AFT FASTENER HOLE IS OUT OF ROUND. REPLACED SUPPORT ANGLE.SDR ASAA0944908Skin · dentedRT HORIZONTAL STABILIZER L/E IS DENTED. CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 55 10 01.SDR ASAA0944898Seat Track · corrodedSEAT TRACK BS 727B 800 LBL 24 HAS NUMEROUS AREAS OF MECHANICAL DAMAGE AND OR CORROSION OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK BS 727B 927 LBL 24.SDR ASAA0944900Door Frame · chafedFWD ENTRY DOOR UPPER AFT CORNER OF DOOR SIDE FRAME CHAFED BY UPPER AFT DOOR STOP FTG. REPAIRED PER ER 09 1862 AND EA NUMBER 400 52EA 00931.SDR ASAA0944887Web · crackedCLOSE OUT WEB CRACKED. REPAIRED WEB IAW SRM 51-70-13.SDR ASAA0944886Intercostal · crackedINTERCOSTAL CRACKED. REMOVED FABRICATED NEW AND INSTALLED INTERCOSTAL.SDR ASAA0944860Skin Panel · gougedRT ENGINE PYLON PANEL 5827B CUTOUT INNER SURFACE ON MOUNTING FLANGE GOUGED. REPAIRED PER EA 400 54EA 00912.SDR ASAA0944857Flap Track · corrodedCORROSION ON NR 4 FLAP TRACK. REMOVED AND REPLACED FLAP TRACK.SDR ASAA0944896Doubler · crackedANGLE REVEAL DOUBLER TORN BS 312 STR 10L 11L. REMOVED AND INSTALLED NEW ANGLE REVEAL DOUBLER BS 312 STR 10L 11L PER SRM 51 40 02.SDR ASAA0944864Attach Angle · crackedFWD ENTRY DOOR AFT LOWER WEB ATTACH ANGLE CRACKED. REMOVED AND REPLACED ATTACH ANGLE.SDR ASAA0944861Bear Strap · corrodedCORROSION AFT CARGO DOOR CUTOUT ON INNER SURFACE OF BEAR STRAP. REMOVED EXISTING DOUBLER AND TRIPLER, FABRICATED NEW REPAIR PARTS AND INSTALLED PER EA-400-53EA-00980.SDR ASAA0944859Seat Track · corrodedSEAT TRACK CORROSION OUT OF LIMITS BS 727B 840. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944858Doubler · tornANGLE REVEAL DOUBLER TORN BS 312 STR 10L 11L. REMOVED AND INSTALLED NEW ANGLE REVEAL DOUBLER BS 312 STR 10L 11L PER SRM 51 40 02.SDR ASAA0944862Skin · dentedLT HORIZONTAL STAB L/E DENTED OUT OF LIMITS. REPAIRED LT HORIZONTAL STAB L/E PANEL AT THE 10TH RIB FROM THE O/B END.SDR ASAA0944863Skin · chafedFUSELAGE SKIN WORN WHERE DORSAL FIN CONTACTS. REPAIRED PER SRM 53-60-01.SDR ASAA0944888Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AT STA 767 787 RBL 20. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT.SDR ASAA0944846Stringer · damagedWHILE REPLACING BOLTS ON 1016 BULKHEAD FOUND STR 27 LT TO HAVE DAMAGE.SDR ASAA0944852Support Angle · crackedFAIRING SUPPORT ANGLE CRACKED STA 540 LBL 20. REMOVED AND REPLACED FAIRING SUPPORT ANGLE.SDR ASAA0944845Door Frame · damagedFWD CARGO DOOR CUTOUT AFT FRAME HAS AN OUT OF ROUND HOLE RBL 26 WL 156. REMOVED AND REPLACED FRAME PER DWG 69-18202 AND SRM 51-40-02.SDR ASAA0944844Skin · wornLEFT I/B EXHAUST GATE UPPER SKIN IS WORN BEYOND REPAIR. REMOVED AND REPLACED LEFT I/B EXHAUST GATE UPPER SKIN PER SRM 51 40 02.SDR ASAA0944842Angle · damagedBS 294 FLOORBEAM REINFORCEMENT ANGLE HAS A FACTORY HOLE NEXT TO A PILOT HOLE CREATING A DOUBLE HOLE. REMOVED AND REPLACED ANGLE PER SRM 51-40-02, 51-40-05 AND DWG 65C33940.SDR ASAA0944974Support Bracket · gougedAFT CARGO BAY THRESHOLD SUPPORT BRACKET LOCATED AT BS 817 WL 159 RBL 25 IS GOUGED. REMOVED AND REPLACED PER SRM 51 30 01 AND 51 40 02.SDR ASAA0944865Skin · chafedRIGHT O/B WING LEADING EDGE IS CHAFED AT NR 4 SLAT I/B TRACK CUTOUT O/B SIDE. REPAIRED CHAFING DAMAGE ON RIGHT O/B WING LEADING EDGE AT NR 4 SLAT I/B TRACK CUTOUT O/B SIDE.SDR ASAA0944843Skin · corrodedCORROSION ON RIGHT I/B FLAP LEADING EDGE. REPAIRED LEADING EDGE.
Back to Boeing 737-4Q8