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 SWAA2013041915031Light · crackedEXTERIOR EMERGENCY LIGHT AT "L1" DOOR CRACKED. REMOVED AND REPLACED LIGHT IAW AMM.SDR SWAA2013041714900Lens · missingFWD ENTRY DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2013041514831Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2013052216363Beam · crackedINNER CHORD WEB AND STUB BEAM CRACKED AT BS 616, WL 208. R & R STUB BEAM IAW EA.SDR SWAA2013051716139Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STR 18R. REPAIRED FRAME IAW EA.SDR SWAA2013051716138Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STR 18L. REPAIRED FRAME IAW EA.SDR SWAA2013051616091Track · corrodedAFT CARGO COMPARTMENT FLOOR TRACK NUT PLATE HOLES CORRODED AT STA 727D+6, LBL 17. REMOVED AND REPLACED TRACK PER SRM.SDR SWAA2013050615657Web · crackedL1 DOOR UPPER SILL WEB CRACKED. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013043015377Web · crackedWEB CRACKED BETWEEN BS 188 TO BS 195.5, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013042415155Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 712.5, RBL 24.8. REPAIRED WEB PER EA.SDR SWAA2013042415162Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA2013042415161Intercostal · corrodedAFT CARGO COMPARTMENT INTERCOSTAL UNDER RIGHT TRANSITION ANGLE CORRODED BETWEEN BS 747 TO BS 767. REMOVED AND REPLACED INTERCOSTAL PER SRM.SDR SWAA2013042415160Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24.8. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013041915045Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 705, BBL .07. REPAIRED WEB PER EA.SDR SWAA2013041915044Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, BBL .07. REPAIRED WEB PER EA.SDR SWAA2013041714963Channel · corrodedFLOOR CHANNEL CORRODED AT BS 727D+6, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA2013041714962Channel · corrodedFLOOR CHANNEL CORRODED AT BS 727D+6, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA2013041714961Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 714, LBL 24.8. REPAIRED BEAM PER EA.SDR SWAA2013041714960Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707.5 TO BS 710.25, LBL 24.8. REPAIRED WEB PER EA.SDR SWAA2013041714959Strap · corrodedFLOOR SUPPORT STRAP CORRODED AT BS 782. REMOVED AND REPLACED STRAP PER MM.SDR SWAA2013050815849Frame · crackedFRAME CRACKED AT BS 727, OUTBOARD CHORD FORWARD FLANGE, RIGHT LOWER ROW. REPAIRED FRAME IAW EA.SDR SWAA2013050815846Frame · crackedFRAME CRACKED AT BS 727, STR 18L. REPAIRED FRAME IAW EA.SDR SWAA2013050715748Web · corrodedWEB CORRODED BETWEEN BS 807 TO BS 827, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050315549Skin · crackedFUSELAGE SKIN CRACKED AT BS 847 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315557Skin · crackedFUSELAGE SKIN CRACKED AT BS 787 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315556Skin · crackedFUSELAGE SKIN CRACKED AT BS 807 LOWER FWD LEFT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315555Skin · crackedFUSELAGE SKIN CRACKED AT BS 807 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315550Skin · crackedFUSELAGE SKIN CRACKED AT BS 887 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013043015364Window · crackedLEFT UPPER AFT WINDOW CORNER CRACKED AT BS 767 HOLES 2, 3. REPAIRED WINDOW IAW SB.SDR SWAA2013042615261Skin · crackedLEFT BS 827 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 6, 9. REPAIRED SKIN IAW SB.SDR SWAA2013042615260Skin · crackedLEFT BS 807 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 6, 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042615259Skin · crackedLEFT BS 827 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042515205Skin · crackedLEFT BS 787 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 6, 9. REPAIRED SKIN IAW SB.SDR SWAA2013042515204Skin · crackedLEFT BS 767 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 9. REPAIRED SKIN IAW SB.SDR SWAA2013042415146Skin · crackedLEFT BS 847 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415130Skin · crackedLEFT BS 867 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415129Skin · crackedLEFT BS 847 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3, 7, 8. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415128Skin · crackedLEFT BS 887 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 5. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415127Skin · crackedLEFT BS 867 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 5, 6. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415110Skin · crackedRIGHT BS 827 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415109Skin · crackedRIGHT BS 787 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 9. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415108Skin · crackedRIGHT BS 767 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 9. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415107Skin · crackedRIGHT BS 867 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042415106Skin · crackedRIGHT BS 847 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042415104Skin · crackedRIGHT BS 827 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2. REPAIRED SKIN IAW SB.SDR SWAA2013042415103Skin · crackedRIGHT BS 787 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415096Skin · crackedRIGHT BS 767 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415125Skin · crackedRIGHT BS 867 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013041714965Flap Track · crackedNR 1 FLAP TRACK CRACKED APPROX 15" FROM FWD END ON LOWER I/B FLANGE. REMOVED AND REPLACED NR 1 FLAP TRACK PER MM.SDR SWAA2013041214767Door Frame · crackedR1 DOOR CRACKED AT LOWER FRAME AFT CORNER. REMOVED AND REPLACED DOOR IAW AMM.
Back to Boeing 737-3H4