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 SWAA2016042051130Angle · crackedLEFT WING ANGLE CRACKED INTERNAL CAVITY ON TE RSS 546. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041951077Angle · crackedLEFT WING TE ANGLE CRACKED ON WBL 184. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041250823Duct · crackedDIVERSION & DECLARED EMER. CABIN STARTED CLIMBING WHILE LEVEL AT CRUISE FL360. CABIN ALT HORN SOUNDED. FOUND BLEED DUCT CRACKED AT AFT KEEL BEAM. R & R BLEED DUCT IAW MM.SDR SWAA2016041250809Sign · looseFORWARD ENTRY DOOR EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2016041250800Sensor · faultyDIVERSION, LT ENG VERY SLOW TO SPOOL. LONG DELAY & SPLIT VERSUS RT ENG. R & R LT ENG COMPRESSOR INLET TEMPERATURE SENSOR IAW AMM.SDR SWAA2016041250799Lens · missingLEFT OVERWING EMER EXIT LIGHT LENS MISSING. INSTALLED LIGHT ASSEMBLY IAW SIP.SDR SWAA2016041250798Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016050951601Lens · brokenFORWARD GALLEY AREA LAVATORY EMER EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2016050951600Lens · brokenAFT GALLEY AREA EMER EXIT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2016050951599Support Fitting · crackedFORWARD GALLEY AREA SUPPORT CLIP CRACKED AT BS 348.20, STRINGER 11L. R & R CLIP IAW SRM & DWG.SDR SWAA2016050351507Skin · delaminatedTAIL CONE FUSELAGE SKIN DELAMINATED AT BS 1156+21, LBL 13. REPAIRED SKIN IAW SRM.SDR SWAA2016041150727Window · arcedL1 OUTER PANE ARCED THEN CRACKED. R & R NR 1 WINDOW IAW MM.SDR SWAA2016060652365Latch · crackedRIGHT AFT CARGO COMPARTMENT, DOOR CHANNEL LATCH CRACKED, BETWEEN BS 787 - 807. REPAIRED LATCH IAW EA.SDR SWAA2016052051962Glowstrip · deterioratedLEFT PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING STRIP DETERIORATED. R & R STRIP IAW AMM & DWG.SDR SWAA2016052051961Glowstrip · deterioratedRIGHT PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING STRIP DETERIORATED. R & R STRIP IAW AMM & DWG.SDR SWAA2016050951646Web · crackedLEFT WING AFT VERTICAL WEB CRACKED IN THE NR 5, B FASTENER HOLE AT RSS 221. REPAIRED WEB IAW EA.SDR SWAA2016050951645Web · crackedRIGHT WING AFT VERTICAL WEB CRACKED IN THE NR 5, B FASTENER HOLE AT RSS 221. REPAIRED WEB IAW EA.SDR SWAA2016050451546Skin · crackedRIGHT WING UPPER SKIN CRACKED IN OPEN HOLE AT RSS 239 IN AFT FASTENER ROW. REPAIRED SKIN IAW EA.SDR SWAA2016050451545Skin · crackedRIGHT WING UPPER SKIN CRACKED IN OPEN HOLE AT RSS 254 IN AFT FASTENER ROW. REPAIRED SKIN IAW EA.SDR SWAA2016050351523Bracket · crackedRIGHT WING UPPER SPAR CHORD BRACKET CRACKED AT RSS 235. R & R BRACKET IAW DWG & EA.SDR SWAA2016042051129Strap · brokenAFT LT LAVATORY FLASHLIGHT STRAP BROKEN. R & R STRAP IAW CMM.SDR SWAA2016042051128Flashlight · brokenFORWARD GALLEY EMER FLASHLIGHT BASE BROKEN. R & R FLASHLIGHT ASSEMBLY IAW CMM.SDR SWAA2016060652354Channel · crackedAFT CARGO COMPARTMENT CHANNEL CRACKED BETWEEN BS 847 - 867, STRINGER 25R. R & R CHANNEL IAW SRM & DWG.SDR SWAA2016052352008Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20R - 21R. REPAIRED FRAME IAW EA.SDR SWAA2016041250817Light · missingFORWARD ENTRY EMER LIGHT LENS MISSING. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016041150776Sign · looseL1 DOOR EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2016041150775Light · inoperativeRIGHT EXTERIOR OVERWING EMER EXIT LIGHT INOPERATIVE. RELAMPED BULBS IAW AMM.SDR SWAA2016041150774Battery Pack · dischargedRIGHT EMER LIGHT INOPERATIVE, BETWEEN ROW 20 - 24. R & R BATTERY PACK IAW AMM.SDR SWAA2016051651852Spar · crackedRIGHT WING AFT SPAR, UPPER CHORD CRACKED AT RSS 221, NR 5 FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2016051651825Spar · crackedLEFT WING AFT SPAR UPPER CHORD CRACKED AT RSS 221, NR 5 FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2016050951667Light · inoperativeRIGHT STOW BIN BULLNOSE EMER EXIT LIGHT INOPERATIVE AT ROW 16. R & R LIGHT IAW AMM.SDR SWAA2016042551265Skin · crackedSKIN CRACKED AT BS 949, STRINGER 23L. REPAIRED SKIN IAW ER & EA.SDR SWAA2016042051127Cover · crackedR1 DOOR EMER EVAC SLIDE COVER CRACKED. REPAIRED COVER IAW EA.SDR SWAA2016041150773Skin · crackedFUSELAGE SKIN CRACKED AT BS 952, STRINGER 11R. REPAIRED SKIN IAW EA.SDR SWAA2016042651331Skin · crackedSKIN CRACKED AT BS 929, STRINGER 23L. REPAIRED SKIN IAW SRM.SDR SWAA2016040750684Lens · looseFORWARD GALLEY EMER EXIT SIGN COVER EMER LOOSE. SECURED LENS IAW SIP.SDR SWAA2016050351521Fairing · delaminatedRIGHT WING TE FLAP TRACK FAIRING 3601, LE DELAMINATED. R & R FAIRING IAW WC.SDR SWAA2016050351520Fairing · delaminatedLEFT WING TE FLAP TRACK FAIRING 3501, LE DELAMINATED. R & R FAIRING IAW WC.SDR SWAA2016050351500Spar · crackedLEFT WING REAR SPAR LOWER CHORD CRACKED AT RSS 213, HOLE COMMON TO REAR WEB SPLICE. REPAIRED CHORD IAW EA.SDR SWAA2016041550939Angle · crackedLEFT WING REAR SPAR ANGLE CRACKED AT WBL 171. R & R ANGLE IAW DWG & SRM.SDR SWAA2016041150771Transmitter · faultyAT CRUISE HYD SYS A PRESS INDICATOR READ 900 PSI A HYD QTY NORMAL. ALL A SYSTEMS OPERATED NORMALLY & PRESS LIGHTS NORMAL AFTER GEAR EXTENSION, HYD SYS A INDICATION NORMAL THROUGH SHUTDOWN. R & R A HYD SYS PRESS TRANSMITTER AMM.SDR SWAA2016040750692Light · inoperativeFORWARD GALLEY A LAVATORY EMER EXIT LIGHT BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2016040750683Lens · loosePASSENGER CABIN CTR AISLE OVERHEAD CEILING PANEL EXIT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2016040750678Girt Bar · looseR2 DOOR EMER EVAC SLIDE GIRT BAR LOOSE. SECURED GIRT BAR IAW AMM.SDR SWAA2016040650637Light · inoperativeRIGHT EMER EXIT HATCH BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2016041250812Shear Tie · corrodedSHEAR TIE CORRODED AT BS 807, STRINGER 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016041150791Angle · corrodedSTRAP ANGLE CORRODED, BETWEEN BS 967 - 981, STRINGER 21R. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041150790Angle · corrodedANGLE CORRODED, BETWEEN BS 943 - 955, STRINGER 21R. R & R ANGLE IAW SRM & DWG.SDR SWAA2016040450580Lens · looseFORWARD ENTRY LOWER EMER EXIT LENS LOOSE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016051951959Skin · crackedRIGHT WING UPPER SKIN PANEL CRACKED AT AFT HOLE OF RSS 262. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4