Boeing 737-3Y0
Service difficulty reports · 3,007
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 = '7373Y0' 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 = '7373Y0' 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 SWAA075086Strip · wornDURING SCHEDULED HC2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT FWD CABIN. REMOVED AND REPLACED STRIP PER MM.SDR SWAA075085Light · brokenDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075087Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 806, STR 19L. REPAIRED SKIN PER SWA EA.SDR USAA920070863Skin · crackedPHX - MAJOR REPAIR - NR 4313819, CRACKED FUSELAGE SKIN, BS 700, S27L - S27R. REPAIRED FUSELAGE SKIN, BS 700, S27L - S27R IAW B737-300 SRM 53-60-12-2R2.SDR SWAA074558Lens · crackedDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074557Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA074182Lens · crackedBULL NOSE EMERGENCY EXIT LIGHT LENS CRACKED AT ROW 20 ABC. REMOVED AND REPLACED LENS PER MM.SDR SWAA074118Light · brokenDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074020Engine · flamed outUPON LANDING AND DECELERATION IN PHX NR 2 ENGINE FLAMED OUT. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA073855Light · inoperativeDURING SCHEDULED BRDG CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073865Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND KEEL BEAM CORRODED BETWEEN BS 727 AND BS 727A, RBL 7 AND LBL 17. REPAIRED KEEL BEAM PER ER.SDR SWAA073856Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA073864Pressure Blkhd · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 7L. REPAIRED BULKHEAD PER SRM.SDR SWAA073861Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073862Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073860Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073859Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073858Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 747, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073863Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073857Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073854Battery Pack · dischargedDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073705Torque Tube · wornDURING SCHEDULED BRDG CHECK, RIGHT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR OUTPUT TORQUE TUBE PER MM.SDR SWAA073706Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 727A, STR 22L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073707Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 847, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073655Stringer · corrodedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 26R CORRODED AT BS 867. REPAIRED STRINGER PER SRM.SDR SWAA073654Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073619Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA073567Fitting · crackedDURING SCHEDULED BRDG CHECK, FOUND RT ELEVATOR TAB INBOARD FITTING CRACKED. REMOVED AND REPLACED ELEVATOR TAB PER SWA EA.SDR SWAA073568Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA073569Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA073570Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA073571Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 23L. REPAIRED WEB PER SRM.SDR SWAA073548Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073547Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073527Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 780, STR 21L. REPAIRED SKIN PER SRM.SDR 2007F00042Indicator · stuckAFTER TAKEOFF AT DFW, RIGHT MAIN GEAR LIGHT RED, GEAR HANDLE WAS IN THE OFF POSITION. FLIGHT DECK CREW CHECKED QRH, BURNED OFF FUEL TO PREVENT OVERWEIGHT LANDING AND PERFORMED AN "AIR RETURN TO DFW", LANDED WITHOUT FURTHER INCIDENT AT DFW. THE AWXA MAINTENANSDR SWAA073431Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER ER.SDR SWAA073432Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730B, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA072782Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072776Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072640Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072606Skin · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA072405Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071923Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 390, RBL 3. REPAIRED SKIN PER ER.SDR SWAA071924Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, LBL 1. REPAIRED SKIN PER ER.SDR SWAA071925Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, RBL 3. REPAIRED SKIN PER ER.SDR SWAA071880Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA071887Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BL 0. REPAIRED SHEAR TIE PER ER.SDR SWAA071868Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT UPPER FWD CORNER BETWEEN BS 289.5 AND BS 290.5, WL 233 TO WL 255. REPAIRED SKIN PER ER.SDR SWAA071837Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504C, STR 15R. REPAIRED SKIN PER SWA EA.
Back to Boeing 737-3Y0