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 SWAA2014102233224Door Frame · crackedAFT PIT FWD DOOR FRAME LOWER WEB CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2014100332619Plate · crackedLEFT WING INBD FLAP OTBD CARRIAGE GIMBLE CLOCKING PLATE CRACKED AT LOWER BOLT. R & R PLATE IAW CMM.SDR SWAA2014092232187Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014092232179Lens · missingRIGHT OVERHEAD BULLNOSE EMER EXIT LIGHT LENS MISSING AT ROW 16. INSTALLED LENS IAW SIP.SDR SWAA2014092232201Circuit Card · faultyAIR TURN BACK RT MLG UNSAFE LIGHT INDICATION. R & R M981 & M982 PC CARD IAW MMM.SDR SWAA2014101332893Bulkhead · corrodedSTATION 1016 FWD SIDE OF PRESS WEB CORRODED AT LOWER 2 FASTENER ROWS RBL 12 TO LBL 12. REPAIRED WEB IAW AE.SDR SWAA2014100332596Light · brokenFORWARD CABIN EEPLS BROKEN. R & R EEPLS IAW MM.SDR SWAA2014093032446Skin Splice · crackedTAIL CONE, APU EXHAUST AFT MOUNTING RING AT 9 O'CLOCK POSITION INTERIOR SKIN SPLICE CRACKED. R & R SKIN SPLICE IAW SRM & DWG.SDR SWAA2014093032445Skin Splice · crackedTAIL CONE, APU EXHAUST AFT MOUNTING RING AT 3 O'CLOCK POSITION INTERIOR SKIN SPLICE CRACKED. R & R SKIN SPLICE IAW SRM & DWG.SDR SWAA2014092232185Skin · crackedFORWARD ENTRY DOOR CRACKED AT LOWER HINGE INNER SKIN. REPAIRED DOOR IAW EA.SDR SWAA2014102733381Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727 LT STRINGER 18A. REPAIRED FRAME IAW EA.SDR SWAA2014102233252Pressure Deck · crackedPRESSURE DECK OVER MAIN WW BEADED PANEL CRACKED AT BS 666 LBL 39. R & R PANEL IAW EA.SDR SWAA2014102233223Frame · crackedFRAME CHORD OTBD CHORD CRACKED AT BS 727 STRINGER 18A FWD LOWER HOLE LT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2014100932795Skin · crackedSKIN CRACKED AT BS 380 STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014100732722Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO 480. R & R WEB IAW SRM & DWG.SDR SWAA2014100332608Skin · delaminatedLEFT WING FORE FLAP INBD UPPER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014100232547Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867. REPAIRED WEB IAW SRM & DWG.SDR SWAA2014093032467Crease Beam · corrodedRIGHT MAIN CABIN CREASE BEAM WEB CORRODED BETWEEN BS 727D TO 727E. R & R WEB IAW SRM & DWG.SDR SWAA2014093032444Lens · brokenLEFT NR 6 STOW BIN LOWER BULLNOSE EMER LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014092532307Rib · crackedRIGHT WING RIB LOWER CHORD AT WBL 135.5 CRACKED. REPAIRED RIB IAW EA.SDR SWAA2014092232161Flashlight · faultyAFT FLASHLIGHT FAULTY. R & R FLASHLIGHT ASSEMBLY IAW MM.SDR SWAA2014092232159Angle · crackedANGLE CRACKED AT BS 328 LBL 46. R & R ANGLE IAW DWG & SRM.SDR SWAA2014101332887Frame · crackedRIGHT FUSELAGE FRAME CRACKED AT STATION 727 STRINGER 18A. R & R FRAME ASSEMBLY IAW EA.SDR SWAA2014101332886Frame · crackedLEFT FUSELAGE FRAME CRACKED AT STATION 727 STRINGER 18A. R & R FRAME ASSEMBLY IAW EA.SDR SWAA2014101032862Crossbeam · crackedAFT CARGO COMPARTMENT DOOR CROSSBEAM E T-CHORD CRACKED. REPAIRED BEAM IAW EA.SDR SWAA2014100932794Skin · crackedSKIN CRACKED AT BS 727D+7 STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014100832767Skin · crackedSKIN CRACKED AT BS 786 STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014092232196Intercostal · crackedINTERCOSTAL CRACKED AT BS 348.2 STRINGER 16L. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2014091832080Spoiler · brokenLEFT WING INBD NR 4 GND SPOILER ATTACH POINT OTBD END BROKEN. R & R NR 4 SPOILER IAW AMM.SDR SWAA2014091832079Lens · out of adjustEMERGENCY EXIT LIGHT LENS COVER OUT OF ADJUSTMENT. ADJUSTED LENS IAW AMM.SDR SWAA2014100632644Frame · crackedFRAME CRACKED AT BS 336 STRINGER 20L. R & R FRAME IAW SRM & DWG.SDR SWAA2014100332607Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312 STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014100332606Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 294.5 STRINGER 23L. R & R CLIP IAW SRM & DWG.SDR SWAA2014100232526Angle · crackedVERTICAL ANGLE CRACKED AT BS 328 RBL 32. R & R ANGLE IAW SRM & DWG.SDR SWAA2014100232525Web · crackedWEB CRACKED BETWEEN BS 312 TO 328 RBL 32. R & R WEB IAW SRM & DWG.SDR SWAA2014093032443Plate · crackedR1 DOOR EMER EXIT SIDEWALL LIGHT MOUNT PLATE CRACKED. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014092932366Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO 344 LBL 47. R & R STRAP IAW SRM & DWG.SDR SWAA2014092532300Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328 STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014092532299Web · crackedWEB CRACKED BETWEEN BS 312 TO 328 LBL 47. R & R WEB IAW SRM & DWG.SDR SWAA2014092232186Sign · looseLEFT EMER OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW AMM.SDR SWAA2014101432929Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 BETWEEN STRINGER 16L TO 17L. REPAIRED CHORD IAW EO & EA.SDR SWAA2014101432928Structure · crackedINNER CHORD CRACKED AT BS 348.5 STRINGER 17L. REPAIRED CHORD IAW EO & EA.SDR SWAA2014101032861Rib · crackedLEFT WING RIB CRACKED AT LOWER CHORD WBL 135.50 BETWEEN STRINGER 2 & 3. REPAIRED RIB IAW EA.SDR SWAA2014101032853Skin · crackedFUSELAGE SKIN CRACKED AT STATION 951+3 TO 951+10.5 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014101032852Skin · crackedFUSELAGE SKIN CRACKED AT STATION 951+4 TO 951+10 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014101032851Skin · crackedFUSELAGE SKIN CRACKED AT STATION 951+8 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014100932833Frame · crackedFRAME CRACKED AT BS 967 BETWEEN STRINGER 22L TO 23L. R & R FRAME IAW SRM & DWG.SDR SWAA2014100832759Frame · brokenFRAME BROKEN AT BS 727D STRINGER 20R. R & R FRAME IAW SRM & DWG.SDR SWAA2014100732693Angle · crackedBEAM CHORD ANGLE CRACKED AT BS 348.2 STRINGER 17L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014093032466Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908 STRINGER 8L. R & R CLIP IAW DWG & SRM.
Back to Boeing 737-3H4