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 SWAA2012101108418Spindle · corrodedRIGHT WING NR 8 SPINDLE CORRODED. REMOVED AND REPLACED NR 8 FLAP CARRIAGE SPINDLE ASSY IAW MT.SDR SWAA2012100908347Charger · inoperativeL1 DOOR EVAC SLIDE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED LIGHT BATTERY CHARGER PER MM.SDR SWAA2012101008392Light · inoperativeRIGHT FORWARD LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2012100908345Slat · delaminatedNR 6 SLAT I/B SIDE DELAMINATED. REMOVED AND REPLACED SLAT ASSY PER MM.SDR SWAA2012102308777Battery Pack · dischargedLEFT EMERGENCY EXIT LIGHT FOR DOOR AND SIDEWALL INOP. REMOVED AND REPLACED BATTERY PACK IAW AMM.SDR SWAA2012102308776Light · inoperativeRIGHT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 15. RELAMPED LIGHT IAW AMM.SDR SWAA2012102308747Stiffener · crackedBULKHEAD STIFFENER CRACKED AT BS 178, STR 17R. REMOVED AND REPLACED STIFFENER IAW EA.SDR SWAA2012102308746Stringer · crackedSTRINGER CRACKED AT BS 178, 17R. REPAIRED STRINGER IAW EA.SDR SWAA2012102308711Frame · crackedSTUB FRAME CRACKED AT BS 947+10.5, STR 17R. REPAIRED STUB FRAME IAW EO AND EA.SDR SWAA2012100908344Flap · delaminatedLEFT OUTBOARD AFT FLAP DELAMINATED AT NR 2 FAIRING CONTACT AREA. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA2012100908332Skin · crackedFUSELAGE SKIN CRACKED AT STA 513, BELOW STR 8L. REPAIRED SKIN PER EA.SDR SWAA2012100808308Light · arcedELECTRICAL SMELL IN AFT GALLEY AREA. REMOVED AND REPLACED AFT GALLEY CEILING LIGHT ASSY PER MM.SDR SWAA2012110509097Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012110509045Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110509044Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012110509043Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012110108988Skin · crackedSKIN CRACKED AT BS 440, LBL 5. REMOVED AND REPLACED SKIN IAW SRM AND DWG.SDR SWAA2012110108987Support Channel · crackedSUPPORT CHANNEL CRACKED AT BS 787, STR 27R. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012103008970Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012103008969Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102908911Skin · crackedSKIN CRACKED AT BS 440, LBL 5. REPAIRED SKIN IAW EA.SDR SWAA2012102608885Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012102608884Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012102608883Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012102608882Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012102608881Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012102608870Support Channel · crackedSUPPORT CHANNEL CRACKED AT BS 787, STR 27R. REMOVED AND REPLACED CHANNEL IAW SRM AND BAC DWG.SDR SWAA2012102308783Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308782Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308781Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308780Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308779Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308720Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308719Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308718Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308717Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308716Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308715Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308714Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012102308699Support Angle · crackedSUPPORT ANGLE ON INTERCOSTAL CRACKED AT BS 787, STR 27R. REPAIRED ANGLE IAW DWG & SRM.SDR SWAA2012101708594Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101708593Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008388Slat · delaminatedLEFT WING NR 2 SLAT UPPER TRAILING EDGE OUTBOARD CORNER DELAMINATED. REMOVED AND REPLACED NR 2 SLAT PER AMM.SDR SWAA2012100808329Light · inoperativeBULLNOSE EMERGENCY LIGHT AT ROW 6 ABC INOP. RELAMPED BULLNOSE EMERGENCY LIGHT PER MM.SDR SWAA2012101908682Skin · crackedSKIN CRACKED BETWEEN BS 360+5 TO BS 380+5, BETWEEN STR 27L TO STR 28R. REMOVED AND REPLACED SKIN IAW SRM AND DWG.SDR SWAA2012101708592Web · crackedRIGHT WEB CRACKED AT BS 243.7, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012101508546Web · crackedWEB CRACKED BETWEEN BS 351.2 TO BS 360, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012101108433Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012100808314Cover · looseR2 DOOR SLIDE COVER LOOSE. REMOVED AND REPLACED DOOR SLIDE COVER PER AMM.SDR SWAA2012102308710Web · crackedWEB CRACKED AT BS 178+2, LBL 5.7. REPAIRED WEB IAW SRM.
Back to Boeing 737-3H4