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 SWAA2013062517533Shear Web · corrodedSHEAR WEB CORRODED BETWEEN A BS 1008 - BS 1016, BETWEEN LBL 38 - LBL 41. R&R SHEAR WEB IAW DRAWING & SRM.SDR SWAA2013062417501Skin · crackedRT BS 887+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013061917404Door Frame · crackedFWD SERVICE DOOR CUTOUT UPPER FWD CORNER CRACKED AT STUB FRAME BS 296.5, STR 7R. REPAIRED STUB FRAME IAW ER AND EA.SDR SWAA2013061917403Plate · crackedFWD SERVICE DOOR UPPER AFT DOOR STOP BACK PLATE ON AFT SIDE OF DOOR FRAME CRACKED AT STA 332.1, STR 8R. R & R CLIP IAW SRM.SDR SWAA2013061917402Attach Angle · crackedLEFT WING RSS545 WIPER WEB ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2013061917387Skin · delaminatedLT WING NR 2 SLAT INBD UPPER SURFACE DELAMINATED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2013061817285Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 4, 5. REPAIRED SKIN IAW EA.SDR SWAA2013061817286Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,6. REPAIRED SKIN IAW EA.SDR SWAA2013061217077Skin · crackedRIGHT BS 887+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061217076Skin · crackedRIGHT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061217075Skin · crackedRIGHT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013061217074Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061017012Fastener · looseR1 DOOR EMERGENCY EVAC SLIDE COVER FWD GIRT BAR HOLDER LOOSE. R & R FASTENERS IAW SRM.SDR SWAA2013061017011Floorbeam · corrodedFLOORBEAM CORRODED AT BS 326, RBL 56. REPAIRED BEAM IAW SRM.SDR SWAA2013061017010Plate · crackedRIGHT HORIZONTAL STABILIZER ACCESS PANEL NR 9226 PLATE CRACKED. R&R PLATE IAW SRM.SDR SWAA2013061017009Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 294.5, STR 23L. R & R CLIP IAW SRM AND DWG.SDR SWAA2013061016968Skin · crackedRT BS 787+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016967Skin · crackedRIGHT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016966Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016965Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016958Skin · crackedLEFT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3 AND NR 9. REPAIRED SKIN IAW SB.SDR SWAA2013061016957Skin · crackedLEFT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016956Skin · crackedLT BS 787+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,6,7. REPAIRED SKIN IAW SB.SDR SWAA2013061016955Skin · crackedLEFT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013061016954Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,9. REPAIRED SKIN IAW SB.SDR SWAA2013061016953Skin · crackedLT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3. REPAIRED SKIN IAW SB.SDR SWAA2013060716888Skin · crackedLEFT BS 847+10 LWR FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 3. REPAIRED SKIN IAW SB.SDR SWAA2013060716887Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 5. REPAIRED SKIN IAW SB.SDR SWAA2013060716899Floorbeam · crackedFLOORBEAM CRACKED AT BS 312, RBL 21. REPAIRED BEAM IAW SRM.SDR SWAA2013060716898Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 328, LBL 34. REPAIRED CHORD IAW SRM.SDR SWAA2013053116641Flap · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLAP LOOSE. SECURED FLAP IAW MM.SDR SWAA2013071118128Doubler · crackedINTERNAL DOUBLER CRACKED BETWEEN BS 360+5" - BS 380+4, STRINGER 27L - STRINGER 28R. R&R DOUBLER IAW SRM & DRAWING.SDR SWAA2013070918054Sill · corrodedAFT CARGO DOOR UPPER SILL WEB CORRODED BETWEEN BS 807 & BS 827, BETWEEN STRINGER 17R & STRINGER 18R. R&R WEB IAW SRM & DRAWING.SDR SWAA2013070918053Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STRINGER 28L - STRINGER 28R. REPAIRED FRAME IAW EO & EA.SDR SWAA2013070417936Bracket · crackedFLOOR STRUCTURE BRACKET CRACKED AT BS 693, RBL 24.5. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013070217855Doubler · corrodedOUTFLOW VALVE DOUBLER CORRODED AT BS 982, BETWEEN STRINGER 24R - STRINGER 25R R&R DOUBLER IAW SRM.SDR SWAA2013070217851Duct · crackedDUCT ASSEMBLY CRACKED BETWEEN BS 312 - BS 323.7, BETWEEN STRINGER 26L TO STRINGER 27R. REPAIRED DUCT ASSEMBLY IAW EO & EA.SDR SWAA2013070117792Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STR 21R. R&R CLIP PER SRM.SDR SWAA2013070117791Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500C, BETWEEN LBL 2 TO LBL 4. REPAIRED SHEAR TIE PER ER AND SWA EA.SDR SWAA2013062817735Support Angle · corrodedAFT CARGO BAY BULKHEAD SUPPORT ANGLE CORRODED AT BS 947, BETWEEN STRINGER 21L TO STRINGER 25L. R&R ANGLE IAW SRM.SDR SWAA2013062817734Web · crackedAFT CARGO BAY WEB CRACKED BETWEEN BS 789 - BS 792, BETWEEN STRINGER 24R TO STRINGER 25R. R&R WEB IAW SRM & DRAWING.SDR SWAA2013062517605Shear Tie · corrodedSHEAR TIE CORRODED AT BS 1006, RBL 2. R&R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013062517604Shear Tie · corrodedSHEAR TIE CORRODED AT BS 1006, BETWEEN STRINGER 23L - STRINGER 24L. R&R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013062517603Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 907, STRINGER 25R. R&R CLIP IAW SRM.SDR SWAA2013062517602Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 867, STRINGER 27R. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013062517601Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 727D, BETWEEN STRINGER 26R - STRINGER 27R. R&R SHEAR TIE IAW SRM.SDR SWAA2013062517600Channel · crackedAFT CARGO BAY SIDEWALL SUPPORT ANGLE CRACKED AT BS 887, STRINGER 25L. R&R CHANNEL IAW SRM.SDR SWAA2013062517599Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 947.5, STRINGER 19L. R&R CLIP IAW SRM.SDR SWAA2013062517515Butt Joint · corrodedAFT CARGO BAY BUTT JOINT CORRODED AT BS 908, BETWEEN STRINGER 26R - 27R. REPAIRED BUTT JOINT IAW ER & SWA EA.SDR SWAA2013062517514Support Angle · crackedAFT CARGO BAY WATER TANK SUPPORT ANGLE FOR INTERCOSTAL CRACKED AT BS 947.5, BETWEEN STRINGER 24 - 25R. R&R ANGLE IAW SRM.
Back to Boeing 737-3H4