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 SWAA2012071605830Angle · crackedANGLE CRACKED AT BS 325.38+3, BETWEEN STR 20L AND STR 21L. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012071605829Angle · crackedANGLE CRACKED AT BS 312+10, BETWEEN STR 20L AND STR 21L. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012071605828Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071605827Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 23L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071605826Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071605825Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071205709Window · arcedCAPTAIN FWD WINDOW ARCED. REMOVED AND REPLACED WINDOW AND HEAT CONTROLLER PER MM.SDR SWAA2012071005685Skin · crackedFUSELAGE SKIN CRACKED AT BS 344 + 3, STR 2L. REPAIRED SKIN PER SRM & EA.SDR SWAA2012070905613Battery · dischargedAFT I/B EMERGENCY FLASHLIGHT LIGHT INOP. REMOVED AND REPLACED BATTERIES IAW M/M.SDR SWAA2012070905591Battery · dischargedAFT GALLEY EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY IAW MM.SDR SWAA2012082707067Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+18, STR 28L. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012082707066Skin · crackedSKIN CUTOUT CRACKED AT BS 520+7, STR 28R. REPAIRED SKIN IAW EA.SDR SWAA2012082707065Floorbeam · crackedFLOORBEAM CRACKED AT BS 670.5, LBL 24.5. REPAIRED CHORD IAW EO AND EA.SDR SWAA2012080706509Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012080706508Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012080306455Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012073006309Frame · crackedFRAME CRACKED AT BS 188, BETWEEN STR 17L TO STR 18L. REPAIRED FRAME IAW SRM.SDR SWAA2012072706251Stringer · crackedSTRINGER CRACKED AT BS 787, STR 8L. REPAIRED STRINGER IAW SRM.SDR SWAA2012072606205Frame · crackedSTUB FRAME CRACKED AT BS 951, STR 17R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012072306112Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012071705924Stringer · corrodedSTRINGER CORRODED AT BS 867+10, STR 26R. REPAIRED STRINGER IAW SRM.SDR SWAA2012071605861Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071005702Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 96. REPAIRED SKIN IAW SRM.SDR SWAA2012070905682Actuator · leakingRIGHT WING NR 7 I/B SPOILER ACTUATOR LEAKED. REMOVED AND REPLACED ACTUATOR IAW AMM.SDR SWAA2012070905642Skin · crackedSKIN CRACKED AT BS 727A +10, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2012070905612Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA2012080706507Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012080706506Skin · crackedSKIN CRACKED AT BS 360+1, STR 28L. REMOVED AND REPLACED SKIN IAW EA AND EO.SDR SWAA2012073106369Frame · crackedFRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME IAW SRM.SDR SWAA2012072606209Angle · corrodedANGLE CORRODED AT BS 887+16, STR 17R. REMOVED AND REPLACED ANGLE SRM AND DWG.SDR SWAA2012072606204Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012072606153Tie Clip · corrodedTIE CLIP CORRODED AT BS 947.5, STR 23L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012072306056Angle · crackedVERTICAL ANGLE CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012072006037Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STR 23L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012071905990Support Channel · crackedSUPPORT CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012071905989Fitting · crackedCLIP CRACKED AT BS 597, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012071905988Fitting · crackedCLIP CRACKED AT BS 559, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012071905987Support Channel · crackedBULKHEAD SUPPORT CHANNEL CRACKED AT BS 727, RBL 3.00. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012071905972Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT WBL 183.40 OUTBOARD SIDE INTERNAL TRAILING EDGE AREA. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012071805931Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071805928Light · inoperativeRIGHT AFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LAMP IAW MM.SDR SWAA2012071705908Tie Clip · crackedTIE CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071605860Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071605859Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STR 16R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWGSDR SWAA2012071205768Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012070905649Fitting · crackedCLIP CRACKED AT BS 706, STR 10R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012070905596Latch · looseL2 DOOR EMERGENCY EVAC SLIDE LATCH LOOSE. SECURED LATCH IAW MT.SDR SWAA2012080706505Frame · corrodedFRAME CORRODED AT BS 993, STR 17R. REPAIRED FRAME IAW EA.SDR SWAA2012080306454Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012073106358Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW E/O AND EA.
Back to Boeing 737-3H4