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 SWAA2013061817330Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED STUB FRAME IAW EO AND EA.SDR SWAA2013061817328Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53.5. REPAIRED BEAM IAW EA.SDR SWAA2013061817327Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 986.5, RBL 43. REPAIRED CHORD IAW EA.SDR SWAA2013061817326Doubler · crackedLEFT NLG WHEEL WELL DOUBLER EDGE CRACKED AT BS 259.5, BETWEEN WL 185 TO WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2013061016976Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L AFT CARGO COMPARTMENT. REPAIRED FLANGE IAW SRM.SDR SWAA2013061016975Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 727+4, RBL 17. REPAIRED ANGLE IAW SRM AND DRAWING.SDR SWAA2013061016960Channel · corrodedAFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2013061016959Channel · corrodedAFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2013061016946Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, BETWEEN STR 5L TO STR 7L. REPAIRED WEB IAW SRM.SDR SWAA2013060716891Floorbeam · corrodedFLOORBEAM CORRODED AT BS 344, LBL 8. REPAIRED BEAM IAW SRM.SDR SWAA2013060716890Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, LBL 23. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2013060516803Skin · crackedRT BS 500C+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW EA.SDR SWAA2013060516785Cover · crackedL1 DOOR LOWER GATE COVER CRACKED. R & R COVER IAW SRM AND DWG.SDR SWAA2013060416727Angle · crackedRIGHT WING T/E ANGLE CRACKED AT WBL 185.4. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013060416723Skin · crackedLEFT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, AND 3. REPAIRED SKIN IAW SB.SDR SWAA2013060416722Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013060316686Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 5, 6, 7. REPAIRED SKIN IAW EA.SDR SWAA2013060316682Skin · crackedRIGHT BS 520+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013060316681Skin · crackedLEFT BS 727B+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013060316680Skin · crackedLEFT BS 727+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 7, 8. REPAIRED SKIN.SDR SWAA2013060316679Skin · crackedLEFT BS 727D+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4, 12. REPAIRED SKIN IAW EA.SDR SWAA2013060316674Skin · crackedRIGHT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013053116645Tie Down · crackedAFT CARGO TRACK TIE DOWN CRACKED AT BS 747, RBL 13.80. REPAIRED TIE DOWN IAW SRM.SDR SWAA2013053016623Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 967, BETWEEN BL0 TO RBL 8. REPAIRED CHORD IAW SRM.SDR SWAA2013053016622Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN LBL 7 TO RBL 7. REPAIRED CHORD IAW SRM.SDR SWAA2013053016620Angle · crackedL1 DOOR FWD UPPER ANGLE CRACKED. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013052916599Skin · crackedL1 DOOR CUTOUT CRACKED ON REVEAL LOCATED ON AFT LOWER CORNER. R & R CUTOUT IAW SRM AND DWG.SDR SWAA2013052916598Web · crackedWEB CRACKED BETWEEN BS 277 TO BS 291.5, STR 14R. R & R WEB IAW SRM & DWG.SDR SWAA2013052816546Roller · crackedLT WING INTERNAL STRUCTURE OF INBD MID FLAP BEARING PLATE CRACKED. R & R ROLLER ASSY IAW SRM AND CMM.SDR SWAA2013052816537Angle · crackedLEFT WING OTBD T/E STRUCTURE ANGLE CRACKED AT WS 537.806. R & R ANGLE IAW SRM & DWG.SDR SWAA2013052816558Web · crackedWEB CRACKED AT BS 328, BETWEEN STR 23R TO STR 25R. R & R WEB IAW SRM.SDR SWAA2013052416461Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013052316427Skin · crackedRIGHT BS 500A+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013052316426Skin · crackedRIGHT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052316425Skin · crackedRIGHT BS 480+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052216366Angle · crackedANGLE CRACKED AT BS 328, RBL 32. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013052216365Web · crackedWEB CRACKED BETWEEN BS 312 AND BS 328, RBL 32. R & R WEB IAW SRM AND DWG.SDR SWAA2013052216356Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3, 7, 8. REPAIRED SKIN IAW SB.SDR SWAA2013052216355Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3, 6. REPAIRED SKIN IAW SB.SDR SWAA2013052216354Skin · crackedLEFT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052116301Plate · crackedRIGHT WING INBD MID FLAP PLATE CRACKED. R & R PLATE IAW CMM.SDR SWAA2013052116323Strap · crackedSTRAP CRACKED AT BS 328+2, LBL 47. R & R STRAP IAW SRM AND DWG.SDR SWAA2013052116322Strap · crackedSTRAP CRACKED AT BS 312+3, RBL 32. R & R STRAP IAW SRM AND DWG.SDR SWAA2013052016211Angle · crackedRIGHT WING ANGLE CRACKED AT T/E CAVITY. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013052016262Hinge · crackedSHIELD HINGE CRACKED AT BS 294.5, STR 10L. R & R HINGE IAW SRM AND DWG.SDR SWAA2013052016261Floorbeam · corrodedFLOORBEAM CORRODED AT BS 312, RBL 23. R & R BEAM IAW SRM.SDR SWAA2013052016226Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052016225Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,5. REPAIRED SKIN IAW SB.SDR SWAA2013051616084Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM.SDR SWAA2013051315884Lens · missingFORWARD ENTRY DOOR LIGHTED EMERGENCY EXIT SIGN MISSING LENS. INSTALLED LENS IAW AMM.
Back to Boeing 737-3H4