Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2015010535465Skin · crackedNUMBER 6 LE SLAT TE SKIN CRACKED AT STATION 380. REPAIRED SKIN IAW EA.SDR SWAA2015010235411Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 669.75, LBL 24.5. REPAIRED IAW EA.SDR SWAA2014121935157Frame · crackedFUSELAGE FRAME CRACKED AT STATION 520, STRINGER 20L TO 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014121134919Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACHMENT CLIP CRACKED AT BS 639, RBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2014120834766Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACHMENT CLIP CRACKED AT BS 639, LBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2014120134545Slide · looseL1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014120134542Lens · looseLEFT OVERWING EMER EXIT SIGN LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015010535468Frame · crackedLEFT FUSELAGE FRAME STATION 727 CRACKED AT STRINGER 18A. REPAIRED FRAME IAW EA.SDR SWAA2015010535467Frame · crackedRIGHT FUSELAGE FRAME STATION 727 CRACKED AT STRINGER 18A. REPAIRED FRAME IAW EA.SDR SWAA2015010535466Frame · crackedRIGHT FUSELAGE FRAME CHORD STATION 727 CRACKED AT STRINGER 18A FWD LOWER SECTION. REPAIRED FRAME IAW EA.SDR SWAA2014120934855Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW CORNER SKIN CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2014120834818Shear Tie · crackedSHEAR TIE CRACKED AT BS 380, BETWEEN STRINGER 13L TO 14L. R & R SHEAR TIE IAW DWG.SDR SWAA2014120834817Shear Tie · crackedSHEAR TIE CRACKED AT BS 380, BETWEEN STRINGER 14L TO 15L. R & R SHEAR TIE IAW DWG.SDR SWAA2014120834788Skin · crackedLEFT BS 787+10 LOWER FWD WINDOW CORNER SKIN CRACKED AT HOLE NR 10. R & R SKIN IAW EA.SDR SWAA2014120834787Shear Tie · crackedSHEAR TIE CRACKED AT BS 380, BETWEEN STRINGER 13L TO 14L. R & R SHEAR TIE IAW DWG.SDR SWAA2014120534729Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014120134543Lens · looseAFT OVERHEAD EMER LIGHT LOWER LENS LOOSE AT ROW 2. SECURED LENS IAW AMM.SDR SWAA2014121034900Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2014120834784Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 5004, STRINGER 8R. R & R CLIP IAW DWG & SRM.SDR SWAA2014120834783Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R & R CLIP IAW DWG & SRM.SDR SWAA2014120834782Shear Tie · crackedSHEAR TIE CRACKED AT BS 500D, BETWEEN STRINGER 11R TO 12R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014120134564Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 597, STRINGER 5L. R & R CLIP IAW DWG & SRM.SDR SWAA2014120134563Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 597, STRINGER 10L. R & R CLIP IAW DWG & SRM.SDR SWAA2014120134562Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 663, STRINGER 10L. R & R CLIP IAW DWG & SRM.SDR SWAA2014112434407Lens · looseFORWARD RT EMER EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014120834781Skin · delaminatedLEFT WING OTBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2014112634503Strap · crackedTIE STRAP CRACKED AT STATION 351, STRINGER 16L. R & R STRAP IAW SRM.SDR SWAA2014112434406Slide · looseR2 DOOR EVACUATION SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2014112434403Skin · crackedLEFT HORIZONTAL STAB SKIN CRACKED AT IN SPAR OTBD AREA. R & R STAB IAW MM.SDR SWAA2014112434402Skin · crackedRIGHT HORIZONTAL STAB SKIN CRACKED AT IN SPAR OTBD AREA. R & R STAB IAW MM.SDR SWAA2014112434401Lens · looseEMERGENCY LIGHT LENS LOOSE AT ROW 13 ABC. SECURED LENS IAW MM.SDR SWAA2014120834780Skin · delaminatedRIGHT WING OTBD AFT FLAP LOWER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2014120134561Skin · delaminatedLEFT WING INBD FORE FLAP UPPER SKIN DELAMINATED AT OTBD EDGE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014112134367Skin · crackedLEFT WING NR 3 SLAT LOWER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014120134560Fitting · crackedFORWARD ENTRY DOOR CUT OUT FITTING CRACKED AT BS 303.9, BETWEEN STRINGER 13L TO 14L. REPAIRED FITTING IAW SRM & DWG.SDR SWAA2014112134366Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE ASSEMBLY IAW MT.SDR SWAA2014111934318Controller · faultyDECLARED EMER. ACFT WOULD NOT DEPRESSURIZE, CABIN STUCK AT 6000' IN AUTO. R & R CABIN PRESS CONTROLLER IAW MM.SDR SWAA2014111934307Cover · looseRIGHT OVERWING EXIT SIGN COVER LOOSE. R & R SIGN IAW SIP.SDR SWAA2014120534713Stiffener · crackedAFT CARGO DOOR STIFFENER CRACKED AT A BEAM 12 INCHES AFT OF FWD FRAME. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014120234590Stiffener · crackedAFT CARGO DOOR VERTICAL STIFFENER CRACKED AT INNER SKIN ATTACHMENT AFT SIDE OF HANDLE CUT OUT. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014120134546Stringer Splice · crackedSPLICE CRACKED AT BS 727 STRINGER 11L. REPAIRED SPLICE IAW EA.SDR SWAA2014112634500Skin Splice · crackedFUSELAGE SKIN PRODUCTION SPLICE CRACKED AT STATION 727, STRINGER 13L. R & R SPLICE IAW EA.SDR SWAA2014121635057Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908+2, STRINGER 5R. R & R SPLICE IAW EO & EA.SDR SWAA2014120834779Lens · brokenFORWARD CEILING EXIT LIGHT LENS BROKEN AT BS 400. R & R LENS IAW AMM.SDR SWAA2014120834778Lens · brokenAFT CEILING EXIT LIGHT LENS BROKEN AT BS 907. R & R LENS IAW AMM.SDR SWAA2014121935143Lug · corrodedLEFT WING NR 4 FLAP TRACK ATTACH LUG CORRODED. REPAIRED ATTACH ASSEMBLY IAW EA.SDR SWAA2014120434688Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 294.5, STRINGER 23L. R & R BRACKET IAW SRM & DWG.SDR SWAA2014120234596Flap Track · corrodedLEFT WING NR 4 FLAP TRACK CORRODED ON HOLE UPPER SIDE. REPAIRED FLAP TRACK IAW CMM.SDR SWAA2014112134361Stringer Clip · brokenSTRINGER CLIP BROKEN AT BS 908, STRINGER 2L. R & R CLIP IAW SRM & DWG.SDR SWAA2014120434687Access Panel · crackedLEFT WING OTBD SIDE AFT EDGE OF TE ACCESS PANEL 7103L CRACKED. REPAIRED PANEL IAW SRM.
Back to Boeing 737-3H4