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 SWAA2014102233278Downlock Sensor · out of adjustAFTER EXTENDING LG LT MAIN INDICATED RED. RECYCLED GEAR & CAME BACK WITH ALL 3 GREEN. ADJUSTED DOWNLOCK SENSOR GAP IAW MM.SDR SWAA2014102233303Tab · delaminatedRIGHT ELEVATOR TAB UPPER SURFACE DELAMINATED. R & R TAB IAW MM.SDR SWAA2014103133596Stringer Clip · crackedFUSELAGE STRINGER CLIP CRACKED AT STATION 727D STRINGER 6L. R & R CLIP IAW SRM.SDR SWAA2014102933450Bracket · crackedBENEATH WING TO BODY PANEL 3479R, SUB STRUCTURAL BRACKET CRACKED AT APPROX BS 540. R & R DOUBLER IAW DWG.SDR SWAA2014102233241Slide · looseR2 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014102233253Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT OF COMPARTMENT CONTAINER. REINSTALLED SLIDE IAW MT.SDR SWAA2014103033518Frame · crackedLOWER STUB FRAME CRACKED AT BS 294. R & R STUB FRAME IAW SRM & DWG.SDR SWAA2014102233235Cover · missingL1 DOOR EXIT LENS COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2014112134386Frame · crackedFRAME CRACKED AT BS 360, STRINGER 13R. REPAIRED FRAME IAW EA.SDR SWAA2014111834279Splice · crackedCHORD SPLICE CRACKED AT BS 540 BETWEEN STRINGER 21R TO 22R. R & R SPLICE IAW EA, SRM & DWG.SDR SWAA2014111834278Splice · crackedCHORD SPLICE CRACKED AT BS 540 BETWEEN STRINGER 21L TO 22L. R & R SPLICE IAW EA, SRM & DWG.SDR SWAA2014102933454Angle · damagedINTERCOSTAL ANGLE DAMAGED AT BS 348.2, BETWEEN STRINGER 13L TO 17L. R & R ANGLE IAW EA.SDR SWAA2014102233239Frame · crackedFRAME CRACKED AT BS 400 STRINGER 14L. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2014102233236Tab · delaminatedLEFT ELEVATOR TAB DELAMINATED. R & R TAB IAW MM.SDR SWAA2014103033552Skin · crackedAFT CARGO DOOR CUT OUT FWD LOWER CORNER CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014103033525Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727D STRINGER 5R. R & R CLIP IAW SRM.SDR SWAA2014103033524Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727E STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2014102333328Angle · crackedLOWER ANGLE CRACKED AT BS 348 STRINGER 15L. R & R ANGLE IAW DWG & SRM.SDR SWAA2014102233308Lens · brokenFORWARD LT ESCAPE SLIDE LIGHT LENS BROKEN. R & R LENS ASSEMBLY IAW AMM.SDR SWAA2014102233304Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B STRINGER 11R. R & R CLIP IAW DWG & SRM.SDR SWAA2014102233263Reveal · crackedFORWARD CARGO DOOR CUT OUT FWD LOWER CORNER REVEALED CRACK. REPAIRED REVEAL IAW EA.SDR SWAA2014102233233Intercostal · crackedINTERCOSTAL ASSEMBLY CRACKED AT BS 348.2 STRINGER 16L. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2014102033131Battery Pack · dischargedRIGHT BULLNOSE EMER EXIT LIGHTS INOPERATIVE BETWEEN ROW 13 TO 24. R & R BATTERY PACK IAW MM.SDR SWAA2014111134034Skin · crackedSKIN CRACKED AT BS 500 STRINGER 14R AT 3 & 9 O' CLOCK POSITIONS. REPAIRED SKIN IAW EA.SDR SWAA2014111134033Skin · crackedSKIN CRACKED AT BS 380 STRINGER 14R AT THE 5 O' CLOCK POSITION. REPAIRED SKIN IAW EA.SDR SWAA2014111134023Light · brokenFORWARD LAVATORY EMER EXIT LIGHT ASSEMBLY BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014110333655Stringer Clip · crackedCRACKED STRINGER CLIP CRACKED AT BS 907 STRINGER 8L. R & R CLIP IAW SRM.SDR SWAA2014103033523Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727C STRINGER 4L. R & R CLIP IAW SRM.SDR SWAA2014101733091Flap · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED INBD END. R & R IAW AMM.SDR SWAA2014101733099Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014111134021Skin · crackedSKIN CRACKED AT BS 826 STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014111134022Skin · crackedSKIN CRACKED AT BS 806 STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014110533760Light · delaminatedFORWARD EEPLS DELAMINATED. R & R EEPLS IAW MM.SDR SWAA2014110333654Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 847 STRINGER 1. R & R CLIP IAW SRM.SDR SWAA2014110333653Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 807 STRINGER 3R. R & R CLIP IAW SRM.SDR SWAA2014110333652Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 787 STRINGER 1. R & R CLIP IAW SRM.SDR SWAA2014110333648Sign · corrodedFORWARD LAVATORY MOUNTED EMER EXIT SIGN FASTENER ATTACH POINTS CORRODED. REMOVED & INSTALLED SIGN ASSEMBLY IAW AMM.SDR SWAA2014110333601Sign · delaminatedAFT LAVATORY MOUNTED EMER EXIT SIGN FASTENER ATTACH POINTS DELAMINATED. R & R SIGN IAW AMM.SDR SWAA2014103033522Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 887 STRINGER 2L. R & R CLIP IAW SRM.SDR SWAA2014103033521Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 867 STRINGER 2R. REPAIRED CLIP IAW SRM.SDR SWAA2014103033520Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 847 STRINGER 2R. REPAIRED CLIP IAW SRM.SDR SWAA2014102233302Skin · crackedRIGHT WING LE EDGE SKIN CRACKED AT WING STATION 196.8. REPAIRED SKIN IAW EA.SDR SWAA2014102233301Skin · crackedLEFT WING LE SKIN CRACKED AT WING STATION 196.8. REPAIRED SKIN IAW EA.SDR SWAA2014102233232Skin · delaminatedRIGHT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014102233231Skin · delaminatedLEFT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014101733098Gusset · crackedL1 DOOR LOWER RT CORNER OF GUSSET CRACKED. R & R DOOR IAW MM.SDR SWAA2014101733100Cover · missingAFT GALLEY SERVICE DOOR EXIT LIGHT COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2014103033517Support · crackedRIGHT AFT WING TO BODY FAIRING SUPPORT STRUCTURE HORIZONTAL SHELF OTBD CHORD CRACKED AT BS 727 STRINGER 19R. R & R CHORD IAW SRM & DWG.SDR SWAA2014102333323Lock Ring · missingL1 DOOR LOCK RING ON BOTTOM RADIOS LINK PIN MISSING. INSTALLED LOCK RING IAW MM.SDR SWAA2014102233237Lens · faultyRIGHT OVERHEAD BIN EMER LIGHT LENS FAULTY AT ROW 24. R & R LENS IAW AMM.
Back to Boeing 737-3H4