Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA117624Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA117692Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA117576Slat · damagedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 6 SLAT I/B CAN DAMAGED. REMOVED AND REPLACED SLAT CAN PER EA.SDR SWAA117574Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA117573Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA117575Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED BETWEEN BS 435 TO BS 436, STR 1. REPAIRED SKIN PER EA.SDR SWAA117549Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639. REMOVED AND REPLACED WEB PER SRM.SDR SWAA117548Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND RT INNER CREASE BEAM CHORD CRACKED AT BS 638, WL 208. REPAIRED BEAM IAW SRM.SDR SWAA117547Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 932, STR 21L. REPAIRED SKIN IAW SRM.SDR SWAA117546Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND SKIN CRACKED AT BS 656, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA117545Structure · corrodedDURING SCHEDULED 22Y CHECK, FOUND LOWER CHORD CORRODED AT BS 227, BETWEEN STR 27L TO STR 28L. REPAIRED CHORD IAW ER AND EA.SDR SWAA117544Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 660 TO BS 673, LBL 24.5. REPAIRED CHORD IAW ER AND EA.SDR SWAA117543Bear Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND BEAR STRAP IS CRACKED AT FWD GALLEY DOOR CUTOUT UPPER AFT CORNER. REPAIRED BEAR STRAP IAW EA.SDR SWAA117542Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 761.5, BL 0. REPAIRED SKIN IAW ER AND EA.SDR SWAA117541Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 870, STR 24R. REPAIRED SKIN IAW ER AND EA.SDR SWAA117522Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, WL 209. REPAIRED FRAME IAW EA.SDR SWAA117521Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 1010, STR 5R. REPAIRED STRINGER IAW ER AND EA.SDR SWAA117520Lens · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD EMERGENCY EXIT SIGN ASSY CRACKED. REPAIRED LENS ASSY PER MM.SDR SWAA117476Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 380+12, STR 16R. REPAIRED SKIN IAW EA.SDR SWAA117487Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME INNER CHORD WEB CRACKED AT BS 807, STR 25L. REPAIRED WEB IAW ER.SDR SWAA117486Web · crackedDURING SCHEDULED 22Y CHECK, FOUND NLG WHEEL WELL LT WEB CRACKED BETWEEN BS 246 TO BS 247, WL 168. REPAIRED WEB IAW EA.SDR SWAA117485Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294, STR 7R. REPAIRED FRAME PER ER.SDR SWAA117484Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 5R. REMOVED AND REPLACED SPLICE IAW ER.SDR SWAA117483Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE IAW ER.SDR SWAA117482Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED SPLICE IAW ER.SDR SWAA117481Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 466, STR 22L. REPAIRED SKIN IAW ER.SDR SWAA117480Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 476, STR 26L. REPAIRED SKIN IAW EA.SDR SWAA117479Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 943, STR 23R. REPAIRED SKIN IAW SRM.SDR SWAA117478Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 919, STR 23R. REPAIRED SKIN IAW SRM.SDR SWAA117477Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 950, STR 23R. REPAIRED STRINGER IAW EA.SDR SWAA117498Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 803, STR 21L. REPAIRED SKIN IAW ER AND EA.SDR SWAA117497Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 764, STR 21L. REPAIRED SKIN IAW ER AND EA.SDR SWAA117500Shear Web · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR WEB CRACKED BETWEEN BS 616 TO BS 639, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA117499Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT FRAME INNER CHORD CRACKED AT BS 616, WL 202. REPAIRED CHORD IAW EA.SDR SWAA117425Charger · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT FWD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA117424Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER INSPAR SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA117416Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 639, RBL 45. REPAIRED WEB IAW EA.SDR SWAA117415Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 639, LBL 45. REPAIRED WEB IAW EA.SDR SWAA117414Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND BULKHEAD WEB CRACKED AT BS 1016, WL 210. REPAIRED WEB IAW EA.SDR SWAA117413Resistor · brokenDURING SCHEDULED 22Y CHECK, FOUND LT COCKPIT DOME LIGHT RESISTOR R340 BROKEN LEADS. REMOVED AND REPLACED RESISTOR PER MM.SDR SWAA117412Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED SPLICE IAW ER.SDR SWAA117411Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT FLOORBEAM UPPER CHORD CORRODED AT BS 986.5, RBL 45. REPAIRED BEAM IAW EA.SDR SWAA117410Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 1010, STR 4L. REPAIRED STRINGER IAW EA.SDR SWAA117409Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FLOOR CHANNEL CORRODED AT BS 773, LBL 12.5. REPAIRED CHANNEL IAW SRM.SDR SWAA117496Structure · corrodedDURING SCHEDULED 22Y CHECK, FOUND LOWER CHORD CORRODED AT BS 294.5, STR 27R. REMOVED AND REPLACED CHORD IAW SRM AND DWG.SDR SWAA117495Web · crackedDURING SCHEDULED 22Y CHECK, FOUND WEB CRACKED AT BS 616, LBL 45.5. REPAIRED WEB IAW EA.SDR SWAA117493Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 345, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA117492Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 295.5, STR 10L. REPAIRED STRINGER IAW EO.SDR SWAA117491Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 667, LBL 24.5. REPAIRED CHORD IAW EO, EA, AND DWG.SDR SWAA117490Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR FRAME CRACKED AT BS 332.1, STR 8R. REPAIRED FRAME IAW EA AND EO.
Back to Boeing 737-5H4