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 SWAA107643Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107642Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107641Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107640Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107639Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107638Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107637Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107636Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 19R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107635Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107634Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107633Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107632Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107631Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107563Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107562Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107561Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107560Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107559Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107558Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107557Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107556Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107555Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107554Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107553Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107552Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107551Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 1. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107550Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107549Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107548Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107547Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107459Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107458Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107433Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107432Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107431Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107430Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107429Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107428Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 1. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107501Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SI.SDR USAA20101202SB198Fuse · blownDFW - WHILE REPLACING DISLODGED BULKHEAD EMERGENCY EXIT LIGHT AT EXIT ROW 15, RIGHT SIDE, MAINTENANCE FOUND NO POWER TO THE LIGHT ASSEMBLY. MAINTENANCE REMOVED AND REPLACED THE FUSE IN EMERGENCY EXIT LIGHT POWER SUPPLY BASE. OPERATIONAL CHECK GOOD.SDR USAA2010112692669Lamp · defectiveFLT 668 - PHX - ON FINAL APPROACH THE AFT RIGHT LAVATORY SMOKE DETECTOR SOUNDED. FLIGHT ATTENDANT CHECKED LAVATORY COULD FIND NO FIRE BUT SMELLED A BURNED ELECTRICAL ODOR. ODOR WAS NOTICED AT AFT LEFT ATTENDANT WORK LIGHT. NO DEFECTS FOUND, NEW LAMPS INSTALSDR USAA20101124SB195Wire · shortedPHX - APPROXIMATELY 10 MILES FROM AIRPORT WHILE ON FINAL APPROACH, THE SMOKE ALARM FOR THE AFT RIGHT LAVATORY WENT OFF AND WAS HEARD IN COCKPIT BY FLIGHT CREW. FLIGHT ATTENDANT CHECKED LAVATORY. NO FIRE BUT COULD SMELL SMOKE. CREW DECLARED AN EMERGENCY WITH SDR SWAA107080Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 26. REPAIRED BEAM PER ER AND EA.SDR SWAA106697Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 736.5, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA106696Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND SKIN CORRODED BETWEEN BS 734 TO BS 740, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA106645Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER EA.SDR SWAA106530Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA106529Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 747, STR 27R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA106528Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 727C, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA106511Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER EA.
Back to Boeing 737-3Y0